1. Have you experienced a NEGATIVE (-) ALLOCATION? How can this happen?
2. Given this scenario : Item A has stocks in both Site 1 and Site B with "0" and "100" cases respectively, with Site 1 as the default site ID. A Sales Order encoder accidentally picked Site 1 with "0" quantity and he was able to complete transaction until posting. He said there was no error advice or whatsoever. How can this happen when the Inventory Control Setup clearly prohibits this to happen. I mean we checked all possible settings that will allow such transaction, but it happens.
Hoping to hear from our GP Experts. Thanks in advance!
*This post is locked for comments
Thank you Harry and Shan for the tips.
Actually, what we would really like to find out what's really causing this ever recurring problem. Sounds like it is a GP issue as well in other users and has been around from sometime.
Hi,
It could be a posting interruption when user posting their transactions. As explained by Harry, in GP there are setting to prevent the user. In order to solve this problem you need to run the reconcile for the SOP,POP & Inventory. If you have the basic modules installed.
Note: Take a backup before doing the process.
Kindly take a look at the link provided will give you more details about your issue and how to process the reconcile.
There are numerous settings in Sales Order Processing setup, to control the allocation of Inventory to Sales Orders. If they are configured as you describe, then when an allocation at the line item level drove the Quantity on Hand negative, the user should have encountered a dialogue, which asked them what to do about the shortage (i.e. sell the balance, cancel the balance, override the shortage, etc.)
The first step in this process, were I tasked with sorting it out, would be to create a test database and exhaustively test the scenario to validate what the user is telling you. This will ensure you're not chasing your tail.
I would also recommend you run the Inventory Reconciliation Utility, which should straighten out any problems with Inventory allocations.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156