AR Aged
Project managers and finance managers use the AR Aged report to manage their outstanding accounts receivable.
For each project, the report displays the balance due, the length of time the receivables have been outstanding, and when the last cash receipt was posted. You can include a detail line for each invoice.
Use the AR Aged report to do the following:
- Decide when a client payment is delinquent. The report displays unpaid balances by age, so you can determine if you need to increase the collection effort for a client.
- Forecast cash flow. If you monitor your AR Aged report and your AR Ledger report over a period of time, you can see clients' payment patterns.
- Obtain financing. You can use the report to show potential lenders the receivables owed to your firm.
On the Project lookup, you can search on an invoice number or on unpaid invoices. These searches help you locate projects that have at least one invoice that matches your criteria. However, they do not filter the invoices. The report still includes all of the invoices for each project you select.
Leading Zeros in Invoice Numbers
If your enterprise uses leading zeros in invoice numbers but you do not want to display the zeros on the report, clear the Display Invoice Leading Zeros option in the Invoice section on the General tab of the Accounting System Settings form ().
Contact Name and Phone Number
Contact names and phone numbers only appear on the AR Aged report if the contact is specified in the billing terms. This is true even if you select Contact and Telephone in Client info to display on the Options tab in the Options dialog box.
Credit Memos
Credit memos are not listed separately on the AR Aged report. Credit memos posted against an invoice are reflected in the invoice balance listed on the report.
Comment Review Access
The Accounts Receivable Comment Review Access option on the Accounting tab of the Roles form () controls whether or not you can view invoice comments on this report.
Pre-Invoices
If you select the Enable Pre-Invoices option on the Miscellaneous tab of the Billing Setup form (), you can choose whether or not to include pre-invoices on the AR Aged report. The report will include unpaid pre-invoices that are not canceled, in addition to regular invoices. The drill-down hyperlinks for pre-invoices are disabled in the report.
Sort and Group by Billing Group
If you group by Billing Group Name or Billing Group Number, the project name and number are used for projects that do not belong to a billing group.
Expanding and Collapsing Report Groups
If you are using Microsoft SQL Server 2008 and if, on the Options tab for this report, you elect to display client address information or AR comments and you also enable the option to collapse and expand a report group, DPS disables the expand/collapse option for report groups when you generate the report with this set of options. This is necessary because a defect in Microsoft software would cause the report to fail otherwise.
Options Dialog Box
Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.