Accounts Receivable Aged Invoice Report

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax, or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

   

Remove Zero Balance Invoices

Aging Categories

Accounts Receivable Options

Bill To/Sold To Maintenance

Bill To Customer Maintenance

Customer Maintenance

 

 

Navigation

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

Overview

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.

Fields

 

Report Setting

Future Transactions

Description

Transaction Date

Type

Include Paid Invoices

Default Report

Age Credit Memos

Print Report Settings

Print Transaction Date

Three Hole Punch

Print Sold To Customer Number

Number of Copies

Print Condensed

Collated

Operand

Sort Report By

Value

Aging Date/Month Ending Date

Printer/Output

Report Detail Option

Keep Window Open After Print

Aging Option to Print

Keep Window Open After Preview