Recalculate Customer Balances
Form ID: (AR509900)
On this form, you can recalculate customer balances, starting with the selected financial period. Balances are recalculated based on the history records (released AR documents) that are matched to the customer balances stored in the database. The system also uses the open sales orders to determine whether the customer balances exceed the credit limits specified for these customers.
In the Selection area, you select a financial period (and, optionally, a customer class), and you can view the list of customers in the table. To recalculate the balances of all customers in the list, click Process All. To recalculate the balances of only particular customers, select the check boxes next to those customers and click Process.
Form Toolbar
The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.
| Button | Description |
|---|---|
| Process | Recalculates the balances for the customers you have selected in the table. |
| Process All | Recalculates the balances for all the customers listed in the table. |
Selection Area
You use this area to select a financial period and a customer class for which you want to recalculate customer balances.
| Element | Description |
|---|---|
| Fin. Period |
The financial period starting in which you want to recalculate customer balances. By default, this box shows the earliest financial period that is not locked in the accounts receivable subledger, that is, the earliest period with one of the following statuses: Inactive, Open, or Closed. |
| Recalculate Document Balances |
This check box indicates, if selected, that the system will recalculate the balances and statuses of the released documents created for the selected customers starting from the selected financial period. Additionally, the system will recalculate the line balance and the unreleased retainage for these documents. If this check box is selected, the system automatically selects the Customer Balances by Released Documents check box. This check box is selected by default. |
| Recalculate Customer Balance by Released Document |
This check box indicates, if selected, that the system will recalculate the balances for the selected customers starting from the selected financial period based on the released customer documents. This check box is selected automatically if the Document Balances check box is selected. This check box is selected by default. |
| Recalculate Customer Balance by Uneleased Document |
This check box indicates, if selected, that the system will recalculate the unreleased balances and open order balances for the selected customers based on the unreleased AR documents and open sales orders. This check box is cleared by default. |
Table
This table lists all customers or the customers of the class you selected. The list of customers may be limited based on the current user’s access role. The system displays customers whose settings permit the use of the branch, company (or a company in a company group) to which the user’s role is assigned, that is the Restrict Visibility To box on the Financial tab of the Customers (AR303000) form contains this branch, company (or a company within the company group), or branch, or is empty.
| Column | Description |
|---|---|
| Included | An unlabeled check box that you select to include this particular customer for validation if you select Process. |
| Customer ID | The customer who has balance to be recalculated. |
| Customer Class | The class to which the customer belongs. |
| Customer Name | The name of the customer. |