ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> Unable to remove old Cycle Counts
http://www.istechforum.com/YaBB.pl?num=1577738513

Message started by gtladmin on 12/30/19 at 13:41:53

Title: Unable to remove old Cycle Counts
Post by gtladmin on 12/30/19 at 13:41:53

Shipping needs to delete at least 5 old cycle counts, but these seem to have no locations listed and so they cannot figure out how to delete them using PI-H.

Any way to do this? Do we have to use maintain DB to remove these counts? (tables BKPIMSTR and BKIPHYS?)

Please advise, thanks!

Kind regards,

Val

Title: Re: Unable to remove old Cycle Counts
Post by Lynn_Pantic on 12/31/19 at 09:26:20

You could use UT-K-B to populate the blank Location fields with a valid Location and then you should be able to delete them normally.

Title: Re: Unable to remove old Cycle Counts
Post by gtladmin on 12/31/19 at 10:36:48

Ahhh...never thought of that! DAH! I always forget about that util.

I manually removed the entries from the BKPIMSTR and the BKPIPHYS tables (all other PI tables are empty). Change the loc in the BKPIPHYS table would have been the way to go.

Thank you!! Noted for future reference. :-)

Kind regards,

Val