The Open entries (customer) report gives a combined overview of the invoice entries a specific customer has not yet paid. It pulls all open (unsettled) entries for one selected customer and lays them out sorted by due date, so you can see exactly what is owed, when it fell due, and how old each amount is.
Each entry shows, among other things, fiscal date, voucher/invoice number, description, debit/credit, any amount already settled and the remaining amount, as well as the number of days overdue. The remaining amounts are aged into intervals (under 30 days, 30-60 days, 60-90 days, 90-120 days and over 120 days) with a running total, so you can quickly see how much of the debt is newer and how much fell due long ago. At the top, the customer's master data (name, address and contact) is shown together with your own company's details and payment information (FI code or bank details), so the report can be used directly as a reminder or balance statement to the customer.
The report is opened from the individual customer card under the customer overview in Financial. When you have a customer open in the edit view, you select the report in the customer's report selector. The selected customer is automatically tied to the report, so you do not have to specify which debtor the statement applies to — it follows the customer card you are on.
When the report is started, you can control two fields yourself. The other settings (among other things which customer is shown, which store/department is used as the basis, and whether FI or bank details are shown) are set automatically from the context and the customer card, and you normally do not need to deal with them.
Limits which entries are included: only entries posted up to and including the selected fiscal date are included in the statement. If you leave the field empty, all open entries are included regardless of posting date. Use the field if you want to create a statement that corresponds to a specific cut-off date.
Determines which date the due status and the aging are calculated from. Days overdue and the breakdown into age intervals (under 30 days, 30-60, 60-90, 90-120 and over 120 days) are calculated relative to this date. If you set it to today's date, you get the current aging; if you want to see the picture at an earlier point in time, you specify the desired date here.
There is also a simpler version, Open entries (customer) – Light, which shows the same open entries in a more compact form. Choose it if you just need a short overview rather than the full statement with all master and payment details.
Want to know more?
Read more in these related articles:
Open entries (invoice)
The print shows open (unpaid) sales invoices as of the fiscal date.
Accounts receivable balance
The Accounts receivable balance report shows the customers' total balance as of a selected fiscal date, broken down into age intervals by due date, so you can see how much customers owe and how old the arrears are.
