Background: Item Inquiry

Use the Item Inquiry (ISI) program to display an item's costs, inventory value, current inventory quantities, and the quantity on hand, used, sold, manufactured, purchased, booked for the last 12, 24, or 36 months/periods, and highest and lowest selling price. See Road Map for work flow.

Caution
If you display status information for an item and then on another screen run a program (for example, Sales Order Maintenance (OE)) that affects inventory for that same item, when you return to the Item Inquiry screen the change will not be reflected. You need to exit and redisplay the item.

This topic has these subtopics:

Scope
Inventory Updates

Scope

Scope determines which totals display in the upper-right corner of the first screen. If your scope is set to Local Branch, these totals are for your login branch. If your scope is set to Branch Group, the totals are for all branches in the inventory group associated with your branch. If scope is set to Enterprise, the totals are for your entire enterprise.

To change your scope, Click Prog opts and set the Select to determine scope for inquiry Program option to E for enterprise, M for manufacturing branch, G for branch group, or B for your local branch. When you change your scope setting, you may see different totals.

For example, suppose that your enterprise consists of four branches with these on-hand inventory totals for an item:

Branch	On-hand Inventory
BR-1	20
BR-2	30
BR-3	10
BR-4	40

Assume that your local branch is BR-1 and that BR-1 and BR-2 comprise your branch group. The on-hand inventory totals that display for each of these scope settings would be:

Scope	On-hand Inventory
Local Branch	20
Branch Group	50
Enterprise	100

Inventory Updates

The system updates the inventory quantities that display on the first screen when you run these programs:

Field	When you	Program
On hand	Confirm a shipment	Sales Shipment Confirmation (OC) Secured Confirmation (SOC) Bill of Lading Maintenance (BLM) One-Step Invoice Entry (RE)
	Pick components	Picking Confirmation (MPK) Secured Picking (SMPK) Manufacturing Order Picking Selection (MSS) Manufacturing Order Maintenance (MIM) Material Usage Maintenance (MUA) WIP Movement (WIPM) Labor Entry (LLE) Labor Import (LEI)
	Confirm a transfer shipment	Branch Transfer Confirmation (ITS) Secured Transfer Confirmation (SITS) Bill of Lading Maintenance (BLM)
	Receive into inventory	Receiver Maintenance (IRC) for direct-to stock OR Receiving and Inspection (IRI) for dock-to-stock or if inspection is required
	Adjust inventory	Material Issues and Adjustments (IMI)
Flr stk	Issue floor stock to on hand or on hand to floor stock or Floor stock adjustment	Material Issues and Adjustments (IMI)
Flr stk	Receive finished goods into inventory	Receiver Maintenance (IRC)
On order	Enter a purchase order	PO Maintenance (VOE) Requisition Maintenance (IRM) Order Release Selection (MRR)
	Enter a manufacturing order	Manufacturing Order Maintenance (MIM) Requisition Maintenance (IRM) Consolidate Manufacturing Requisitions (MOCR) Order Release Selection (MRR)
	Enter a requisition	Requisition Maintenance (IRM)
	Receive into inventory	Receiver Maintenance (IRC) for direct-to stock OR Receiving and Inspection (IRI) for dock-to-stock or if inspection is required
Intransit	Confirm a transfer shipment	Branch Transfer Confirmation (ITS) Secured Transfer Confirmation (SITS) Bill of Lading Maintenance (BLM)
Intransit	Receive into inventory	Receiver Maintenance (IRC) for direct-to stock OR Receiving and Inspection (IRI) for dock-to-stock or if inspection is required
Committed	Enter a sales order	Sales Order Maintenance (OE) Quote-to-Quote Transfer (EPIB)
	Confirm a shipment	Sales Shipment Confirmation (OC) Secured Confirmation (SOC) Bill of Lading Maintenance (BLM) One-Step Invoice Entry (RE)
	Enter a manufacturing order	Manufacturing Order Maintenance (MIM) Requisition Maintenance (IRM) Consolidate Manufacturing Requisitions (MOCR) Order Release Selection (MRR)
	Pick components	Picking Confirmation (MPK) Secured Picking (SMPK) Manufacturing Order Picking Selection (MSS) Manufacturing Order Maintenance (MIM) Material Usage Maintenance (MUA) WIP Movement (WIPM) Labor Entry (LLE) Labor Import (LEI)
	Enter a transfer	Branch Transfer Maintenance (ITM Requisition Maintenance (IRM)
	Confirm a transfer shipment	Branch Transfer Confirmation (ITS) Secured Transfer Confirmation (SITS) Bill of Lading Maintenance (BLM)
Obligated	Obligate items on sales order	Sales Order Maintenance (OE) Order Shipment Selection (OSS) Sales Order Auto Processing (OAP) One-Step Invoice Entry (RE)
	Confirm a shipment	Sales Shipment Confirmation (OC) Secured Confirmation (SOC) Bill of Lading Maintenance (BLM) One-Step Invoice Entry (RE)
	Obligate components on a manufacturing order	Manufacturing Order Maintenance (MIM) Manufacturing Order Picking Selection (MSS) Manufacturing Order Auto Processing (MAP) Material Usage Maintenance (MUA) Picking Confirmation (MPK) Secured Picking (SMPK)
	Pick components	Picking Confirmation (MPK) Secured Picking (SMPK) Manufacturing Order Picking Selection (MSS) Manufacturing Order Maintenance (MIM) Material Usage Maintenance (MUA) WIP Movement (WIPM) Labor Entry (LLE) Labor Import (LEI)
	Obligate items for a transfer	Branch Transfer Maintenance (ITM) Transfer Auto Processing (ITAP) Requisition Maintenance (IRM)
	Confirm a transfer shipment	Branch Transfer Confirmation (ITS) Secured Transfer Confirmation (SITS) Bill of Lading Maintenance (BLM)
Available	Obligate (if you selected O for the Calc available using obligated/committed option in the System Options Maintenance (XM) program (Manufacturing Options)	Available is: On hand - Obligated
Available	Commit (if you selected C for this option)	Available is: On hand - Committed
Consignment	Receive a consignment item	Receiver Maintenance (IRC)
Consignment	Pick a consignment component that moves a quantity from consignment to on hand	Picking Confirmation (MPK) Secured Picking (SMPK) Manufacturing Order Picking Selection (MSS) Manufacturing Order Maintenance (MIM) Material Usage Maintenance (MUA) WIP Movement (WIPM) Labor Entry (LLE) Labor Import (LEI)

The system updates inventory quantities for the twelve most recent periods when you ran these programs:

Field	When you	Program
Used	Pick components	Manufacturing Order Maintenance (MIM) Material Usage Maintenance (MUA) Picking Confirmation (MPK) Secured Picking (SMPK) Manufacturing Order Picking Selection (MSS) WIP Movement (WIPM) Labor Entry (LLE) Labor Import (LEI) Receiver Maintenance (IRC)
Sold	Confirm a shipment	Sales Shipment Confirmation (OC) Secured Confirmation (SOC) Bill of Lading Maintenance (BLM) One-Step Invoice Entry (RE)
Booked	Enter a sales order	Sales Order Maintenance (OE) Quote-to-Order Transfer (EPIB)
Purchased	Enter a purchase order	PO Maintenance (VOE) Requisition Maintenance (IRM) Order Release Selection (MRR)
Manufactured	Enter a manufacturing order	Manufacturing Order Maintenance (MIM) Requisition Maintenance (IRM) Consolidate Manufacturing Requisitions (MOCR) Order Release Selection (MRR)