Display the Status of an Item

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

Note
If you accessed this program from another program, skip step 1.

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 followed by the item's description

Stk UOM

The item's stocking unit of measure

Scope

Scope of the inventory quantities:

Enterprise	Your entire company
Br Group	All branches in your inventory group
Local Branch	Your login branch only
Mfg Branch	Your manufacturing branch only

Note
To change the scope, Click Prog opts and set the Scope for inventory quantities Program option. Scope does not affect quantities on any other screen in this program.

The program the item's cost information:

Field Name	Displays
Material	The standard unit cost of the raw material or components that make up a parent item
Labor	The standard unit cost of the work performed to manufacture this item, including labor cost for lower-level subassemblies
Overhead	The standard unit cost of business operations applied to this item
Service	The standard unit cost of outside service incurred to manufacture this item
Unit cost	The standard unit cost: Material + Labor + Overhead + Service
Last update	Date of the last cost rollup

The program displays these inventory values for the item:

Field Name	Displays
Login	Value of on-hand inventory in your local branch followed by the branch code; for a component: Material cost x Quantity on hand; for a finished good: Standard unit cost x Quantity on hand
Group	Value of on-hand inventory for all branches in your inventory group followed by the group name; for a component: Material cost x Quantity on hand; for a finished good: Standard unit cost x Quantity on hand
Enterprise	Value of on-hand inventory for your entire company; for a component: Material cost x Quantity on hand; for a finished good: Standard unit cost x Quantity on hand
Mfg	Value of on-hand inventory for your manufacturing branch only followed by its branch code; for a component: Material cost x Quantity on hand; for a finished good: Standard unit cost x Quantity on hand
Last count	Date of the last physical inventory count
Next count	Date of last count plus the count frequency
Count freq	Number of days between counts

The program displays these quantities for the item:

Field Name	Displays
On hand	The quantity of this item in on hand inventory
Flr stk	The quantity 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 or POs 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 the transfer request.
Committed	The quantity needed for sales orders, manufacturing orders, and branch transfers
Obligated	The quantity specifically assigned to sales orders, manufacturing orders, and 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: On hand + Floor stock - Committed The Calc available using committed/obligated option in the System Options Maintenance (XM) program (Inventory Options) determines which calculation the program uses.

The program displays these fields for each period:

Field Name	Displays
Period	The fiscal period number
Month	The month If you selected F for the F=Fiscal or C=Calendar history installation option, your periods set with the Accounting Period Maintenance (GDM) program may not match calendar months.
Year	This year for this period
Qty on hand Qty floor stock Qty On hand+flr stk	The quantity on hand, in floor stock or the sum of on hand and floor stock as of the last transaction for this period The Default for Qty Runtime option controls which quantity is displayed when you enter the program. Click Qty to display a different quantity.
Used	If this is a component, the quantity used in manufacturing plus any IMI consumption transactions during this period
Sold	The quantity on sales shipments during this period
Manufactured	The quantity made during this period
Purchased	The quantity purchased during this period
Booked	The quantity entered for sales orders during this period
High selling price	The highest selling price for this item during this period. If the group/enterprise includes more than one branch, the highest selling price from the group of branches.
Low selling price	The lowest selling price for this item during this period. If the group/enterprise includes more than one branch, the lowest selling price from the group of branches.

(Optional) 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 Sort tab set the sort order.
3. Click the Selection tab to select specific records.
4. Click the Program tab to set these program specific options:

Field Name

Type / Max Length

Action / Description

Scope for inventory quantities

Required
1 alphanumeric

Select the scope for the inventory quantities (On hand, Flr stk, On Order, Intransit, Committed, Obligated, and Available) that display in the upper-right section of the screen:

Select	To display data for
E	Your entire company
M	Your manufacturing branch only
B	Your login branch only
G	All branches in your inventory group

Note
If you select B, you must select a branch for the Branch or branch grp Selection option. If you select G, you must select a group for the same option.

Number of years to view

Optional
1 alphanumeric

Select the number of years (from 1 to 9) you want to display or leave blank for the default 3-year display.

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

Select a period, click Detail, and choose the appropriate options:

To	Do This
Display inventory status for this item	Click On hand. See Display Inventory Status. Click OK to return to this program.
List shipped sales order lines for the item during the selected period	Click Sold. See Display Items Sold by Customer. Click OK to return to this program.
For a component, display manufacturing orders during the selected period	Click Used. See Display Material History. Click OK to return to this program.
Display purchase orders during the selected period	Click Purchases. See Display Purchase Orders. Click OK to return to this program.
For a parent item, display completed manufacturing orders during the selected period	Click Manufacture. See Manufacturing Order Analsysis. Click OK to return to this program.
End this action and remove the buttons	Click Back.

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See step 2.
Print the period listing	Click Print. See Print an Inquiry.
Display totals (i.e., used, sold, manufactured, purchased and booked quantities)	Click Totals. Click Totals again to return to the detail display.
Toggle between the quantity on hand, in floor stock or the sum of on hand and floor stock	Click Qty. The Default for Qty Runtime option controls which quantity is displayed when you enter the program.
For a parent item, display components on the bill of material	Click BOM. See Display a Single Level of a BOM. Click Exit to return to this program.
For a component, display bills of material on which the item is used	Click Where-used. See Display Component Parentage for Standard BOMs. Click Exit to return to this program.
View related information	Click View. See The View Button.
Exit this item	Click OK.
Exit and return to the menu	Click Exit.