Customer summary (AR401000)
The window toolbar
The window toolbar includes standard buttons and a window-specific button. The window-specific button is listed below.
| Button | Description |
|---|---|
| Reports | Provides the following menu commands, which you can click for quick access to reports:
|
The top part
By using the elements in this area, you can select the criteria of customers to be listed in the table.
| Element | Description |
|---|---|
| Company | The company for which you want to display data. By default, it is the company you have access to. |
| Branch | The branch for which you want to display data. By default, it is the branch you have access to. |
| Period | The financial period for inquiry. If you leave the field blank, information related to all open periods will be displayed. |
| Customer class | The customer class selected for inquiry. You can leave the field blank to list customers of all classes. |
| Customer ledger account | The customer ledger account used for customers to be listed. |
| Customer ledger sub. | The corresponding subaccount. |
| Currency ID | The currency for which you want to display data. You can leave the field blank to view the balances in the all currencies used by the customers if you select the Split by currency check box or in the base currency if you clear the Split by currency check box. |
| Split by currency | A check box that you select to view the customer balances by currency. This check box is visible only if the Currency field is blank. |
| Only customers with balance | A check box that you select to display information on only customers that carry non-zero balances. Clear the check box to display all customers. |
| By financial period | A check box that you select to display balances calculated by financial period rather than by document date. Clear the check box to view the balances calculated by document date. |
| Consolidate by parent | A check box that you select to indicate to the system to display the consolidated balance for parent accounts that have child accounts for which the Consolidated balance check box is selected on the Invoicing info tab of the Customers (AR303000) window. The child accounts are excluded from the list if the check box is selected. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| Total balance | A read-only field that shows the total balance for the customers of the selected class or all classes calculated using the specified criteria. |
| Total prepayments | The total amount of customer prepayments calculated for the selected criteria. |
| Total unrealised gain/loss | The total amount of unrealised gains and losses calculated for transactions matching the selected criteria. |
The table
The table contains the list of customers matching the criteria you have specified in the top part.
| Column | Description |
|---|---|
| Customer no. | The unique ID of the customer, which is also a link. Click the link to navigate to the Customer details (AR402000) window with the details of this customer. |
| Customer name | The customer name as it appears in the documents. |
| Last activity period | The last period when any transactions related to the customer were released. |
| Currency ID | The currency used by the customer. |
| Beginning balance (currency) | The beginning balance on documents in the specified currency. |
| Ending balance (currency) | The ending balance on documents in the specified currency. |
| Prepayment balance (currency) | The balance of prepayments made in the specified currency. |
| Sales PTD (currency) | Period-to-date sales made in the specified currency. |
| Payments PTD (currency) | Period-to-date payments made in the specified currency. |
| Cash Discount Taken PTD (currency) | The cash discount total on cash discounts takes in the specified currency. |
| Overdue charges PTD (currency) | Period-to-date overdue charges in the specified currency. |
| Credit notes currency PTD | The total on credit notes made in the specified currency. |
| Debit notes currency PTD | The total on debit notes made in the specified currency. |
| Prepayments PTD (currency) | The total on prepayments made in the specified currency. |
| Beginning balance | The customer’s outstanding balance in the base currency at the start of the specified period. If no period is specified, the column shows the balance at the start of the last activity period. |
| Ending balance | The customer’s outstanding balance in the base currency at the end of the specified period. If no period is specified, the column shows the balance at the end of the last activity period. |
| Prepayment balance | The unapplied amount of the customer prepayments. |
| Sales PTD | The total amount (in the base currency) of the period-to-date (PTD) sales for the specified period. If no period is specified, the column displays the total sales amount during the last activity period. |
| Payments PTD | The total amount of the period-to-date payments (in the base currency) received from the customer for the specified period. If no period is specified, the column displays the total payment amount during the last activity period. |
| Cash discount taken PTD | The total period-to-date amount of cash discounts received by the customer for the specified period. If no period is specified, the column displays the total on all the cash discounts taken by the customer during the last activity period. |
| Realised gain/loss PTD | The total PTD amount of realised gains and losses received as the result of operations with the customer. If no period is specified, the column displays the total realised gain or loss (RGOL) amount for the customer during the last activity period. |
| Credit notes PTD | The total PTD amount of credit notes received from the customer. If no period is specified, the column displays the total credit note amount for the customer during the last activity period. |
| Debit notes PTD | The total PTD amount of debit notes received from the customer. If no period is specified, the column displays the total of the debit notes for the customer during the last activity period. |
| Unrealised gain/loss | The amount of unrealised gain or loss calculated for open documents. |
| Prepayments PTD | The amount of prepayments received during this period until the current date. |