Select Detailed report to print an aging report, or select Summary report to print a summarized aging report.

The detailed Aged Open Items Report displays each individual invoice and payment (including company contact name); the summary report prints only one summarized line per customer or job.

Enter the job number, work order number, customer type, salesperson code and project manager you want to include on the report, or press Enter to include ALL on the report.

The current customer code defaults in the Customer field. If the report has a saved template, the application applies those saved settings and then sets this field to the current customer code.

Enter the G/L division code(s) you want to include on this report, or press Enter to print all G/L division codes.

If you select a specific G/L division code, when you press Enter to exit this field, the Show G/L Divisional Portion window displays. Use this window to specify whether to use the selected G/L divisional code each time the Aged Open Items Report is run.

If one or more codes are entered, any invoices that were distributed to sales G/L codes with the matching division codes are selected. If the invoice is distributed to divisions other than those selected, an asterisk displays on the report.

Enter 1 to 120 to print only for overdue customers. If only customers with overdue balances are desired, enter the number of days past due before a customer is to be included on the report.

For example, if you request all customers with at least 30 days past due, only customers who have any open item(s) of at least 30 days appear in the report. The report contains all open invoices for the customer, not just those invoices past due. A customer with one 10-day overdue item would not be included on the report. If left blank, all customers appear in the report.

• If the Include paid invoices checkbox is not selected, the invoice date is used. The report does not include transactions that have dates later than the date entered here.
• If the Include paid invoices checkbox is selected, the General Ledger date is used, rather than the invoice date.

• The Job sort option is selected.
• The Summary report format option is selected, and the Job sort option is selected.

This checkbox is enabled only if a General Ledger division code is entered in the G/L division field.

If this checkbox is selected, the divisional amounts display and the asterisks indicate that other divisions are excluded from the invoice total.

Deselect to include all of the G/L divisions on the report. An asterisk prints on the report indicating that more than one division is associated with the invoice(s) and all the divisional amounts have been included.

Appears only if the Work Order module is enabled.

Select to include work order numbers in the report.

Disabled if the Summary format is selected.

If Multi-Currency processing is being used, the Aged Open Items Report can be translated into an alternate currency. Enter a valid non-reporting currency. The report includes only invoices assigned to print in the specified currency.

At the end of each accounting period, GAAP requires that receivables held in a non-reporting currency be revalued using the month-end FX rate. The Controller should run the Aged Open Items Report by currency, revalue it into the reporting currency, and make the appropriate reversing journal entry.

Displays only if a valid non-reporting currency has been specified in the Currency field.

Select to run the report using the local currency.