Inventory Inquiry

The Inventory Detail tab tracks the amount of stock that is On Hand, Reserved, Backordered, In Transfer, On Order from Vendor, On Order from Warehouse, and Requested. The quantities at the stock item level are provided under the Quantities sub tab. The Location sub section displays stock item details at the location level. The Track Quantity By Location flag indicates whether the stock item tracks inventory quantity at the location level (checked) or at the stock item level (not checked).

• The On Hand quantity is updated when a stock item is issued through an Over-the-Counter (OC) transaction or an Issue-Confirmation (CI) transaction, when the stock item is returned through a Stock Return (SN) transaction, received through a Receiver (RC) transaction, or when the stock items are adjusted through an Inventory Adjustment (IA) transaction or Internal Inventory Adjustment (IIA) transaction. When a Stock Transfer Issue (TI) transaction is processed, it will reduce the On-hand quantity for the issuing warehouse.

• The change in Reserved quantity is updated when a Stock Requisition (SRQ) is processed, as well as when a Stock Issue Confirmation is processed.

• The In-Transfer quantity is updated when a stock item is being transferred from one warehouse to another

• The Backordered quantity is updated when there is insufficient On Hand quantity to fulfill a request for issue.

• The Currently Requested Quantity is updated when a Purchase Requisition (RQ) is processed.

• The On Order from Vendor quantity is updated when Purchase Orders are processed.  

Drilldown functionality is available on the following six fields: Reserved Quantity, Released Quantity, Backordered Quantity, In-Transfer Quantity, On-Order Quantity, and Currently Requested Quantity.  By selecting the drilldown icon next to one of the above-mentioned fields, you will be transitioned to another inquiry page, which provides a summary of data and a list of transactions that modified the field.  You will also be provided with a link to the transaction(s) that modified the field.

The four transaction types that provide updates to the fields are as follows:

• Stock Requisition transaction  - contains information for the Reserved, Released, and Backordered quantities

• Stock Transfer Issue transaction - contains information for the In-Transfer quantity

• Purchase Order transaction - contains information for the On-Order quantity

• Requisition transaction - contains information for the Currently Requested quantity

The Reorder Information tab displays a detailed two-year stock usage history, broken down by month. This page allows a warehouse manager to see, for a specific stock item, the quantity that has been issued for a specific month for the current year as well as for the past two years, and use this information in forecasting current and future needs.

Other system maintained information such as Reorder Point and physical count of inventory are maintained on the table through a set of batch processes.

The Location tab displays the stock item information at the location level. Only the active records from the Inventory by Location (ILOC) table are displayed in this tab.