IM0500 Inventory Management Stock Status 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 infor­mation 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

    • 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 ...
    • IM1904 Inventory Management Serial/Lot Stock Status Inquiry

      Serial/Lot Stock Status Inquiry Application Overview Serial/Lot Stock Status Inquiry is an application that will be used to inquire on available serial/lot items in stock that has been received or allocated into inventory. You may also inquire into ...
    • IM26SCN Inventory Management Frozen Stock Status Report

      Frozen Stock Status Report Application Overview The Frozen Stock Status Report provides information on inventory levels "frozen" in the Freeze Inventory application. This report allows the user to go back and analyze inventory levels and values as of ...
    • 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 ...
    • IM06SCN Inventory Management Stock Status Report

      Stock Status Report Application Overview The Stock Status Report is used to print out stock status information about a selected item or range of items by location and product category. The report can be printed for All locations or for a range of ...