Display Inventory Status

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 Background and Road Map for more information.

Enter the number of the item or click the Lookup icon and use the standard lookup options to select the item from a list.

The program displays these fields:

Field Name

Displays

Item number

The item number that you entered or selected

Description

The item's description set in the Enterprise Item Maintenance (IM) program

Alt desc

The item's alternative description set in the Enterprise Item Maintenance (IM) program

Xref

The additional sort criterion set in the Enterprise Item Maintenance (IM) program and used by the item lookup

Item type

The item type based on its order and bypass codes selected in the Enterprise Item Maintenance (IM) program; see Item Types.

Status

The item's status as defined in the Item Status Codes (TISM) program and selected in the Enterprise Item Maintenance (IM) program.

Whse/Bin

Whether warehouse and bin controlled; set in the Enterprise Item Maintenance (IM) program:
Y: Warehouse and bin location controlled
N: Not controlled by warehouse or bin location

Serial/Lot

Whether serial or lot controlled; set in the Enterprise Item Maintenance (IM) program:
S: Serial number control
M: Lot number control
N: Neither serial nor lot number control

Pre-assign

When serial or lot numbers are assigned; set in the Enterprise Item Maintenance (IM) program:

N or blank: Assign control numbers when you receive the finished goods into inventory
Y: Assign control numbers when you release a manufacturing order
P: Assign control numbers when you release a manufacturing order and process/print an item label with the Mfg Order Control Number Print Selection (WOCS) program

Make/Buy/Kit

Whether you make, buy, or kit this item; set in the Enterprise Item Maintenance (IM) program:
B: Buy item
K: Sell as a kitted item
M: Make (manufacture) item

Flr stk cd

0: Not floor stock
1: Floor stock

If you selected for the Scope for inventory quantities Program option:

Option	Floor stock code is from the
G, S, or E	Enterprise Item Maintenance (IM) program
B or M	Branch Item Maintenance (IMB) program

Low level cd

The lowest bill of material level in which this item appears; if 0, the item is not used in a standard bill of material

Prod class

The product class assigned to this item in the Enterprise Item Maintenance (IM) program

Prod subclass

0: Not floor stock
1: Floor stock

If you selected for the Scope for inventory quantities Program option:

Option	Floor stock code is from the
G, S, or E	Enterprise Item Maintenance (IM) program
B or M	Branch Item Maintenance (IMB) program

Stocking UOM

The unit of measure in which you stock this item; set in the Enterprise Item Maintenance (IM) program

Planner

The planner code for the person who is responsible for planning this item; assigned for either the enterprise or the branch

If you selected for the Scope for inventory quantities Program option:

Option	Planner code is from the
G, S, or E	Enterprise Item Maintenance (IM) program
B or M	Branch Item Maintenance (IMB) program

Buyer

The buyer code for the person who is responsible for purchasing this item; assigned for either the enterprise or the branch

If you selected for the Scope for inventory quantities Program option:

Option	Buyer code is from the
G, S, or E	Enterprise Item Maintenance (IM) program
B or M	Branch Item Maintenance (IMB) program

Item code

A code that can be used for:

Make-to-order items for which you want the system to create a manufacturing order or requisition when you enter a sales order for the item. The code must match the code entered for the Immediate supply item code option in the System Options Maintenance (XM) program (Inventory Control Options).
A parent item or the parent of its subassembly for which you want the system to create cascading manufacturing orders. The code must match the code entered for the Subassembly release type option in the System Options Maintenance (XM) program (Manufacturing Options).
Selecting items for planning with the Finished Goods Planning (MFP) and/or Material Requirements Planning (MRP) programs.

Shelf life code

The code that corresponds to the shelf life for this item. Applicable to lot and serial controlled items only.

The program displays these fields based on the scope you selected for the Scope for inventory quantities Program option:

Field Name	Displays
Scope	The branches considered: B Your login branch only E Your entire company G All branches in your inventory group M Your manufacturing branch only S Selected branch or group This is a Program option; see step 3.
On hand	The quantity of this item that is in on-hand inventory
Flr stk	The quantity that is in floor stock
On order	The quantity that has been ordered on requisitions, purchase orders, manufacturing orders, and transfers but not received This field does not include requisitions for purchased services.
Intransit	The quantity that is in the process of being transferred from one branch to another, which includes confirmed shipments not yet received at the requesting branch. Note The On order quantity for the requesting branch includes transfer requests.
Committed	The quantity needed for sales orders, manufacturing orders, and outgoing branch transfers
Obligated	The quantity assigned to sales orders, manufacturing orders, and outgoing branch transfers
Available	The quantity that is in inventory and not obligated: On hand + Floor stock - Obligated OR The quantity that is in inventory and not needed for other orders: On hand + Floor stock - Committed Your setting for the Calc available using obligated/committed option in the System Options Maintenance (XM) program (Inventory Options) determines which calculation the program uses.
Qty in MRB	The quantity awaiting disposition by the Material Review Board
Consignment	The quantity that is in consignment inventory
Qty in insp	The quantity that is in inspection

