Customer Balances Report

---

This report prints customer aged balances, including transaction detail. You can determine the output and format of the report by selecting various options before the report runs.

Header Details

• Report process date and time
• Page number

Line Details

• Customer code
• Customer name
• Currency
• Total amount due
• Current period value
• Overdue 1 period value
• Overdue 2 period value
• Overdue 3 period value
• Overdue 4 period value
• Hold value
• Future value
• Branch

If the option to Print Transaction Details is selected, this detail also displays for each transaction:

• Transaction date
• Transaction type (for example, invoice, receipt, credit note, journal)
• Transaction reference
• Transaction amount
• Currency

The report displays sub-totals depending on the Group by option selected in the Parameters below, and a grand total value is also displayed.

Customer Name

Enter the range of supplier names in the From and To fields. If you want to run a report for a single supplier, you only need to enter the name in the From field.

To include all of your suppliers in the report, enter zzz in the To field.

Customer Code

Enter the range of unique alphanumeric codes that represent suppliers in the From and To fields. If you want to include a single supplier in the report, you only need to enter the code in the From field.

To include all supplier codes in the report, enter zzz in the To field.

Branch Code

Enter the range of unique alphanumeric codes that represent the branches suppliers belong to in the From and To fields. If you want to include a single branch in the report, you only need to enter the code in the From field.

To include all branches in the report, enter zzz in the To field.

Currency Code

Enter the range of currency codes of the suppliers in the From and To fields. If you want to include a single currency code in the report, you only need to enter the code in the From field.

To include all currency codes in the report, enter zzz in the To field.

Calendar Name

Enter the range of working calendars that summarise AR transactions by period in the From and To fields. If you want to include only one working calendar in the report, you only need to enter the name in the From field.

To include all working calendars in the report, enter zzz in the To field.

Salesperson Code

Enter the range of codes for salespeople that you want to include in the report in the From and To fields.

---