ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> BKICMSTR PART NO DUPLICATED
http://www.istechforum.com/YaBB.pl?num=1310590337

Message started by carolg on 07/13/11 at 13:52:17

Title: BKICMSTR PART NO DUPLICATED
Post by carolg on 07/13/11 at 13:52:17

I have a Crystal Report that is off by part # 80257. In the BKICMSTR file there are two of that part number. There seems to be different activity on each one so I don't want to delete one. Is there any way to combine them or change transaction history.

Title: Re: BKICMSTR PART NO DUPLICATED
Post by Kelloggs on 07/14/11 at 11:11:46

What do you mean by "Activity"? Inventory transactions? Do you have Locations?

If the duplicates are only on the BKICMSTR, to fix them you will have to do it manually: add the quantity on hand then delete one of the records.

check for more duplicates:

select distinct BKIC_PROD_CODE from BKICMSTR
group by BKIC_PROD_CODE
having count(BKIC_PROD_CODE ) > 1
order by BKIC_PROD_CODE

do the same for the MTICMSTR table

check this post
http://www.istechforum.com/YaBB.pl?num=1281714671/8#8

:-[

:-X