Customer details (AR402000)
You can select the branch, customer, financial period, currency, and customer ledger account–subaccount pair used for the customer; you then view the list of documents associated with the customer.
By default the window displays the list of open customer documents for the selected customer (with the Open status), but you can add to the list closed documents and unreleased documents by selecting the Show all documents and Include unreleased documents check boxes correspondingly.
You can also print other reports based on this information, which are listed under Reports in the upper part of the window.
Cash sales transactions are shown as split into Cash sale and Cash sale invoice transactions.
The window toolbar
| Button | Description |
|---|---|
| Actions | Provides the following menu commands, which you can click to invoke actions:
|
| Reports | Provides the following menu commands, which you can click for fast access to reports:
|
The top part
You use the elements in this area to select a financial period, a customer, and the currency of the operations. Also, you can select a particular customer ledger account with the corresponding subaccount.
| Element | Description |
|---|---|
| Company | The company for which you want to view data. By default, it is the company you have access to. |
| Branch | The branch for which you want to view data. By default, it is the branch you have access to. |
| Customer | The customer whose open documents you want to view. Obligatory. |
| Period | The financial period for which you want to view the data. If you make no selection, information related to all open periods will be displayed. |
| Currency | The currency used with the specified customer. |
| Customer ledger account | The customer ledger account used for the customer. |
| Customer ledger sub | The corresponding subaccount. |
| Show all documents | A check box that indicates (if selected) that closed documents (with the Closed status) are included in the list. The check box is not displayed if a financial period is selected in the Period field. |
| Include unreleased documents | A check box that indicates (if selected) that unreleased documents (with the On hold and Balanced statuses) are included in the list. |
| Balance by documents | A read-only field that displays the total balance recalculated for all customer’s documents matching the selected criteria. The balance will not change based on whether the Open documents only option is selected because Closed documents do not affect the balance. |
| Current balance | A read-only field that displays the customer balance retrieved from the account history records in the database. |
| Prepayments balance | The balance of customer prepayments calculated for the selected criteria. |
| Balance discrepancy | A read-only field that displays the difference between the Balance by documents value and the sum of Current balance and Prepayment balance values. If unreleased documents are not included, the value should be equal to zero; if it’s not zero, there are errors in the database. |
| Include child accounts | A check box that you select to view documents of both the parent account and its child accounts. The Balance by documents, Current balance, Prepayment balance, and Balance discrepancy fields (in the top part of the window) will display the consolidated balance for parent accounts that have child accounts for which the Consolidate balance check box is selected on the Invoicing settings tab of the Customers (AR303000) window. The field is available if the Parent-child customer relationship functionality is enabled in the Enable/disable functionalities (CS100000) window. |
The table
The table contains the list of documents matching the criteria specified in the top part. The amounts or balances on customer payments are shown as negative values.
| Column | Description |
|---|---|
| Customer | The customer number. |
| Branch | The branch ID. |
| Type | The type of customer ledger document: Invoice, Credit note, Debit note, Payment, Overdue charge, or Prepayment. |
| Reference no. | The identifier of the document as it was assigned by the number series. |
| Post period | The period to which the document transactions should be posted. |
| Date | The date when the document was created. |
| Due date | The due date of the document. |
| Status | The status of the document. |
| Currency | The currency of the document. |
| Original amount (currency) | The amount in the currency of the document (before discount). |
| Balance (currency) | The balance of the document in the specified currency. |
| Cash discount taken (currency) | The cash discount taken in the specified currency. |
| Orig. amount | The original amount of the document, before payment application, in the base currency. |
| Balance | The balance of the document, if a payment was applied, in the base currency. |
| Cash discount taken | The amount of cash discount received by the customer on the document. |
| RGOL amount | The total amount of realised gain or loss (RGOL) incurred as the result of currency rate fluctuation. |
| Payment method | The payment method used by the customer for the document. |
| Sales invoice no./payment no. | The reference number of the original customer document. |
| Invoice text | A detailed description of the document. |
| Period beg. balance | The balance of the account at the beginning of the selected financial period. |
| Period beg. balance in currency | The account balance in the specified currency at the start of the selected financial period. |