Inventory Inquiry by Item (IIQI)
Purpose: Use the Inventory Inquiry by Item function to review item information organized by the base item and the first SKU element. The information presented through this function summarizes order and fulfillment activity; backorder and purchase order dates and totals; and returns and cancellations. You can also advance from the Inventory Inquiry by Item function to additional inventory inquiries.
The information presented through this function requires at least three screens to display (more if there are many SKU combinations). You advance left to right or right to left among these screens by pressing function keys.
Other options: You can use the following additional menu options for inventory inquiry:
• Using Inventory Inquiry (DINI): to review inventory information for items within warehouses and locations in warehouses
• Inventory Status Inquiry (ISIQ): to review order activity for any item or SKU broken out by offer
In this chapter:
• Inventory Inquiry by Item Prompt Screen (Selecting an Item)
• Inventory Inquiry by Item Screen (1 of 3)
• Inventory Inquiry by Item Screen (2 of 3)
• Inventory Inquiry by Item Screen (3 of 3)
Inventory Inquiry by Item Prompt Screen (Selecting an Item)
Purpose: Use this screen to select the item and first SKU element for inventory review.
How to display this screen: Enter IIQI in the Fast path field at the top of any menu or select Inventory Inquiry by Item from a menu.
Field |
Description |
Item |
A code representing a unit of inventory that you sell to your customers. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions; required. |
Colr (First SKU element) |
A SKU defines an item's unique characteristics, such as its color, size, width, etc. You can define up to three SKUs for each item. You enter the value from the Split SKU Element Column 1 Heading (A34) system control value here. Alphanumeric, 4 positions; required if the item has SKUs. |
Completing this screen: You advance to the Inventory Inquiry by Item Screen (1 of 3).
Inventory Inquiry by Item Screen (1 of 3)
Purpose: Use this screen to review information about Item/SKU order activity and availability.
Note: Each field is display-only.
How to display this screen: Enter a valid item code and first SKU element value at the Inventory Inquiry by Item Prompt Screen (Selecting an Item).
Field |
Description |
Item |
A code representing a unit of inventory you sell to your customers. Item codes are defined in and validated against the Item table. Alphanumeric, 12 positions. |
Item description (unlabeled field to the right of the item code) |
The description associated with the item. Alphanumeric, 25 positions. |
Retail (Retail price) |
The retail price for the item defined for the most current offer. If you define the price for items with SKUs at the SKU level rather than the item level, the retail price indicated is .00. Numeric, 7 positions with a 2-place decimal. |
Dept (Long SKU department) |
A code representing the department defined for the item. See Working with Long SKU Departments (WLSD). Numeric, 4 positions. |
COLR (First SKU element) |
A SKU defines an item's unique characteristics, such as its color, size, width, etc. You can define up to three SKUs for each item. From the Split SKU Element Column 1 Heading (A34) system control value. Alphanumeric, 4 positions. |
Description (Unlabeled field to the right of the first SKU element) |
The description associated with the first SKU element. Alphanumeric, 10 positions. |
Vendor |
The vendor from the Item table, if any. See Working with Vendors (WVEN). Alphanumeric, 7 positions. |
Cost |
The unit cost of the item. Depending on which costing method you use, the system displays: • Average costing: average cost • Standard costing: standard cost • FIFO costing: weighted average FIFO cost Each of these costs is stored in the SKU table. See the Costing Method (A25) system control value or FIFO Costing Overview. Numeric, 11 positions with a 4-place decimal. |
Class |
A code to identify a group of items. You might use item classes to assign city/state or customer class selling restrictions or sort inventory. Item class codes are defined in and validated against the Item Class table. See Working with Item Classes (WICL). Alphanumeric, 3 positions. |
Colr (First SKU element) |
From Split SKU Element Column 1 Heading (A34) system control value. The figures on this row of information represent total inventory calculations for all SKUs for the item that match the SKU element 1 you selected. See field descriptions below, beginning with the Cust ord (Customer orders) field, for more information. |
Item |
The figures on this row of information represent item-wide total inventory calculations. See field descriptions below, beginning with the Cust ord (Customer orders) field, for more information. |
Size (Second SKU element) |
The second special characteristic of an item. From the Split SKU Element 2 Column Heading system control value. See Split SKU Element Column Headings (A52, A53, A54). Alphanumeric, 4 positions. |
Wdth (Third SKU element) |
The third special characteristic of an item. From the Split SKU Element 3 Column Heading system control value. See Split SKU Element Column Headings (A52, A53, A54). Alphanumeric, 4 positions. |
The following fields represent column headings for inventory information calculated for: • Clr: All SKUs containing the first SKU element you entered on the selection screen. • Item: All SKUs for the item, regardless of first SKU element. • Each unique SKU that contains the first SKU element you entered on the selection screen (these are the rows that display below the column headings) |
|
TTL ord (Total ordered) |
The total quantity of units ordered for this item or SKU across all offers. Includes both open and closed orders. Numeric, 7 positions. |
Avail (Available) |
The total quantity on-hand, minus the quantity on order. Negative figures represent backorders. For the SKU element 1 and Item totals, this figure represents the net of available minus backorders for all SKUs included in the calculation. Numeric, 7 positions. |
Rsv (Reserved) |
The total quantity reserved. Numeric, 7 positions. |
Printed |
The total quantity on printed pick slips. Numeric, 7 positions. |
O/H (On hand) |
The total quantity present in your warehouses. Numeric, 7 positions. |
B/O (Backordered) |
The total quantity that is backordered. Numeric, 7 positions. |
Soldout control |
Indicates whether there is a soldout control code for the item or SKU. You define soldout controls with one of three values: • sellout immediately • sellout when on-hand inventory is exhausted • sellout when on-hand inventory plus all purchase order receipts are exhausted. Valid values for this field are: Selected = There is a soldout control specified for this item or SKU. Unselected = There is no soldout control specified for this item or SKU. Soldout controls are defined in and validated against the Soldout Control table. See Working with Soldout Controls (WSLD). |
Screen Option |
Procedure |
Advance to Inventory Quantity Inquiry |
Select Inv Qty to advance to the Inventory Quantity Inquiry Prompt Screen. |
Advance to Inventory Status Inquiry |
Select Inv Status to advance to Inventory Status Inquiry (ISIQ). |
Change the first SKU element |
Select Change Colrr to advance to the Enter New SKU Pop-Up Window. |
Advance to the second screen |
Select Right to advance to the Inventory Inquiry by Item Screen (2 of 3). |
Inventory Inquiry by Item Screen (2 of 3)
Purpose: Use this screen to review additional information about the item, including backorder and purchase order dates and order fulfillment figures.
How to display this screen: Select Right at the Inventory Inquiry by Item Screen (1 of 3).
Note: If you have advanced downward on the Inventory Inquiry by Item Screen (1 of 3) by pressing Next to review additional SKUs, you will retain this relative position when you advance to this screen or the Inventory Inquiry by Item Screen (3 of 3).
Field descriptions: The information at the top of this screen, and the item/SKU information on the left, is repeated from the Inventory Inquiry by Item Screen (1 of 3). The additional fields on this screen are described below.
The fields on this screen and the next are historical, representing life-to-date figures for all offers associated with the item or SKU.
Field |
Description |
Oldest B/O (Oldest backorder) |
The date of the oldest backorder for the item or SKU. Numeric 6 positions (in user date format). |
Recpt (Received) |
The total received quantity for the item or SKU in all allocatable warehouses. Numeric, 7 positions. |
On PO |
The total quantity of the item or SKU on purchase order and not yet received. Numeric, 7 positions. |
Next recpt (Next receipt) |
The next date that you expect to receive the item or SKU at your warehouse. Numeric, 6 positions (in user date format). |
Ship |
The total quantity of the item or SKU that you have shipped to customers. Numeric, 7 positions. |
Rtn (Returned) |
The total quantity of the item or SKU that has been returned by customers. Numeric, 7 positions. |
Cancel |
The total quantity of the item or SKU that has been canceled. Numeric, 7 positions. |
Screen Option |
Procedure |
Advance to Inventory Quantity Inquiry |
Select Inv Qty to advance to the Inventory Quantity Inquiry Prompt Screen. |
Advance to Inventory Status Inquiry |
Select Inv Status to advance to Inventory Status Inquiry (ISIQ). |
Change the first SKU element |
Select Change Colrr to advance to the Enter New SKU Pop-Up Window. |
Return to the first screen |
Select Left to return to the Inventory Inquiry by Item Screen (1 of 3). |
Advance to the third screen |
Select Right to advance to the Inventory Inquiry by Item Screen (3 of 3). |
Inventory Inquiry by Item Screen (3 of 3)
Purpose: Use this screen to review exchange, net sales, lost sales and total order figures for the item or SKUs.
How to display this screen: Select Right at the Inventory Inquiry by Item Screen (2 of 3).
Note: If you have advanced downward on the Inventory Inquiry by Item Screen (1 of 3) or the Inventory Inquiry by Item Screen (2 of 3) by selecting Next to review additional SKUs, you will retain this relative position when you advance to this screen.
Field descriptions: The information at the top of this screen and the item/SKU information on the left, is repeated from the Inventory Inquiry by Item Screen (1 of 3). The additional fields on this screen are described below.
The fields on this screen are historical, representing life-to-date figures for all offers associated with the item or SKU.
Field |
Description |
Exchg (Exchanges) |
The total quantity of the item or SKU that has been exchanged. Numeric, 7 positions. |
Net sales |
Net sales for the item or SKU, calculated as: Total quantity shipped - (returns + exchanges) Numeric, 7 positions. |
Lost sales |
The total quantity of the item or SKU that customers would have ordered if the item or SKU were available. You enter lost sales through Display Item Availability Screen in Order Entry. Numeric, 5 positions. |
The total quantity ordered but not yet shipped. Numeric, 7 positions. |
Screen Option |
Procedure |
Advance to Inventory Status Inquiry |
Select Inv Status to advance to Inventory Status Inquiry (ISIQ). |
Change the first SKU element |
Select Change Colrr to advance to the Enter New SKU Pop-Up Window. |
Return to the first screen |
Select Left to return to the Inventory Inquiry by Item Screen (2 of 3). |
Purpose: Select Change Colrr at the Inventory Inquiry by Item Screen (1 of 3), Inventory Inquiry by Item Screen (2 of 3), or Inventory Inquiry by Item Screen (3 of 3) to select another first SKU element to review. The Enter New SKU pop-up window opens:
You can enter a new SKU at this window, or prompt for all valid SKUs by clicking on the arrow in this field. You then advance to the Select SKU pop-up window; when you select a SKU from this window, the system defaults the first SKU element from your selection to the Enter New SKU pop-up window.
| Item Stock Status Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Item Availability API |
IIQI OMSCS 18.1 April 2019 OTN