ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> unable to find the BKICMSTR record for part xxxx
http://www.istechforum.com/YaBB.pl?num=1537541511

Message started by JamesO on 09/21/18 at 07:51:51

Title: unable to find the BKICMSTR record for part xxxx
Post by JamesO on 09/21/18 at 07:51:51

A few days ago we deleted a duplicate part "xxxx" from the MTICMSTR and BKICMSTR. All seemed fine.
Today, our finance person was trying to do an IN-F (print inventory report) and she received the message " Unable to find the BKICMSTR record for part "xxxx". This part will be excluded form this report". I did a quick forum search and someone mentioned to make sure the part actually exists in both the MTICMSTR and BKICMSTR. I did just look and the part is in each.
Any ideas on how to fix this?

Thank you,
Jimmy

Title: Re: unable to find the BKICMSTR record for part xx
Post by prophet on 09/21/18 at 11:36:49

make sure the two records match. Part number, Class, those two fields should be exactly the same in both files.

Title: Re: unable to find the BKICMSTR record for part xx
Post by JamesO on 09/26/18 at 08:14:04

I check the tables and did notice that there is one record in the BKICMSTR and 2 in the MTICMSTR. One one of the ones in the MTICMSTR has a slightly different spelling.
I assume that the problem is the extra record?? What to do next??

Title: Re: unable to find the BKICMSTR record for part xx
Post by prophet on 09/26/18 at 09:08:26

If the one that has different spelling has no matching record in the BKICMSTR then go ahead and add the records, code, class, should do it. The reason i say add the record is because I don't know if there is any history for that part. Once you add the record you should be able to bring it up in IN-B and delete it. If it has no history it should let you delete the part. If it does have some history then other steps will have to be taken to get rid of it.