Welcome, Guest. Please Login.
05/08/24 at 01:43:22
News:
Home Help Search Login


ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
Unable to remove old Cycle Counts (Read 409 times)
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Unable to remove old Cycle Counts
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
Back to top
 
 
Val Feehan
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: Unable to remove old Cycle Counts
Reply #1 - 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.
Back to top
 
 
Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
gtladmin
Active Member
*****


Diving is fun,
diving is fun!

Posts: 1306
Gender: female
Re: Unable to remove old Cycle Counts
Reply #2 - 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. Smiley
 
Kind regards,
 
Val
Back to top
 
 
Val Feehan
  IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Evo-ERP and DBA Classic › Items ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge