AR Ledger Report
Use the AR Ledger report to review billing history. For each project, phase, or task, the report displays invoices generated and payments received. The report also displays the average collection period for all paid invoices.
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 ().
Credit Memos
Credit memos are listed separately on the AR Ledger report below the invoice to which they apply. The Mod/Receipt Detail column for a credit memo displays the words Credit Memo to help distinguish it from a row that represents an invoice, a receipt, retainage, and a retainer.
If the Print Modification Detail check box is selected on the Options tab of the AR Ledger Options dialog box, then a credit memo’s posting period and posting sequence number display in the Mod/Receipt Detail column instead of the words Credit Memo.
Sort and Group by Billing Group
If you group by Billing Group Name or Billing Group Number, DPS uses the project name and number for projects that do not belong to a billing group.
Multiple Companies
If you use multiple companies, the column headings and account mappings are based on the mappings set up for the company that owns each project.
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.