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.