Background: Inventory Status Inquiry

Use the Inventory Status Inquiry (ISQ) program to display an item's current on-hand, on-order, intransit, committed, obligated, available, and in consignment quantities, sources of supply, types of demand, quantities of substitute items, or family components. See Road Map for work flow.

You can display a window of additional item attributes on the standard screen with Q-Info.

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 Inventory Status Inquiry screen the change will not be reflected. You need to exit and restart the Inventory Status Inquiry program.

This topic has these subtopics:

Scope
Selection Options

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 Scope for inventory quantities program option to E for enterprise, M for manufacturing branch, G for branch group, B for your branch only, or S for user selected branch or group. 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 totals that display for each of these scope settings would be:

Scope

On-hand Inventory

Local Branch

20

Branch Group

50

Enterprise

100

Selection Options

Scope does not affect the data that displays on any other Inventory Status Inquiry screen. You can use the Branch or Branch grp selection option to control which branches display on other screens. To change your selection option, Click Prog opts and in the Branch or branch grp field select the branch you want to display or enter a branch group to display data from all branches in that group.

Note
The branch that you enter must be in the inventory group associated with your login branch or be selected for the Inventory group override field in your record in the User Maintenance (UIM) program. Likewise, the branch group that you enter must be the inventory group for your login branch or your inventory group override unless the Allow branch group override? field is selected in your record in the User Maintenance program.

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)

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)

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)

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

Commit (if you selected C for this option)

Available is: On hand - Committed

Consignment

Receive consignment items

Receiver Maintenance (IRC)

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)