Item Quantity Allocation Is Incorrect
Q - We have been running into issues with certain items where the allocation isn't correct, as you can see in the sample screen below. The Item Quantity Allocated is zero.
But if you drill down to the ATP Inquiry screen, you can clearly see there are sales orders for this item. See sample screen below.
After I run the Reset Item Quantity Allocation, the quantity allocation still stays at zero. But if I run Regenerate ATP, the five sales orders for the ATP stay the same. I can bring up these five sales orders manually and prove that they are valid orders. So the question is why doesn't their quantity allocation show up even after I run the Reset Allocation?
A - You should take a look at how this item is set up. See the sample screen of the Item Master below:
When field "9. Controlled Flag" is set to "N," then the behavior you described will happen. If you look up the online help, you will find the following explanation of this field:
If an item is controlled, it is allocated when customer or shop orders are issued for it and deallocated when the order is shipped or the materials are issued to the shop. This allocation and deallocation does not occur for a non-controlled item.
If this is your case, simply set this flag to "Y" and run the Reset Allocation to resolve this problem.
Related Articles
What Cause Quantity Allocated to Drift That Requires Running Reset Allocated Quantity?
Release Date: 7/8/2025 Version: All Q - Production Manager was entering a Material Work Order this morning and received notification that the Quantity on Hand was insufficient even though the component was physically available. I was unable to track ...Feature - Allow Over Allocation for Certain Locations and Users
Release Date: 2/27/24 Version: 8.5 and Above A new option is available in Global Setup-> COP-Func-> Order Line Item Screen-> 12. Allow Qty-To-Ship > Excess Qty (OH-Alloc+BO) that allows over allocation to occur for specific locations for specific ...Change - Price Recalculation When Quantity Changes
Release Date - 6/25/18 A change was made to how prices are recalculated on the Order Line Item screen in Order Entry. When you first enter a line item: The system will calculate the proper unit price based on price codes on file. If the calculated ...Common Issues Raise Questions about QTYAVAILBYCOMP Stock Qty Avail
Released Date: 10/01/20 Version: 8.5 & up For those users who use the QTYAVAILBYCOMP attribute, they may frequently have questions on how the value of "Stock Qty Avail" in QTYAVAILBYCOMP is calculated. See sample screen below: Well, it is ...Feature - Case Size Support for Quantity Per Box
Release Date: 4/23/19 Version: 8.5 and up Quantity per box is set up in Global Setup -> Dist -> I/M Global Control, Screen 2, flag “2. Use Which Item Field For Quantity/Box ?” This feature adds item case size to the available options. For users who ...