*This post is locked for comments
Thanks Richard. I guess we'll have to solve this one with behavior modification. :) -Trevor
The ONLY way to totally prevent quantities from going negative is to implement serial or lot tracking, not a good move if you don't need it. As for allocations driving quantities negative, they only drive the quantity available (not the quantity on hand) negative. However, when an issue transaction removes more than you have on hand, the quantity on hand will go negative.
Consider what would happen if you did not allow this in the following situation:
1. Items are delivered by UPS
2. Someone needs them and consumes them. (quantity on hand goes negative)
3. The PO Receipt is finally processed, bringing the quantity on hand back up to the expected number.
If yo did not allow the issue to take the quantity negative, here is what would happen.
1. 5 items are on the shelf
2. UPS delivers 10 but they are not received into the software
3. an issue transaction for 10 is posted, reducing inventory to 0 (rather than -5)
4 The PO receipt of 10 pieces is posted, bringing inventory up to 10 when the quantity on hand is actually 5
To fix this for manufacturing and sales, use a scanning system to issue inventory and do not backflush. Backflushing has its place but not for most parts.
I know this is an old thread, but we are seeing inventory allocations causing our available inventory to go negative. This is coming from the manufacturing module. When our planners release an MO, they have an option to override shortages during inventory allocation. How can we prevent this? We have already done the above steps. Thanks. -Trevoir
By all means yes Kishan. my email is fhamelly@intellpartners.com.
thanks Frank. Can i email you if i have any more questions I am new to the GP software so i am now in the learning world.
if you're referring to negative inventory quantities, there are two places you need to maintain settings to prevent negatives -
1. In Inventory>>Setup>>Inventory Control, uncheck all the 'Allow Overrides' boxes.
2. In Sales>>Setup>Sales Order Processing>>Data Entry Defaults>>Quantity Shortage, select an option other than 'Override Shortage'.
Hope this helps,
By negative do you mean negative quantity or negative amount or something else?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
