Reset Item Warehouse Quantity On Hand (MRIW) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Unlocking a Stranded Order or Batch (MULO) |
Reset SKU Open Order Quantity (MRSO)
Purpose: Use this menu option to reset the following fields in the SKU table based on the current open orders for the SKU:
• SKU open quantity: the total number of units remaining to be shipped for all open order detail lines, including any quantity reserved and backordered, on open, held, or suspended orders, but excluding drop-ship items and future orders. The Display Item/Warehouse Information Screen displays this field as SKU: Open.
• On hold quantity: the total number of units on held orders, excluding drop-ship items and future orders.
• Quantity order drop ship: the total number of units on open, held, or suspended orders waiting to be drop-shipped, including future orders for drop-ship items. The Display Item/Warehouse Information Screen displays this field as Open D/S.
• Future quantity: the total number of units on open, held, or suspended orders that have the Future order flag set to Y
Scheduling the reset: You can also run this reset using the Daily Inventory Reset periodic function (program name MSR0698); see How to Schedule a Job.
Quotes: Because the system does not reserve inventory for items on quotes, the Reset SKU Open Order Quantity process does not include quotes; see Entering Pre-Order Quotes for an overview.
Reset SKU Open Order Quantity Screen
How to display this screen: Enter MRSO in the Fast path field at the top of any menu, or select Reset SKU Open Order Quantity from a menu.
Completing this screen:
1. |
Select OK on the Reset SKU Open Order Quantity Screen. Select Confirm and then OK again to submit the reset. |
2. |
The system submits the RSET_SKUOO job and calls the sp_reset_qty_quantities SQL stored procedure to perform the SKU Open Order Quantity Reset. |
3. |
Regardless of whether there are any inventory transaction errors, the SKU Open Order Quantity Reset: • Clears the Open quantity, On hold quantity, and Quantity order direct ship for all SKU records. Note: The On hold quantity is based on the Order Header status and not the Order Detail status. • Resets the Open quantity, On hold quantity, and Quantity order direct ship for all SKU records by accumulating the quantities in open, held, and suspended Order Detail records. • Resets the Future quantity for all SKU records by accumulating the quantities in open, held, and suspended Order Detail records with the Future order flag set to Y. • Generates the Reset Audit Log for SKU Quantities. The Order Detail open quantity is calculated as: Quantity Open = (Quantity Ordered - Quantity Cancelled - Quantity Soldout - Quantity Shipped) Note: • The Open quantity in the SKU table includes held orders, which are also included in the Held quantity field in the SKU table. • The Future quantity in the SKU table includes held orders, which are also included in the Held quantity field in the SKU table. |
Reset Item Warehouse Quantity On Hand (MRIW) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Unlocking a Stranded Order or Batch (MULO) |
SO03_09 OMSCS 18.1 April 2019 OTN