Resetting the Order Billing History Table (ROBH)

Purpose: Use the Reset Order Billing History file menu option to rebuild Order Billing History records for an order using the records in the Order Detail table.

When to run the reset: You should reset Order Billing History at night, when there will not be any activity that might update the Order Billing History table.

Instructions:

1. On the Recover Order Billing History File Screen, use the Starting order # and Ending order # fields to enter an order number or range of orders whose Order Billing History you wish to recreate.

2. Select OK.

3. Select Confirm to submit the OBH_RESET job in a held status.

4. On the Work with Submitted Jobs screen, release the OBH_RESET job from hold to begin the process of rebuilding Order Billing History for the orders you specified.

The OBH_RESET job:

• Deletes all of the Order Billing History records for the specified orders.

• Rebuilds the Order Billing History records for the specified orders, using the associated records in the following tables:

- Order Detail

- Order Ship To

- Source

- Division

- Order Header Extended

- Item

- SKU

• Recovers maintenance transactions from the Order Line History table.

• Recovers billing transactions from the Invoice Detail table.

You can review Order Billing History for a customer on the Order Billing History Detail Screen.

Quotes: The Reset Order Billing History process does not include records in the order tables that are associated with a quote; see Entering Pre-Order Quotes for an overview.

Recover Order Billing History File Screen

Use this screen to define the order number or range of orders whose Order Billing History you wish to recreate, based on the records in the Order Detail table.

How to display this screen: Enter ROBH in the Fast path field at the top of a menu or select Reset Order Billing History File from a menu.

Field	Description
Starting order #	The starting order number in the range whose Order Billing History you wish to recreate, based on the records in the Order Detail table. Numeric, 8 positions; required.
Ending order #	The ending order number in the range whose Order Billing History you wish to recreate, based on the records in the Order Detail table. Numeric, 8 positions; required.