You’re offline. This is a read only version of the page.
Recently we transferred several items from one site ID to another, everything appeared to work properly during this process. Once we went to issue two of these items out, we received system message 904 "insufficient quantity available - please reenter". When we look at the inventory item on screen 10.250.00 (Inventory Items), it shows there being 10 available and 10 on-hand, plenty more than we attempted to issue. Also, on screen 10.255.00 (Inventory Sites) it shows 10 available and 10 on-hand. The only place I can find that shows something different is on the Location screen (10.220.01) where it shows there being 10 on hand but an available quantity of zero. I don't see where any of this product is allocated or assigned to anything so I am at a loss as to why we can't issue any of it. Thank you for your help.
*This post is locked for comments
Erich, thank you very much for your response. You are correct, the two tables did come out of sync somehow and we confirmed this once we looked at the database. We actually had a power interruption yesterday on a user's machine and that person was the one running the process manager. She also happened to be out of the office. We simply kicked off the process manager from my machine, overriding her, and it updated the location table without having to do the integrity check, though I am sure that could have worked as well. Thank you again for pointing us in the right direction.
For some reason, there are two separate tables. One keeps the by-site quantities and the other keeps the by-location ones. This two tables might come out of sync. In my experience, after a transfer this is more likely to happen. You can try the Integrity check (10.990.00). You can do a run on a single item-site and see if the location quantities get fixed.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (