Aged Accounts Receivable Report

This report shows the aging of receivable accounts. The program calculates aging from the due date, posting date or document date depending on your choice on the Options tab. You must specify the date you want aging calculated from and the length of the period each column will contain data for. If you leave the Print Amounts in LCY field blank, the report will summarize receivables per currency code at the bottom of the report.

You can define what is included in the report by setting filters. You can add fields to the Customer tab by clicking the Field field, pressing F3 and then clicking the AssistButton that appears to the right.

To print the report, click Print. To see the report on the screen before printing it, click Preview.

Fill in the fields as follows:

Customer

No.: Enter the numbers of the customers you want to include in the report.

Options

Aged as of: Enter the date that you want the aging calculated for.

Aging by: Select whether the aging will be calculated from the due date, posting date or document date.

Period Length: Specify the length of each of the three periods, for example, enter "1M" for one month.

Print Amounts in LCY: Place a check mark in this field if you want the report to specify the aging per customer ledger entry.

Heading Type: Select whether the column heading for the three periods will indicate a date interval or the number of days overdue.

New Page per Customer: If you have chosen two or more customers to be included in the report, enter a check mark to print each customer balance on a separate page.

Print to Excel: Place a check mark in the check box if you want to export the data to an Excel spreadsheet for further analysis or formatting before printing.