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
IM0500Q Inventory Management Stock Status Inquiry
Stock Status Inquiry Application Overview This function provides you with a wealth of customer service information available by using Function Keys. For maximum benefit, the users should thoroughly familiarize themselves with the many item inquiry ...IM0500 Inventory Management Stock Status Inquiry
Stock Status Inquiry Application Overview The Stock Status Inquiry application is used to quickly and easily find the quantity of any inventory item which is on hand, allocated, or on order. . All information can be obtained for any particular ...Feature - Stock Status Reports Add Include with Alloc or On Order Quantity Option
Release date: 8/1/2019 Version: 8.5 and up Several of the Stock Status Reports have an option to "Exclude Zero Qty Items." This features allows for a new option to include items with zero quantity on hand if the item's quantity allocated or quantity ...Blanket POs Not Displaying on Stock Status ATP Screen
Release Date: 3/20/2019 Q - How can I get Blanket POs to display on the Stock Status ATP screen? You show it on the legend as code "PB" but it doesn’t appear on the screen. See sample screen below: We use the blanket PO for estimated dates for ...Feature - Addition of TOR, QtyOH, OHValue to Stock Status Inquiry
Release date 9/3/2020 Version 8.5 & Up The purpose of this feature is to evaluate how planners manage the inventory in the past and the foreseeable future. For this reason, we added the following new columns to Stock Status Inquiry -> Location ...