Stock Aging Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Print Inventory Usage Report (PIUR) |
Inventory Inquiry by SKU (DSQI)
Purpose: Use this menu option to review inventory and order status for all SKUs of an 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 Status Inquiry (ISIQ): to review order activity for any item or SKU broken out by offer
How to display this screen: Enter DSQI in the Fast path field at the top of any menu, or select Display SKU Quantity Inquiry from a menu.
Field |
Description |
Item |
Enter the item that you would like to review. The item description appears immediately below the item. Note: If you are currently reviewing an item and would like to select a different one, you must press Enter to clear the previous item’s information from the screen and replace it with the current item. Item: alphanumeric, 12 positions; required. Description: alphanumeric, 30 positions; display-only. |
Department |
The long SKU department specified in the L/S dept (Long SKU department) field for the item. The description appears to the right. Department: numeric, 4 positions; display-only. Description: alphanumeric, 30 positions; display-only. |
SKU |
The item’s unique characteristics, such as its color and size. Alphanumeric, three four-position fields; display-only. |
O/H (On-hand) |
The number of units in all allocatable warehouses (that is, the Allocatable flag is selected). Numeric, 7 positions; display-only. |
Rsv (Reserved) |
The total quantity of the item/SKU on reserved order lines on open, held, or suspended orders. Numeric, 7 positions; display-only. |
B/O (Backordered) |
The total quantity of the item/SKU that is backordered. This total does not increase for zoned reservation items, future orders, noninventory items, continuity items, subscriptions, main set items or memberships, and does not normally include drop ship items unless you also keep them in inventory. Numeric, 7 positions; display-only. |
Avl (Available) |
The total quantity of the item/SKU available, calculated as: on hand - protected - reserved - reserve transfer - backordered = quantity available To determine the quantity for each of the fields in the quantity available calculation, the system adds the fields for all item warehouse records whose allocatable flag is selected. Numeric, 7 positions; display-only. |
Prt (Printed) |
The total quantity of the item/SKU on printed pick slips. Numeric, 7 positions; display-only. |
O/O (On order) |
The total quantity of the item/SKU not yet received on purchase orders. Numeric, 7 positions; display-only. |
Slc (Soldout control code) |
The soldout control code, if any, specified in the S/O control (Soldout control) field for the item/SKU. Alphanumeric, 2 positions; display-only. |
Ofr (Offer) |
The most current offer for the SKU. How the system determines which offer to display: Is there a current SKU/offer? Today’s date must be within the start date and end date for the offer. • If there is more than one current SKU/offer, use the offer whose start date is the latest. • If there is more than one current SKU/offer with the same start date, use the first offer alphanumerically. If there is no current SKU/offer: Select an item/offer using the same steps as described above for selecting a SKU/offer. If there is no current item/offer or SKU/offer, do not display an offer for the SKU. Alphanumeric, 3 positions; display-only. |
Price |
The price of a single unit of the item/SKU in the displayed (most current) offer. Note: The most recent (but not future) Effective date for the price of a single unit item or SKU controls the price that is shown here. If the only effective date is in the future, then the price is.00. You can review item/prices or SKU/prices associated with specific item/offers or SKU/offers by entering Select Price breaks for an offer at the Work with Item Offers Screen or Work with SKU Offers Screen. Numeric, 7 positions with a 2-place decimal; display-only. |
Cost |
The cost of the item/SKU from the SKU table. Depending on the setting of the Costing Method (A25) system control value, this could be the average cost, standard cost, or the Weighted Average FIFO Cost. Numeric, 11 positions with a 4-place decimal; display-only. |
Stock Aging Report | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Print Inventory Usage Report (PIUR) |
DSQI OROMS 5.0 2018 OTN