Rebalancing Customer Balances

When you click Rebalance Customers, these steps are performed by the application:

  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: Customer orders with a header status of Ordered or Stopped are included.

    Lines for the customer orders with either of those statuses are included if all of the following are true:

    • The line Status is Ordered or Filled.
    • The line Quantity Ordered does not match Quantity Invoiced.
    • The line Shipping Site is the same as the current site (that is, the site where you are logged in, which is not necessarily the same as the order's Originating Site).
  3. Adds the total of all open items into the Posted Balance field.
  4. Displays a message indicating the process is complete.
  5. 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.

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