to select the customers to be included on the report. One or more customer IDs may be selected. If the field is empty, all customers will be considered for inclusion on the report.AR Aging displays the accounts receivable documents with an open balance. Use this report to determine what your customers owe your company and when the payment is/was due. This report will show customers that are late in making their payments along with how late they are.
See also About Aging and Customer Statements.
Internal Company – The company from which the data is being reported.
Customer – Click Lookup to select the customers to be included on the report. One or more customer IDs may be selected. If the field is empty, all customers will be considered for inclusion on the report.
Project Manager – Click Lookup to select the project managers to be included on the report. One or more project managers may be selected. If the field is empty, all active project managers will be considered for inclusion on the report.
Project – Click Lookup to select the projects to be included on the report. One or more project IDs may be selected. If the field is empty, all projects will be considered for inclusion on the report.
In Select Documents By, choose the date type to use to determine which receivables documents to include on the report.
In Selection Date, specify the date to use as the cutoff for receivables documents to include on the report.
In Using, select the method to use for aging the receivables document on the report. Options include:
Last Aging Process Results – This option uses the date used the last time the Aging process was run.
Specific Aging Date – This option uses the date entered in Aging Date on Report Options and ages the documents based on the Age Invoices By setting, either Due Date or Invoice Date, on the Settings tab of Receivables Policies. As the report is running, the documents are aged 'on the fly' using the aging date against the due date or invoice date. No data is saved in the database. It is calculated, displayed on the report, and done. If the report is re-run with different criteria, it re-calculates using the new settings. If the report is re-run with the same criteria, the aging process should produce the exact same results.
Aging Date – A valid date must be entered in Aging Date when Using is set to Specific Aging Date. This is the date by which to age the documents.
Customer Risk – Select the user-defined risk(s) to report on.
Customer Class – Click Lookup to select the customer class to be included on the report. One or more customer class IDs may be selected. If the field is empty, all customer classes will be considered for inclusion on the report.
Summary or Detail – Select Summary to have the transactions summarized by customer (depending on what is selected in the Summary Options). Select Detail to display individual documents.
Sort By – Select Customer, Project ID or Project Manager from the dropdown box to define the sort order. This option defaults to Customer.
Include Adjustments – Select this check box to have adjustments displayed on the report relative to the invoice(s) they adjusted.
Include Payments – Select this check box to have partial payments displayed on the report relative to the invoice(s) they adjusted.
Print Zero Balance Customers – Select this check box to have customers with a current balance of zero included on the report. This field is unchecked by default.
For information about using this report in the financial reconciliation process, see Reconciling Account Balances.