Welcome, Guest. Please Login.
05/24/25 at 08:41:07
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › System Manager ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Duplicate Record - How to delete it? (Read 889 times)
Teresa_Shirley
Browser
*


I love YaBB 1G -
SP1!

Posts: 6
Duplicate Record - How to delete it?
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?
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Duplicate Record - How to delete it?
Reply #1 - 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.
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 784
Gender: male
Re: Duplicate Record - How to delete it?
Reply #2 - 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.
 
 Tongue
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › System Manager ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge