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.