Newly Received Items Inquiry Not Showing Proper Column as Labeled
Q - We ran into something that seems off on the "Newly Received Items Inquiry." When doing the query it shows Qty-Rec, Qty-OH, and Avail. Avail is not correct. It seems as if it is just copying off of one of the other two fields. I have provided two screen shots below. They deal with item # AB762HP. You will notice in the first pic that it shows Qty-Rec - 96, Qty-OH - 96, and Avail - 96. But when doing a Stock Status Inquiry, it shows that we actually have -257 available. Would it be possible to get this fixed so that we can see the accurate Availability on the Newly Received Items Inquiry? Please see my sample screen below.
A - The column "Avail" in the Newly Received Item Inquiry screen has a different definition than what you may expect. It is calculated as:
Qty-OH - Qty-Alloc + Qty-BO
In your example:
Qty-OH = 96
Qty-Alloc = 353
Qty-BO = 353
So 96 - 353 + 353 = 96
There are two types of quantity available:
Long-Term Available = Qty-OH - Qty-Alloc
But since orders could be on back order, if you exclude those orders on back order, then your short-term available is
Short-Term Available = Qty-OH - Qty-Alloc + Qty-BO
We also call Short-Term Available "Excess Qty." This is the quantity availability to fill back orders.
To avoid confusion, we just changed the wording of the Newly Received Items Inquiry "Avail" column to "Excess."
Related Articles
Feature - Only Show Active Items in Newly Received Item Inquiry
Release Date: 12/12/2019 Version: 8.5 & Up A new Global Setup flag has been added to Dist -> COP Global Control: 5. Show Active Items Only in Newly Received Inq? The default is "N," which means all items will be displayed. See sample screen below: if ...Feature - Added a Drill Down to Order by Item Inquiry in Newly Received Items Inquiry
Release date: 1/8/2020 Version 8.5 and up A new "F1/F2=Open Ord/Quo" option has been added to: COP-> Inquiry-> Newly Received Items Inquiry Pressing the F1 key will display all open orders for the highlighted item. Pressing the F2 key will display ...CP01012 Customer Order Processing Newly Received Item Inquiry
Newly Received Item Inquiry Application Overview This application is a useful sales tool to see which “Key Items” have been received. A key item can be a hot or fast moving item preferred by customers and usually tracked by salesmen. As soon as these ...Feature - Show Previous Qty OH in Newly Receive Inquiry
Release Date - 3/31/16 A new column has been added to COP -> Inquiry -> Newly Received Item Inquiry. The PrevOH column shows the item's on-hand quantity at the receiving location before the receipt is processed. The information is captured when ...Feature - Prevent Drill Down Newly Received Item Inquiry from Sales Desk If User Does Not Have Menu Access
Release Date: 12/12/2019 Version: 8.5 & Up A new Global Setup flag has been added in Cop-Ctl -> Sales Desk: 33. Can Drill Down Newly Rec W/O Menu Inq Right? The default value is "Y." See sample screen below: In the past, the user was able to drill ...