Aging Type

Choose the time span used to group the overdue invoice data. The options are Days and Months.

Aging Offset

Specify a value for the aging offset.

For example, if you select Days in the Aging Type field and enter 3 as the offset, the report contains columns for data overdue by three days, six days, nine days, and so on.

Bank Account

Specify the bank account used for the payment selection.

Control GL Account

Specify the control GL account or range for selecting data to report.

Currency Code

Specify a currency code or range to refine the report.

Customer Balance

Choose an option from the types of customer balance to include in the report. The options are All, Debit, and Credit.

Customer Payment Selection

Specify a payment selection on which to base the report.

Customer per Page

Select Yes to format the output with a new report page for each customer.

Customer Totals Only

Select Yes if the output should display only a single row per customer without additional details.

Customer Type

Specify a customer type or range to refine the report.

Creation Date

Specify a date to refine the report output to transactions created on that date.

Date for Aging Calculation

Enter the date against which the report compares all overdue payments.

Due Invoices Only

Select Yes to include overdue invoices only in the report.

Header Entity

The system uses the details of headoffice address of the business relation associated with the header entity to print on certain reports. These details indicate who the customer should contact if they have questions about the report or statement.

Include Adjustments

Select Yes to include adjustment transactions in the report.

Include Credit Notes

Select Yes to include credit notes in the report.

Include Credit Note Corrections

Select Yes to include credit note corrections in the report.

Invoice Date

Specify the invoice date or range.

Invoice Due Date

Specify a due date or range of dates to restrict the report.

Include Invoices

Select Yes to include invoices in the report.

Include Invoice Corrections

Select Yes to include invoice corrections in the report.

Invoice Open

Select Yes to include unpaid invoices in the report.

Include Payments

Select Yes to include payments in the report.

Include Prepayments

Select Yes to include prepayments in the report.

Invoices within Terms

Select Yes to include invoices that are not yet overdue.

Number

Specify an invoice number or range to restrict the report.

Only Customers with Activity

Select Yes to only include customers whose accounts have been updated by transactions.

Reference

Specify a unique reference number that identifies a payment, such as the check number.

Reporting Currency

Specify the currency to which amounts are converted and displayed on the report.

The default is blank, meaning all amounts are printed in base currency. When you specify a non-base currency, all amounts are converted from the base currency to this currency using the current accounting exchange rate.

Status

Specify the payment status or include all: accepted, allocated bounced, conditional collection, for collection, initial, paid, paid conditionally.

Sort By

Indicate which field to use for sorting the report.

Summary By

Specify the detail level to include in the report summary, such as daybook, GL account, sub-account, cost center, or project.

User Name

Specify a user name to limit the report data to transactions created by that user.

With Opening Balance

Select Yes to include the outstanding open items (invoices, credit notes, adjustments) that were transferred to the customer account from a previous system.