ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Duplicate Items Numbers
http://www.istechforum.com/YaBB.pl?num=1611156016

Message started by DJ Yates on 01/20/21 at 08:20:15

Title: Duplicate Items Numbers
Post by DJ Yates on 01/20/21 at 08:20:15

We went to look up a part number (ARTRUS019) and the original part number was missing and another part number (HYTCON001) had it's description and was listed in Enter Inventory Items twice, but can only click on one.

Title: Re: Duplicate Items Numbers
Post by Vman on 01/20/21 at 14:40:41

You can try running a Master Level Reconciliation SM-J-C. This may correct some or all of the issues. You can run it in report only mode which will not change anything and you can look at what it finds.
There are two master inventory files- BKICMSTR for accounting and MTICMSTR for manufacturing. They can get out of sync and sometimes when EVO "burps" it will create duplicates.
It may be necessary to edit one of both of the files using Maintain Database to correct the error. Back everything up first.

Title: Re: Duplicate Items Numbers
Post by prophet on 01/21/21 at 09:31:02

If you are running EVO and or up to date i have a simple query which you can run in DE-A on the BKICMSTR and MTICMSTR files and it will tell you if there are any duplicates in the those two files. They are two separate query's. They run quick. If there are then you simply use maintain database to fix it. Let me know if you want it and I can paste it here for you.

Title: Re: Duplicate Items Numbers
Post by DJ Yates on 01/21/21 at 10:59:22

Yes, please provide link

Title: Re: Duplicate Items Numbers
Post by prophet on 01/21/21 at 11:50:19

There are two separate queries. You have to run them separately. Simply copy them then go to System Mgr then DE-A and past it in the window and execute or export. It will tell you if there are any duplicate part numbers in that file. If there are then you will need to use Maintain Database to fix it(aka delete one)

select bkic_prod_code, count(*)
from bkicmstr
group by bkic_prod_code
having count(*) > 1

Second query

select mtic_prod_code, count(*)
from mticmstr
group by mtic_prod_code
having count(*) > 1