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) |
Pick components |
Picking Confirmation (MPK) |
|
Confirm a transfer shipment |
Branch Transfer Confirmation (ITS) |
|
Receive into inventory |
Receiver Maintenance (IRC) for direct-to
stock |
|
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) |
Enter a manufacturing order |
Manufacturing Order Maintenance (MIM) |
|
Enter a requisition |
Requisition Maintenance (IRM) |
|
Receive into inventory |
Receiver Maintenance (IRC) for direct-to
stock |
|
Intransit |
Confirm a transfer shipment |
Branch Transfer Confirmation (ITS) |
Receive into inventory |
Receiver Maintenance (IRC) for direct-to
stock |
|
Committed |
Enter a sales order |
Sales Order Maintenance (OE) |
Confirm a shipment |
Sales Shipment Confirmation (OC) |
|
Enter a manufacturing order |
Manufacturing Order Maintenance (MIM) |
|
Pick components |
Picking Confirmation (MPK) |
|
Enter a transfer |
Branch Transfer Maintenance (ITM) |
|
Confirm a transfer shipment |
Branch Transfer Confirmation (ITS) |
|
Obligated |
Obligate items on sales order |
Sales Order Maintenance (OE) |
Confirm a shipment |
Sales Shipment Confirmation (OC) |
|
Obligate components on a manufacturing order |
Manufacturing Order Maintenance (MIM) |
|
Pick components |
Picking Confirmation (MPK) |
|
Obligate items for a transfer |
Branch Transfer Maintenance (ITM) |
|
Confirm a transfer shipment |
Branch
Transfer Confirmation (ITS) |
|
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) |