Item Quantity Allocation Is Incorrect

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

    • 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 - PO Item Receiving Allocation

      Release Date: 09/10/2020 Version: 8.2 & Up PO Item Receiving Allocation is a vertical add-on feature with separate licensing required. If you are licensed to use this feature, you can go to Global Setup -> Add-Ons -> Other Add-On License setup. You ...

    • Can System Default Item User-Defined Code?

      Q - When I add an item, can the system automatically default field "4. User Def Code" to "1"? See sample screen below: A - Yes, you can do so by first defining an item "DEFAULT-ITEM." Set the field "4. User Def Code" to "1." See sample screen below: ...

    • Item Quantity Allocated Is Not Updated

      Release Date: 12/6/2019 Version: All Q - Dear Netcellent Support -- Upon entering an order the item file is not updating (in some instances) the quantity allocated field. We have run a reset but this does not resolve the issue. Can you advise? A - ...