Reset Reserve Quantity (MRQR)

Purpose: Use this option to reset the reserved quantity of items in inventory, as stored in the Item Warehouse table. The system uses the information in the Reserved Order Line table to determine the correct quantities of items currently reserved on open or held orders.

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.

If there are inventory transaction errors: The system will not complete this reset if there are any inventory transaction errors. You must reprocess these transactions or delete the error records first. See Working with Inventory Transaction Errors (WITE).

Reset Reserve Quantity Screen

Purpose: Enter MRQR in the Fast path field at the top of any menu, or select Reset Reserve Quantity from a menu.

Completing this screen:

1.

Select OK on the Reset Reserve Quantity Screen. Select Confirm and then OK again to submit the Reserve Quantity Reset.

2.

The system submits the RESET_RSRV job and looks at the setting of the Inventory Sharing (A69) system control value.

• If the Inventory Sharing (A69) system control value is selected, the system runs the Reserve Quantity Reset program as a batch job. Note: If you are using inventory sharing, run the reset in the company where you actually maintain the inventory and then run the reset in the company(ies) that share the inventory.

• If the Inventory Sharing (A69) system control value is blank, the system calls the sp_reset_qty_on_reserved SQL stored procedure to perform the reset.

3.

If there are any inventory transaction errors, the job generates an error report indicating that the reset cannot take place until these errors are corrected; see Working with Inventory Transaction Errors (WITE).

4.

If there are no inventory transaction errors, the Reserve Quantity Reset:

• Clears the Quantity reserved for all open or held Order Detail records that do not have any Reserved order lines.

• Resets the Quantity reserved for all open and held Order Detail records by summing the Quantity reserved on related open Reserved Order Line records.

• Clears the Reserve quantity, S/H reserve quantity, and Reserve transfer quantity for all Item Warehouse records.

• Resets the Reserve quantity and S/H reserve quantity for all Item Warehouse records by summing the Quantity reserved on related Order Detail records.

• Resets the Reserve transfer quantity for all Item Warehouse records by summing the Actual quantity on related Autostock Replenish Detail records with a status of A.

• Generates the Reset Audit Log for Quantity Reserved if the Inventory Sharing (A69) system control value is unselected.

Note: If the Inventory Sharing (A69) system control value is selected, the reset does not generate a report.

SO03_09 OROMS 5.0 2018 OTN