Chapter 36: Working with Inventory Resets

Purpose: Use the following inventory options to reset quantities when inventory levels become out-of-sync due to system problems:

• Reset Allocation Quantities

• Reset Reserve Quantity

• Reset Backorder Quantity

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

In this chapter:

• Reset Allocation Quantities (MRPC)

• Reset Pick Control Screen

• Print Reset Audit Log

• Reset Reserve Quantity (MRQR)

• Reset Reserve Quantity Screen

• Reset Backorder Quantity (MRBO)

• Reset Item/Warehouse B/O Quantity Screen

• Reset Audit Log for Item Warehouse

• Reset Item Warehouse Quantity On Hand (MRIW)

• Reset Item/Warehouse B/O Quantity Screen

• Reset SKU Open Order Quantity (MRSO)

• Reset SKU Open Order Quantity Screen

• Reset Audit Log for SKU

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 files. The system uses the information in the Pick Control Detail and the Pick Location files to determine the correct quantities.

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.

FLR0241 ENTER Reset Pick Control 4/25/00 14:25:21 EZK Mail Order WARNING! The allocated (printed) quantities in the Order Detail, Reserved Order Line and Item Location files will be reset based on the total quantities printed for each item/SKU record in the Pick Control Detail and Pick Location file. Press the Enter key to submit the job. F3=Exit F12=Cancel

Completing this screen: When you confirm submission of the reset, the system submits the ALLOC_XCHK job. If there are any inventory transaction errors, this job generates an error report indicating that the reset cannot take place until these errors are corrected; see Warehousing Chapter 14: Working with Inventory Transaction Errors (WITE). Otherwise, the system generates the Print Reset Audit Log and resets the printed quantities in the Order Detail, Reserved Order Line, or Item Location file(s) as needed.

Reset Reserve Quantity (MRQR)

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

Note: You can also run this reset by creating and running a periodic function, such as INV_RES, that uses the MSR0698 program.

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.

FLR0239 ENTER Reset Reserve Quantity 4/25/00 14:41:46 EZK Mail Order WARNING! The Item Warehouse reserve quantity will be reset based on the total reserved quantity for each item/SKU in the Reserved Order Line file. Press the Enter key to submit the job. F3=Exit F12=Cancel

Completing this screen: When you confirm submission of the reset, the system submits the RESET_RSRV job. If there are any inventory transaction errors, this job generates an error report indicating that the reset cannot take place until these errors are corrected; see Warehousing Chapter 14: Working with Inventory Transaction Errors (WITE). Otherwise, the system resets the reserved quantities in the Item Warehouse file.

Reset Backorder Quantity (MRBO)

Purpose: Use this option to reset the backorder quantity of items in inventory, as stored in the Item Warehouse file.

The system resets the backordered quantities in the Item Warehouse file based on the totals in the Order Detail file, including order lines that are held. When evaluating the totals in the Order Detail file, the system ignores any order detail line flagged as a future order.

Reset Item/Warehouse B/O Quantity Screen

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

MSR0678 ENTER Reset Item/Warehouse B/O Quantity 4/25/00 14:54:35 EZK Mail Order Enter a specific warehouse, item, and SKU or press F9 to reset all. Warehouse . . . . Item . . . . . . SKU . . . . . . . B/O qty . . . . : 0 F3=Exit F9=Submit reset F12=Cancel

Field	Description
Warehouse	The warehouse whose backorder quantities you want to reset. Leave this field blank to reset all warehouses. Note: If you do not also specify an item, the job resets all warehouses and all items. Warehouses are defined in and validated against the Warehouse file. Numeric, 3 positions; optional.
Item	The item whose backorder quantity you want to reset. Leave this field blank to reset all items. Items are defined in and validated against the Item file. Alphanumeric, 12 positions; optional.
SKU	The particular SKU of the item you want to reset. You must specify a SKU if you selected a SKU’d item, above. The SKU field appears as a single, 14-position field even if you use a split SKU; in this situation, leave a space between each SKU element. Alphanumeric, 14 positions; required if you selected a SKU’d item.
B/O qty (Backorder quantity)	The backorder quantity of the selected item/SKU within the selected warehouse. This quantity appears after you press Enter only if you complete the previous fields (including the SKU, if you selected a SKU’d item), and only if the item is backordered. Numeric, 7 positions; display-only.

Completing this screen: When you confirm submission of the reset, the system submits the RESETBOQTY job. If there are any inventory transaction errors, this job generates an error report indicating that the reset cannot take place until these errors are corrected; see Warehousing Chapter. Otherwise, the system generates the Reset Audit Log for Item Warehouse and resets the backordered quantities in the Item Warehouse file based on the totals in the Order Detail file. When evaluating the totals in the Order Detail file, the system ignores any order detail line flagged as a future order.

Reset Item Warehouse Quantity On Hand (MRIW)

Purpose: Use this option to reset the quantity on-hand for each Item Warehouse record based on the total quantities on-hand for related Item Locations within the warehouse.

Example: The Item Warehouse record indicates that the current on-hand quantity for item AB100 in warehouse 10 is 100. There are two item location records for AB100 in warehouse 10: A010101, with a current on-hand quantity of 15; and BULK, with a current on-hand quantity of 100. This reset adds the on-hand quantities for the two item locations and resets the on-hand quantity for the Item Warehouse to 115 (100 + 15).

How to display this screen: Enter MRIW in the Fast path field at the top of any menu, or select Reset Item Warehouse Quantity On Hand from a menu.

FLR0240 ENTER Reset On Hand Quantity 9/07/06 16:30:05 EZK Mail Order WARNING! The Item Warehouse on hand quantity will be reset based on the total on hand quantity for each item/SKU in the Item Location file. Press the Enter key to submit the job. F3=Exit F12=Cancel

Completing this screen: Press Enter to submit the RESET_ONHD job, which resets the on-hand quantity for each Item Warehouse based on the total on-hand quantities in the related Item Location records.

Reset SKU Open Order Quantity (MRSO)

Purpose: Use this menu option to reset the following fields in the SKU field 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. The Display Item/Warehouse Information Screen displays this field as the SKU: Open.

• On hold quantity: the total number of units on held orders.

• Quantity order direct ship: the total number of units on open or held orders waiting to be drop-shipped. The Display Item/Warehouse Information Screen displays this field as the Open D/S.

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.

INR0859 ENTER Reset SKU Open Order Quantity 9/08/06 15:57:01 EZK Mail Order WARNING! The SKU open order quantity will be reset based on the number of open orders for the SKU. Press the Enter key to submit the job. F3=Exit F12=Cancel

Completing this screen: Press Enter and then enter Y in the confirmation prompt to submit the RSET_SKUOO job, which resets the SKU open quantity, On hold quantity, and Quantity order direct ship in the SKU file. This job also generates the Reset Audit Log for SKU.