AR Aging, by Dimension Report

This section describes the fields and descriptions on the AR Aging, by Dimension report.

The AR Aging, by Dimension report displays AR Aging balance amounts and measures for each customer and project manager, broken out in 30-day intervals, based on either entry dates or due dates. The report is grouped into one or two standard dimensions, which you select.

Outstanding balances represent invoiced amounts minus payments received from customers. The relationship between invoices and payments is based on reconciling customer entries that represent invoices and the customer payments.

Both the entry reconciliation date (which can be in the future) and the reconciliation date (which is the actual date of the reconciliation) must be prior to the statement date for the reconciliation to be included in the report. In addition, only entries and reconciliations that are open as of the statement date are included in the report.

The Total Balance column links to the AR Transactions report. You can also classify entries as due based on the entry date or due date.

Column	Description
Customer No & Customer Name	This column displays the customer's number and name.
Project Manager No & Name	This column displays the project manager's number and name, if there is an associated project manager.
Balance, Total	This column displays the customer's outstanding balance, based on the statement date. Entries with a due date or entry date equal to the statement date are considered due.
0-30 days	This column displays the outstanding balance of entries that have an entry date or due date up to 30 days old according to the statement date given.
31-60 days	This column displays the outstanding balance of entries that have an entry date or due date that is between 31 and 60 days old according to the statement date given.
61-90 days	This column displays the amount outstanding that is between 61 and 90 days old.
91-120 days	This column displays the amount outstanding that is between 91 and 120 days old.
121+ days	This column displays the amount outstanding that is more than 120 days old.
Last Payment	This column displays the date of the latest payment entered for the customer.