The program displays these fields for the manufacturing branch associated with your login branch:

Field Name	Displays
Current ECL	The Engineering Change Level for the current bill of material for this item
Lead time	If the Make/Buy/Kit field in the Enterprise Item Maintenance (IM) program is M, lead time is: Order prep + Manufacturing + Put-away If the Make/Buy/Kit field in the Enterprise Item Maintenance (IM) program is B, lead time is: Order prep + Intransit + Put-away If the Make/Buy/Kit field in the Enterprise Item Maintenance (IM) program is K, lead time is: Order prep + Manufacturing
Lot size	The standard quantity of the item that you make during the production process; set in the Branch Item Maintenance (IMB) program For a consignment item, the system moves this quantity from consignment to on-hand inventory; if 0, the system moves only the quantity required for the manufacturing order
Safety stk	The minimum quantity of this item that should be kept in inventory at all times to protect against fluctuations in demand or supply; set in the Branch Item Maintenance (IMB) program
Min ord qty	The minimum quantity of this item to be ordered on a planned order; set in the Branch Item Maintenance (IMB) program
Status	The item's manufacturing branch status
Pref vendor	The preferred vendor (if a purchased item)
Mfg order qty picked	The quantity of this component that has been picked for manufacturing orders
Mfg order qty in WIP	The quantity of this component that is in work in process: Mfg order qty picked - Mfg order qty received x Current quantity per
Qty in MRB	The quantity awaiting disposition by the material review board
Qty in insp	The quantity that is in inspection
Primary whse	The warehouse where this item is stocked; set in the Branch Item Maintenance (IMB) program
Primary bin location	The bin location in the warehouse where this item is stocked; set in the Branch Item Maintenance (IMB) program

Additional information may be displayed the a window following these fields if Q-Info is associated with the item. See Q-Info for ISQ.

Choose the appropriate options:

To	Do This
Review your options	Click Prog opts. See step 3.
Go to a related program	Click Jump. See Jump.
Display notes for this item	Click Notes and click the type of note. See Display Notes.
Display branch quantities	Click Branch. Your selection for the Branch or branch grp Selection option determines which branches display. See Display Branch Quantities. Click OK to return to this screen.
Display quantities on unreleased requisitions, unreceived purchase orders, manufacturing orders and transfers	Click Supply. See Display On Order Quantities. Click OK to return to this screen.
Display committed quantities for sales, manufacturing orders, transfers and configured products for each branch	Click Demand. See Display Inventory Commitments. Click OK to return to this screen.
Display transfers that have been confirmed shipped but not completely received	Click Intransit. See Display Intransit Quantities. Click OK to return to this screen.
Display manufacturing usage or work in process	Click Mfg and then click Mfg usage or Mfg WIP. See Display Manufacturing Usage or Display Manufacturing Work in Process. Click OK to return to this screen.
Display supply and demand orders and projected inventory quantities	Click Sup/Dem. Display Commitments and Orders. Click OK to return to this screen.
Display substitutes for this item	Click Sub item. See Display Quantities of Substitute Items and Family Components Click OK to return to this screen. This button is not displayed if the Item type is Family.
Display items in this family	Click Fam item. See Display Quantities of Substitute Items and Family Components Click OK to return to this screen. This button displays if the Item type is Family.
Display demand and availability	Click Planning. See Display an Item's Demand and Availability. Click OK to return to this screen.
Display material review board information	Click MRB. See Display Rejected Items. Click OK to return to this screen.
Display pricing information	Click Pricing. See Display Prices by Item. Click OK to return to this screen. Note Prices are displayed in the sales unit of measure.
View related information	Click View. See The View Button.
Display component availability	Click Comp avail. See Display Component Availability. Click OK to return to this screen.
Display inspection status	Click Inspection. See Display Items Awaiting Inspection. Click OK to return to this screen.
Display files imported for the item	Click Documents. See Display Imported & Archived Documents. Click OK to return to this screen. This button displays if Document Import is active.
Specify a different item	Click OK.
Exit the program	Click Exit.

Click Prog opts to review your options. To change them:
1. Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
2. Click the Selection tab to select specific records.
  
  Note
  The Branch or branch grp Selection option affects the data that the program displays when you click Branch and for drill downs.

1. Click the Program tab to set this program specific options:

Field Name

Type / Max Length

Action / Description

Scope for inventory quantities

Required
1 alphanumeric

Select the scope for the inventory quantities that display in the upper-right section of the screen:

B Your login branch only
E Your entire company
G All branches in your inventory group
M Your manufacturing branch only
S Selected branch or group (specified on the Selection tab)

Note
The Branch or branch grp Selection option affects the branches that display when you click Branch.

Include reqs in On order qty?

Required

When selected, the on order quantity displayed on the initial screen and when you click Branch includes requisitions. Clear the field to exclude requisitions.

Click Save to save these options for future use.
Click Refresh to display current options.
Click OK to apply these options or click Cancel to exit without applying them.