ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> UT-K-G
http://www.istechforum.com/YaBB.pl?num=1403029639

Message started by Prier Products on 06/17/14 at 11:27:19

Title: UT-K-G
Post by Prier Products on 06/17/14 at 11:27:19

Good afternoon,
We have a mystery we would like to solve. We ran UT-K-G twice in the month of May. Both listed a particular part number twice. The first UT-K-G ran did not add the second line of the part number in to the summary of changes, but the second did. We just found out that the part number is listed twice in our system. How do we get rid of one? Which one should we choose to delete/make obsolete?

Title: Re: UT-K-G
Post by Prier Products on 10/02/14 at 03:34:17

If you are experiencing this problem as well, run SM-J-C Master Level, Method A. This worked for us.

Title: Re: UT-K-G
Post by Vman on 10/16/14 at 14:34:30

SM-J-C Transaction level has methods A and B. Master level does not. Anyways, EVO (at least in the years I have used it) has the habit or creating partial part number records, normally in the Inventory Master File Manufacturing. If you look at the file using Maintain Database, the duplicate record or shell will be incomplete. I have had dupes as well as junk records (like part number "M") popup when I run SM-J-C Master. I wonder if sometimes this happens when you are in IN-B and exit out without completing an entry.

Title: Re: UT-K-G
Post by Kelloggs on 10/16/14 at 15:15:14

No only duplicates, some tables have orphan records

Anyways.......

SELECT BKIC_PROD_CODE, COUNT(*) TotalCount
FROM BKICMSTR
GROUP BY BKIC_PROD_CODE
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC

Go to System Mgr
Open DE-A

Paste the query, and click on "Execute"

if you don't have that menu go to
System Mrg
Open UT-A
and enter: SQLEXPORT.RWN

You got Duplicates!!!! ;D

http://www.istechforum.com/YaBB.pl?num=1281714671
Orphan Records

:D

Kelloggs

Title: Re: UT-K-G
Post by Prier Products on 10/17/14 at 06:27:52

Thanks Vman and Kelloggs. I was given these instructions by Hec Tech and it definitely cleared the duplicate part number.