Recalculate High Balances

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

You can recalculate customer high balances when you print statements or when you perform Period End Processing. Calculating high balances during Statement Printing updates the high balance for selected customers based on the date specified. Calculating high balances with Period End Processing updates high balances for all customers based on the date specified and includes all invoices on file, future transactions, and payments.

In both Statement Printing and Period End Processing, you can specify a date earlier than the current period; however, the high balance will reflect the most current period in which these processes have been run.

You can also update customer high balances by accessing Statement Printing from the Customer Maintenance Invoice tab. Printing a statement from Invoice tab only updates the customer high balance for the customer selected.

 

To recalculate customer high balances with Statement Printing

  1. Select Accounts Receivable Period End menu > Statement Printing.

  2. Enter the statement aging date and any other information you want printed. For more information, see Statement Printing - Fields.

  3. Select a range of customers.

  4. Click Print.

  5. Updated high balances for the customer selected can be viewed in the Highest Balance field on the Customer Maintenance Statistics tab.

To recalculate customer high balances with Statement Printing from Customer Maintenance

  1. Select Accounts Receivable Main menu > Customer Maintenance.

  2. Enter the customer number, and then click the Invoices tab. For more information, see Customer Maintenance - Fields.

  3. Click the Statement Printing button.

  4. In the Statement Printing window, enter the statement aging date and any other information you want printed. For more information, see Statement Printing - Fields.

  5. Click Print.

  6. The updated high balance for the customer selected can be viewed in the Highest Balance field on the Customer Maintenance Statistics tab after you refresh the data (exit the customer record and then access it again).

To recalculate customer high balances with the Recalculate Customer High Balances utility

  1. Select Accounts Receivable Utilities menu > Recalculate Customer High Balances.

  2. Enter the date to recalculate as of in the Recalculate Customer High Balances as Of field. For more information, see Recalculate Customer High Balances - Fields.

  3. Click Proceed.

  4. Updated high balances for all customers can be viewed in the Highest Balance field on the Customer Maintenance Statistics tab.

The customer's high balance is recalculated.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks