60
We have about 1500 lines in the Bin Quantity Table which are redundant ie QUANTITY =0 and ATYALLOC=0 - where the item did exist at one time in the bin but is no longer there. When I run a stock count it includes all these zero lines which is totally unnecessary.
Is it safe to do a SQL delete where QUANTITY=0 on this table?
*This post is locked for comments
well, took the plunge and ran the script. Everything seems to be ok. Thanks for the help!
No, we had no issues. Are you re-using Stock Counts? After you delete the bins and a Stock Count is created, you should not see these zero bins in the count. Before we started running the procedure at night we used to remove the Zero bins from the Stock Count (AFTER it is created but BEFORE it is started). There were no issues with this (unless the count was started and/or someone was editting the count while we were deleting zeroes-which is a DISASTER.)
Tim
Thanks for the reply Tim. Did this throw up any issues when you did this? Our issue was that even if the item was no longer in that bin - the count sheets continually listed all items that have ever been in that bin location - which was a lot of zero entries!
We do that here every night with a SQL Job. We make sure we don't delete any default bins. I have been planning on refining this procedure to only delete zero bins after a certain amount of time (60 days). Those zero bins might not be unnecessary when you're trying to find (missing) stock during a stock count. But it has worked well for us so far.
DELETE IV00112 WHERE QUANTITY = 0 AND ATYALLOC = 0 AND BIN NOT IN ('APPR','SHIP','INSP','FGRLS','WIP')
Tim
I don't know about deleting those lines, but you can use the Remove Bins Utility to disassociate the bin-item relationships. Several rules exist to prevent valid item-bin relationships from being deleted, so it's probably safer to use this than a SQL script.
This is found under Tools | Utilities | Inventory | Remove Bins.
Also, make sure you don't have any existing stock counts (started or not) in the system when you run this Utility. If an item-bin combo is deleted by the Utility, but then you open up an existing stock count that has this item-bin relationship already defined, it will recreate the relationship.
David
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
