Chapter 27: Working with Forecasts (WFCS) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 29: Working with Active Offers (WACO) |
Chapter 28: Inventory Status Inquiry (ISIQ)
Purpose: Use Inventory Status Inquiry to view order activity for any item or SKU broken out by offer. The information includes total and net orders and sales; returns, cancellations, and exchanges; and purchase order figures. You can break out the information in three basic ways:
• summarizing all SKUs for a SKUed item
• selecting a specific SKU for a SKUed item
• summarizing activity for a non-SKUed item
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 Inquiry by Item (IIQI): to review item information organized by the base item and the first SKU element
• Inventory Inquiry by SKU (DSQI): to review inventory information for all SKUs of an item
In this chapter:
• Inventory Status Inquiry Screen
• Inventory Status - Non SKU Screen (1 of 2)
• Inventory Status - Non SKU Screen (2 of 2)
• Inventory Status - SKU Screen (1 of 2)
• Inventory Status - SKU Screen (2 of 2)
• Inventory Status - All SKUs Screen (1 of 2)
• Inventory Status - All SKUs Screen (2 of 2)
Additional inventory inquiries:
• Using Inventory Inquiry (DINI) for detailed information on the availability and demand for an item or SKU in a particular warehouse or locations within a warehouse.
• Inventory Inquiry by Item (IIQI) for detailed information on availability, demand and life-to-date history of an item and each of its individual SKUs.
Inventory Status Inquiry Screen
Purpose: Use this screen to select the item/SKU you want to view.
How to display this screen: Enter ISIQ in the Fast Path field at the top of any menu or select Inventory Status Inquiry from a menu.
FCR0010 ENTER Inventory Status Inquiry 2/12/98 11:25:12 Mail Order
Item . . . .
CLR SIZE WDTH
F3=Exit F12=Cancel |
Field |
Description |
Item |
The code of the item you want to review. The item code is validated against the Item file. Alphanumeric, 12 positions; required. |
Clr/Size/Wdth (SKUs) |
The item's unique characteristics, such as its color and size. Alphanumeric, three 4-position fields (split SKU), or one 14-position field (full SKU); optional. |
Completing this screen: Enter an item code in the Item field. If you are inquiring about a SKUed item, enter SKU information if you want to review information about that specific SKU only; leave the SKU fields blank if you want to review combined information for all SKUs. You advance to the Inventory Status - Non SKU Screen (1 of 2), Inventory Status - SKU Screen (1 of 2), or Inventory Status - All SKUs Screen (1 of 2) depending on your entries.
Inventory Status - Non SKU Screen (1 of 2)
Purpose: Use this screen to review order, return, exchange and cancellation totals for each offer where the item is sold.
How to display this screen: Enter a non-SKUed item at the Inventory Status Inquiry Screen.
INR0941 DISPLAY Inventory Sts - Non SKU (1 of 2) 5/06/96 12:06:33 Mail Order
Item: AUGIE AUGIE DOGGIE DOLL
Retail: 15.00 Cost: 8.95
Total: 322 6 0 168 27 9 295 .75 16.00 Net Ofr Ord Can S/O Ship Rtn Exch Ord Exp % Act % SU6 67 2 0 27 0 1 67 .00 .00 SP6 53 1 0 9 1 1 52 .00 11.11 AAA 4 0 0 4 0 0 4 .00 .00 999 156 3 0 104 18 7 138 5.00 17.30 279 35 0 0 18 7 0 28 1.00 38.88 1 4 0 0 4 1 0 3 .00 25.00 20 1 0 0 0 0 0 1 .00 .00 5 2 0 0 2 0 0 2 .00 .00
F3=Exit F12=Cancel F20=Right |
Fields: Each field on this screen, the Inventory Status - SKU Screen (1 of 2), and the Inventory Status - All SKUs Screen (1 of 2) is described below.
Field |
Description |
Item |
A code representing a unit of inventory. Alphanumeric, 12 positions. |
Item description (Unlabeled field to the right of the item code) |
The description associated with the item. Alphanumeric, 40 positions. |
SKU (Unlabeled field below the item description) |
The SKUs you entered on the selection screen, if any. Alphanumeric, three 4-position fields (split SKU) or one 14-position field (full SKU). |
Retail |
The price defined for the item in the most current offer. If this is the All SKUs screen, and you define prices at the SKU level rather than the item level, the price will display as zero. Numeric, 7 positions with a 2-place decimal. |
Cost |
The average cost of the item. The cost is defined in the SKU file. If you are using the average inventory costing method, the system calculates this field each time you receive a purchase order for the item using the following calculation:
(current on-hand x current average cost) + (quantity received x new purchase cost) / (quantity on-hand + quantity received) = new average cost
The new purchase cost represents the actual cost at which the item was purchased plus any overhead charges and additional item charges. See Warehousing Chapter 34: Purchase Order Receiving Overview. Example: current on-hand quantity = 185 current average cost = 25.00 quantity received = 25 new purchase cost = 28.75 (25.00 + 15% for commission) (185 x 25.00) + (25 x 28.75) / (185 + 25) = 25.45 (new average cost) Numeric, 7 positions with a 2-place decimal. |
The following fields represent column headings for inventory information calculated for: • Total: This row of figures represents the total for all offers for the item or SKU you entered at the selection screen. • Ofr (offer): This row of figures represents the total for this offer only. An offer is a catalog or advertisement you use to present items to your customers. The offer code is defined in and validated against the Offer file. See Chapter 2: Working with Offers (WOFR). |
|
Ord (Ordered) |
The total quantity ordered. If the Update Demand for Order Maintenance Transactions (C72) field in the System Control file is set to Y, the system also updates this field to reflect: • lines added in Order Maintenance • exchanges • changes of item quantity made in Order Maintenance Numeric, 7 positions. |
Can (Canceled) |
The total quantity canceled. Numeric, 7 positions. |
S/O (Soldout) |
The total quantity sold out. Numeric, 7 positions. |
Ship |
The total quantity shipped. Numeric, 7 positions. |
Rtn (Returned) |
The total quantity returned. Numeric, 7 positions. |
Exch (Exchanged) |
The total quantity exchanged. Numeric, 7 positions. |
Net ord (Net orders) |
The net order quantity, calculated as:
Total orders - (total returned + total exchanged)
If a customer exchanges an item for the exact same item and SKU, there is no effect on net orders for that particular item/SKU. Cancels and soldouts do not affect net orders. Numeric, 7 positions. |
Exp % (Expected return percent) |
The percentage of returns you expect customers to make, as defined for the Item/Offer or SKU/Offer. Numeric, 5 positions with a 2-place decimal. |
Act % (Actual return percent) |
The actual return percentage for the item or SKU, calculated as:
(( units returned + units exchanged) / units shipped) x 100
Numeric, 5 positions with a 2-place decimal. |
Screen Option |
Procedure |
Advance to the second Inventory Status Inquiry screen |
Press F20 to advance to the Inventory Status - Non SKU Screen (2 of 2), Inventory Status - SKU Screen (2 of 2), or Inventory Status - All SKUs Screen (2 of 2). |
Inventory Status - Non SKU Screen (2 of 2)
How to display this screen: Press F20 at the Inventory Status - Non SKU Screen (1 of 2).
INR0941 DISPLAY Inventory Sts - Non SKU (2 of 2) 5/06/96 13:16:27 Mail Order
Item: AUGIE AUGIE DOGGIE DOLL
Retail: 15.00 Cost: 8.95
Total: 132 0 Net Ofr Sales On PO SU6 26 0 SP6 7 0 AAA 4 0 999 79 0 279 11 0 1 3 0 20 0 0 5 2 0
F3=Exit F12=Cancel F19=Left |
Field |
Description |
Net sales |
The net amount of the item or SKU sold, calculated as
Total shipped - (Total returns + Total exchanges)
Numeric, 7 positions. |
On PO (On purchase order) |
The total quantity of the item or SKU on open purchase orders. Numeric, 7 positions. |
Screen Option |
Procedure |
Return to the first Inventory Status Inquiry screen |
Press F19 to advance to the Inventory Status - Non SKU Screen (1 of 2). |
Inventory Status - SKU Screen (1 of 2)
How to display this screen: Enter a SKUed item at the Inventory Status Inquiry Screen.
INR0943 DISPLAY Inventory Sts - SKU (1 of 2) 5/06/96 12:10:02 Mail Order
Item: BU001 CHOCOLATE EASTER BUNNY CHOC SMLL Retail: 9.95 Cost: 5.36
Total: 3 0 0 0 0 0 3 5.00 .00 Net Ofr Ord Can S/O Ship Rtn Exch Ord Exp % Act % SU6 3 0 0 0 0 0 3 5.00 .00
F3=Exit F12=Cancel F20=Right |
For more information: See Inventory Status - Non SKU Screen (1 of 2) for field descriptions.
Inventory Status - SKU Screen (2 of 2)
How to display this screen: Press F20 at the Inventory Status - SKU Screen (2 of 2).
INR0943 DISPLAY Inventory Sts - SKU (2 of 2) 5/06/96 13:18:41 Mail Order
Item: BU001 CHOCOLATE EASTER BUNNY CHOC SMLL Retail: 9.95 Cost: 5.36
Total: 0 0 Net Ofr Sales On PO SU6 0 0
F3=Exit F12=Cancel F19=Left |
For more information: See Inventory Status - Non SKU Screen (2 of 2).
Inventory Status - All SKUs Screen (1 of 2)
How to display this screen: Press Enter at the Inventory Status Inquiry Screen without entering an item or SKU.
INR0942 DISPLAY Inventory Sts - All SKUs (1 of 2) 5/06/96 12:11:44 Mail Order
Item: BU001 CHOCOLATE EASTER BUNNY
Retail: .00 Cost: 9.82
Total: 118 5 3 34 5 3 111 5.00 23.53 Net Ofr Ord Can S/O Ship Rtn Exch Ord Exp % Act % SU6 74 0 0 4 0 1 74 5.00 25.00 SP6 44 5 3 30 5 2 37 5.00 16.67
F3=Exit F12=Cancel F20=Right |
For more information: See Inventory Status - Non SKU Screen (1 of 2) for field descriptions.
Inventory Status - All SKUs Screen (2 of 2)
How to display this screen: Press F20 at the Inventory Status - All SKUs Screen (1 of 2).
INR0942 DISPLAY Inventory Sts - All SKUs (2 of 2) 5/06/96 13:22:22 Mail Order
Item: BU001 CHOCOLATE EASTER BUNNY
Retail: .00 Cost: 9.82
Total: 26 254 Net Ofr Sales On PO SU6 3 254 SP6 23 0
F3=Exit F12=Cancel F19=Left |
For more information: See Inventory Status - Non SKU Screen (2 of 2)
Chapter 27: Working with Forecasts (WFCS) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 29: Working with Active Offers (WACO) |
MK03_05 CWDirect 18.0 August 2015 OTN