Reset Allocation Quantities (MRPC)

Purpose: Use this option to reset the printed quantities for orders, as stored in the Order Detail, Reserved Order Line and the Item Location tables. The system uses the information in the Pick Control Detail and the Pick Location tables to determine the correct quantities.

Note: To reduce the amount of time it takes to run this process, you should use Streamlined Pick Slip Generation (WSPS) to generate pick slips for as many orders as possible.

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).

Excluded from reset: The reset excludes any order lines that are:

• printed on drop ship pick slips or purchase orders

• brokered backordered lines being fulfilled through the Order Broker integration

• store pickup lines being fulfilled through the Order Broker

See Order Broker Integration for information on fulfilling brokered backorders or store pickup orders through the Order Broker.

Scheduling: You can schedule when you want this reset to run using the RSTPICK periodic function.

Reset Pick Control Screen

How to display this screen: Enter MRPC in the Fast path field at the top of any menu, or select Reset Allocation Quantities from a menu.

Completing this screen:

1.

Select OK on the Reset Pick Control Screen. Select Confirm and then OK again to submit the Allocation Quantity Reset.

2.

The system submits the ALLOC_XCHK 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 Allocation Quantity Reset program as a batch job. Note: If you are using inventory sharing, run the Allocation Quantity Reset in the company where you actually maintain the inventory and then run the Allocation Quantity 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_printed_full SQL stored procedure to perform the Allocation Quantity 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 Allocation Quantity Reset:

• Clears the Quantity printed for all Item Location, Order Detail, and Reserved Order Line records.

• Resets the Quantity printed for all open Order Detail records by summing the Quantity printed on related Pick Control Detail records.

• Resets the Quantity printed for all open Reserved Order Line records by summing the Quantity allocated on related Pick Location records.

• Resets the Quantity printed for all Item Location records by summing the Quantity allocated on related Pick Location records.

• Removes pick slip preparation from the order and then reevaluates the order for pick slip preparation; see Preparing Orders for Pick Slip Generation.

 

Note:

• If you ran the Allocation Quantity Reset as a stored procedure (the Inventory Sharing (A69) system control value is unselected), the system also generates the Reset Audit Log for Quantity Printed.

• If you ran the Allocation Quantity Reset as a batch job (the Inventory Sharing (A69) system control value is selected), the system also generates the Print Reset Audit Log.

• The reset excludes any order lines:

- printed on drop ship pick slips or purchase orders

- brokered backordered lines being fulfilled through the Order Broker integration

- store pickup lines being fulfilled through the Order Broker

See Order Broker Integration for information on fulfilling brokered backorders or store pickup orders through the Order Broker.

SO03_09 OMSCS 18.1 April 2019 OTN