Resetting the Order Billing History Table (ROBH) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Resetting Serial Numbers (RSER) |
Resetting Customer Sold To $ On Order (RONO)
Purpose: Use this menu option to reset the On order amount field in the Customer Sold To Order History table so that it matches the amount of any existing open orders for the customer.
You can review the On order amount on the Display Customer Order History Screen. The on order amount is the total dollar value of all open, unshipped orders for a customer, including charges for merchandise, freight, tax, special handling, and shipping. The system subtracts the amount of a cancelled item or order from this field. The on order amount does not include the amount of soldout items on the order.
When should I run a reset? You should only perform a Customer Sold To $ On Order reset if you suspect the On order amount for a sold to customer is incorrect. For example:
• an On order amount exists for a sold to customer that does not have any open orders.
• a negative On order amount exists for a sold to customer.
• an On order amount of 1.00 or less exists for a sold to customer.
Note: Before you run this reset, you should end all background async jobs so that the On order amount is not changed while the reset job recalculates the On order amount.
Scheduling the reset: You can also run this reset using the Reset Customer Sold To $ On Order periodic function (program name CSRSTONORD); see How to Schedule a Job.
Quotes: Because the system does not update the Customer Sold To $ On Order for quotes, the Reset Customer Sold To $ On Order process does not include quotes; see Entering Pre-Order Quotes for an overview.
To reset the sold to on order amount: Enter RONO in the Fast path field or select Reset Customer Sold To $ On Order from a menu. The system submits the RESET_CST job. This job:
1. |
Calls the sp_reset_customer_on_order SQL stored procedure to perform the Customer Sold To $ On Order Reset. |
2. |
Retrieves all customers from the Customer Sold To Order History table by company code. |
3. |
For each customer sold to, accumulates the total open balances for Order Ship To records, excluding any Order Ship To records associated with an Order Header status of A, C, X, E, P, or S: • unshipped merchandise balance • freight balance • tax balance • handling balance • additional charges balance • additional freight charges balance |
4. |
Calculates a grand total by accumulating the total balances. |
5. |
Compares the grand total to the COH On Order $ field in the Customer Sold To Order History table. • If the amount in the COH On order $ field matches the grand total, the job retains the value in the COH On order $ field. • If the amount in the COH On Order $ field does not match the grand total, the job updates the COH On order $ field with the grand total. If no open balances are found, the job updates the COH On order $ field to 0. |
Note:
• Because the Reset Customer Sold To $ On Order process retrieves all customers from the Customer Sold To Order History table, this job may take awhile to complete.
• The Reset Customer Sold To $ On Order process does not reset the Order Header status to closed.