Open topic with navigation

Select Accounts Receivable Reports menu > Accounts Receivable Aged Invoice Report.

Use the Aged Invoice Report to provide a detailed list of invoices by customer number and by aging categories for all or for a selected range of customers. This report provides a concise overview of outstanding receivables balances and is useful for managing collections and achieving an efficient receivables turnaround. You can include open invoices only, paid invoices only, or all invoices.

If the Enable Bill To Customer Reporting check box is selected in Accounts Receivable Options, the sold-to customer information can be included for the bill-to customer.

If the Job Cost module is integrated with Accounts Receivable, the job number and retention balance are also printed for job-related invoices.

You can specify complete invoice item detail, invoice information without item detail, or summary total information by customer. You can also include, and age, any credit memos issued during the selected period.

You can enter a selection of customer numbers and names, salespersons, customer types, states, ZIP Codes, phone numbers, sort fields, customer purchase orders, and user-defined fields (UDFs) to print.

Note Information is provided for any specific date as long as the date does not represent a period that is already closed, or the invoice date and the accounting date are not in the same accounting period.

The report can include any one or all of the four aging categories specified in Accounts Receivable Options. For each invoice, the report shows the invoice number, invoice date, amount, due date, and discount due date (if applicable). Totals are printed by customer number and by division, with a grand total of all invoices shown as the report total.

If the Track Job Cost Retention Receivables check box is selected in Accounts Receivable Options, the Aged Invoice Report prints only three aging categories, instead of the standard four. The last column is used to print the retention balance. The aged invoice balance does not include the retention balance.

Invoices purged from the Accounts Receivable Open Invoices files do not display on the Accounts Receivable Aged Invoice Report, even when it is printed as of the last date. Records for paid invoices are purged by using the Remove Zero Balance Invoices utility. Paid invoice records are also removed during period-end and year-end processing based on the setting in the Days to Retain Paid Invoices field in Accounts Receivable Options.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks