Rebalance Customer Balances

Use the Rebalance Customer Balances utility to ensure the On Order Balance and Posted Balance fields on the Customers record are correct.

NOTE: If you use an external financial system to handle Accounts Receivable (the Use External A/R System field is selected on the External Financial Interface Parameters form), this utility skips the recalculating of the posted balance.

What Happens During Rebalancing

When you click Rebalance Customers, the system does the following:

  1. Sets the On Order and Posted Balance fields for each selected customer to zero.
  2. Adds the total price (quantity ordered * price) of each ordered line/release into the On Order Balance field.

NOTE: The system includes only customer orders with a header status of "Ordered" or "Stopped."

  1. Adds the total of all open items into the Posted Balance field.
  2. Displays a message indicating the process is complete.
  3. Displays a list of all customers with balances over their credit limits. This list includes the customer number, name, on order balance, posted balance, and credit limit.

NOTE: Balances for corporate customers in the specified range also account for all of the corporate customer's "child" customers - even if the child customer numbers are not in the specified range. This is necessary to provide accurate balances for the corporate customer.

Related Topics

Accounts Receivable Steps

Using Utilities and Activities