Running the Accounts Receivable Aging Report

Print Zero Balance Customers

Select this check box to include all customers with zero or greater balance.

Print Credit Balance Customers

Select this check box to include on the report those customers with a credit balance.

Translate to Domestic Currency

Select this check box to translate amounts in the report to the domestic currency.

Show Active Transactions Only

Select the check box to print only active transactions on the report.

Summarize Corporate Customers

Select this check box to consolidate the subordinate customer information for each corporate customer and print it on the report.

Use Historical Currency Rate

Select this check box to calculate and print any estimate of future gains/losses based on the current exchange rate.

Print Open Payments

Select this check box to include open payments on the statements or on the report. If Print All Posted Transactions is not selected, this field is disabled.

Sort by Currency

Select this check box to sort and print the report by currency code.

Display Report Header

Select this check box to include report headers in the output.

Display Report Detail

Select this check box to include summaries of the aging bucket amounts by customer on the report.

Credit Hold

Select whether to include orders where the customer is on credit hold.

Site Group

Select the multi-site group to include in the report.

Sort By

Select the method by which to sort the report:

• Name
• Number
• Salesperson

Consolidate Customers

Select this check box to show report results by customer then by site, instead of by site then by customer.

Aging Buckets

Specify the numbers of the aging buckets for which to print the report.

Statement Cycles

Specify the statement cycles to include in the report.

Aging Date

The current date is displayed. Optionally, select a different date to use to calculate the age of the transactions. The date selected is the date from which the system starts to count the aging buckets.

Cutoff Date

Select the date to use as the cutoff. All transactions with distribution dates before and including this cutoff date are included in the report.

Increment Date

Select this check box to automatically increment the date range and re-run the report.

Print Posted Transactions

Select the method by which you want to print the transactions:

• Due Date: Print the posted transactions by invoice due date.
• Invoice: Print them by invoice date.
• No: Print only a summary (with no posted transactions included) for each customer.

Hide Paid Invoice Older Than

Use this field to hide paid invoices from the report output that are older than a certain number of days from the current date. Specify the maximum age in days that a paid invoice can still be displayed on the statements or accept the default of 60 days.

Aging Basis

Select the aging basis to use to print the open item amounts:

• Invoice Date: Print based on the invoice dates of the posted transactions.
• Due Date: Print based on the due dates of the posted transactions.

• Salesperson
• Customer
• Name
• Currency Code

The default values print a report for all customers.