Reset Backorder Quantity (MRBO)

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

Generation options: You can run the reset for all items in all warehouses, or for a specific item/SKU in a specific warehouse. You cannot specify a warehouse unless you also specify an item/SKU:

Update all Item Warehouse records:

- If you leave the Warehouse, Item, and SKU fields blank, the job resets all Item Warehouse records and generates a report.

- If you enter just the Warehouse, the screen displays an error; but if you submit the job anyway, it resets all Item Warehouse records and generates a report.

Update a single Item Warehouse record: Otherwise, if you specify a warehouse and item/SKU, the job resets just that Item Warehouse and does not generate a report. Since the screen displays the current B/O qty if you enter the warehouse and item/SKU, you can compare this number with the Backorder quantity after you exit the screen.

Note: If you specify a warehouse and the item code for a SKU’d item, you must also specify a SKU.

Inventory sharing? The setting of the Inventory Sharing (A69) system control value determines which program performs the backorder reset. If this system control value is:

selected: the system runs a batch job; also, it generates the Reset Audit Log for Item Warehouse unless you specify a warehouse and item/SKU. Note: If you are using inventory sharing, run the Item Warehouse Backorder Quantity Reset in the company where you actually maintain the inventory and then run the Item Warehouse Backorder Quantity Reset in the company(ies) that share the inventory.

unselected: the system runs the sp_reset_qty_backordered SQL stored procedure; also, it generates the Reset Audit Log for Quantity on Backorder unless you specify a warehouse and item/SKU.

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.

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.

Field

Description

Warehouse

The warehouse whose backorder quantities you want to reset. Leave this field and the Item and SKU fields blank to reset all warehouses. See the discussion on generation options above for more information.

Warehouse codes are defined in and validated against the Warehouse table.

Numeric, 3 positions; optional.

Item

The item whose backorder quantity you want to reset. Leave this field and the Warehouse and SKU fields blank to reset all items. See the discussion on generation options above for more information.

Item codes are defined in and validated against the Item table.

Alphanumeric, 12 positions; optional.

SKU

The particular SKU of the item you want to reset. Required if you select a Warehouse and a SKU’d Item; otherwise, leave this field blank. See the discussion on generation options above for more information.

Note: The SKU field appears as a single, 14-position field. Leave a space between each SKU element, or leave one or more additional spaces if a SKU element is shorter than the full 4 positions.

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. If you specify a warehouse and item/SKU and select OK, this field displays the current backorder quantity for that Item Warehouse. See the discussion on generation options above for more information.

Numeric, 7 positions; display-only.

Completing this screen:

1.

Optionally, specify the warehouse and item/SKU whose backorder quantity you wish to reset.

Select OK to validate your entries.Correct any errors and select OK again.

Note:

• If you specify a warehouse and item/SKU, the current backorder quantity for the Item Warehouse record is displayed.

• If you specify a warehouse but not an item/SKU, the screen displays an error; however, if you submit the reset anyway, the program updates all items in all warehouses.

2.

Select Submit Reset to submit the RESETBOQTY job:

Update to Item Warehouse Backorder quantity:

• Clears the Backorder quantity for the Item Warehouse records included in the reset.

• Resets the Backorder quantity for the Item Warehouse records included in the reset to equal the sum of the related Open and Held non-drop ship order detail lines in the Order Detail table. The system does not include any order detail lines flagged as a future order.

Update to Order Detail Open quantity:

Open Quantity = (Quantity Ordered - Quantity Cancelled - Quantity Soldout - Quantity Shipped - Quantity Reserved)

Report: The system uses the Inventory Sharing (A69) system control value to determine the reset program to use and the report to generate. If you are updating all Item Warehouse and the Inventory Sharing (A69) system control value is:

selected: the reset generates the Reset Audit Log for Item Warehouse. Note: If you are using inventory sharing, run the Item Warehouse Backorder Quantity Reset in the company where you actually maintain the inventory and then run the Item Warehouse Backorder Quantity Reset in the company(ies) that share the inventory.

unselected: the reset generates the Reset Audit Log for Quantity on Backorder.

Note: When you specify a warehouse and item/SKU, the update to the specified Item Warehouse takes place interactively and no report is generated.

SO03_09 OMSCS 19.0 December 2019 OHC