Customer details (AR402000) report

This topic gives you information about the elements that you find in this window in Visma.net ERP, such as fields, field values, buttons, and check boxes.

You use this window to track outstanding balances for each customer. 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.
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:

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.

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 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.

Related concepts

About tracking customer ledger documents