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 stocking location, or as a summary for all stocking locations.
Additional Information is available via the use of the following functions keys
F1 = Subs Item Search Allows you to search for substitute item numbers or by Substitute Item Class if setup.
F2 = Comp Avail Allows drill down to view component items and displays maximum quantity available on component availability.
F3 = ATP Inquire Available To Promise Inquiry
F8 = Multi-Bin Info Only functional if you have the Multi-Bin Vertical package installed.
Run Instructions
From the Inventory Menu à Inquiry à Stock Status
Stock Status Inquiry Entry Screen
Entry Field Descriptions
Name | Type and Description |
1. Item No | 15 alphanumeric characters. Enter the item number of the item into which you are inquiring. Pressing the F7 key will allow you to search for the item-by-item number. Pressing the F8 key will allow you to search for the item by description. |
2. Location | 2 alphanumeric characters. There are three options for entry of this field. 1. (BLANK): Leaving the Location field blank and pressing the RETURN key will cause a summary to be made for all stocking locations for the item. The Quantity On‑Hand, Quantity Allocated, Quantity Backordered and Quantity On‑Order fields are totaled from all locations. The Reorder Level is for the default location, as it is assumed that the other locations order from this location when they hit their own reorder levels. The default location places all external orders for the item. 2. ( *) Wildcard Example A* brings up the Atlanta warehouse. 3. Enter Location Code |
On Hand | This is the quantity of the item, which is actually on-hand at the location. |
Allocated | This is the quantity of the item, which has already been allocated, either internally (to be used as a part or sub-assembly) or by customer orders, which have not yet been filled. |
Available | This is the quantity on-hand minus the quantity allocated. |
Excess – Qty | This is an alternative field to viewing “Available.” This is set in COP Stock status Inquiry Setup |
Backordered | This is the quantity of the item, which has been backordered. |
On Order | This is the quantity of the item which is on order, but which has not yet arrived or produced. For locations other than the default or manufacturing location, it is assumed that the item is on order from the default or manufacturing location. |
Reorder Level | This is the level at which a new order for the item should be placed, in order to avoid running out of the item before the new shipment arrives. |
Bin No. | This is an alternative field to viewing Reorder Level. This is set in I/M global Setup. |
Stock Status Inquiry Screen
Bottom Menu Function Keys:
F1 = Subs Item Search Allows you to search for substitute item numbers or by Substitute Item Class if setup.
F2 = Comp Avail Allows drill down to view component items and displays maximum quantity available on component availability.
F3 = ATP Inquire Available To Promise Inquiry
F8 = Multi-Bin Info Only functional if you have the Multi-Bin Vertical package installed.
Related Articles
Avalara - Stock Status Inquiry
Release Date: 4/28/23 Version: 8.6 and Above When the Avalara Integration is enabled, the Stock Status Inquiry that is launched from Customer Order Processing-> Inquiry-> Stock Status Inquiry will show the estimated tax percentages for a customer ...Feature - Add Age Days and Last Calculated Date to Stock Status Inquiry
Release date 1/9/2021 Version 8.5 & Up This feature adds "age days" and "last calculated date" to the Stock Status inquiry screen. These fields come from Item File Maintenance field 27: Age days is a good way to indicate what your inventory turnover ...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 ...Feature - Added Browse Through Items When in the Stock Status Inquiry
Release date: 9/28/2018 Added the ability to browse through items when in the Stock Status Inquiry. The first time in the application the user must provide the item number and the location. Once the user escapes back to the Item Number field, they ...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 ...