ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> Duplicate Record - How to delete it?
http://www.istechforum.com/YaBB.pl?num=1324590562

Message started by Teresa_Shirley on 12/22/11 at 14:49:22

Title: Duplicate Record - How to delete it?
Post by Teresa_Shirley on 12/22/11 at 14:49:22

After running SM-J-C (Reconcile inventory on hand)

Found duplicate BKICMSTR record for this Part, Manual Review Required

Do you have any suggestions?

Title: Re: Duplicate Record - How to delete it?
Post by Kelloggs on 12/23/11 at 14:05:26

On your Pervasive Control Center

SELECT BKIC_PROD_CODE,
COUNT(BKIC_PROD_CODE) AS NumOccurrences
FROM BKICMSTR
GROUP BY BKIC_PROD_CODE
HAVING ( COUNT(BKIC_PROD_CODE) > 1 )

SELECT * FROM BKICMSTR WHERE BKIC_PROD_CODE ='Enter part id here'

Change the BKIC_PROD_TYPE to X then

DELETE FROM BKICMSTR WHERE BKIC_PROD_TYPE = 'X'

Then run the utility again.

Title: Re: Duplicate Record - How to delete it?
Post by Kelloggs on 12/23/11 at 14:34:30

There are a few more things that have to be "manually fix"
Run this script

SELECT
BKIC_LOC_PROD,
BKIC_LOC_CODE,
BKIC_LOC_UOH
FROM "BKICLOC"
WHERE ASCII(LTRIM(RTRIM(BKIC_LOC_CODE))) = 0

it will show Parts with not location on your location table, watch for the ones with qty on hand.

:P