AR Ledger Options Tab

The Options tab gives you additional control over the information on the AR Ledger report.

Contents

Field Description
Client Info to Display

If you select None, no additional client information is added to the report.

If you select an option other than None, the effect of that option depends on your selections on the Sorting/Grouping tab.
If you sort and group by... Option The report displays this information:
Billing Client Number or Billing Client Name Number and Name No additional client information
Contact and Telephone All contacts associated with each billing client
Full Address Each billing client's billing address and all of the client's contacts
Client Number or Client Name Number and Name No additional client information
Contact and Telephone All contacts associated with each primary client
Full Address Each primary client's billing address and all of the client's contacts
Project Number or Project Name Number and Name Each project's billing client number and name
Contact and Telephone Each project's billing contact
Full Address The billing address for each project's billing client and the project's billing contact

Print Client Notes Select this check box to include notes entered in the Firms hub. DPS displays the full text of the notes as the last line of the client information section. If you commonly want to include notes on this report, we recommend that you try to limit the length of the notes you enter for clients. Otherwise, the notes can increase the size of the report significantly. The notes in the report retain any text formatting that was applied when they were entered in the Firms hub.
Print Invoice Detail Select this check box to display the invoice number, date, and amount of the invoice for each transaction posted during the period.
Print Modification Detail Select this check box to display the invoice number, the year and month, and the number of postings for the accounting period for which the report is generated.
Print Billed/ Received Totals Select this check box if you want the project totals and final totals sections to include totals of billed, received, and retainage amounts. This option only applies to the project level. If you sort and group the report by phase or task, the report does not display total billed, received, and retainage amounts for those.

Paid Invoices

You have three options for retention of paid invoices (invoices with a zero balance) in the ledger:

  • Keep the ledger information for the life of the job
  • Keep the ledger information for the fiscal year
  • Keep the ledger information for the current month

This decision determines how old the information in a ledger report can be and the accuracy of the final billed and received amounts. For more information, see your finance manager or system administrator.

Print Average Collection Period Select this check box to include the average collection period at the end of the report. The average collection period is the average number of days between when you issue an invoice and when you receive payment in full. This value reflects only the paid invoices included in the report.
Print Retainer's Balance Select this check box to display retainer balances. This option is only available if Enable Retainers is selected on the General tab of the Accounting System Settings form.
Only include invoices posted through ____

Select this check box to restrict the report to invoices dated in or before a specified accounting period. Select that period in the field next to the check box label. The report displays all receipts for the invoices, regardless of receipt date. For example, you generate the report for invoices posted as of 09/2018. If you received payments for those invoices in 10/2018 and 11/2018, the report displays those receipts also.

Use this option to get an accurate picture of your accounts receivable for invoices generated before a specific date.

Exclude if paid prior to ____ Select this check box to exclude invoices that were paid in full in or before a specified accounting period. Select the period in the field next to the check box label. Select All Periods rather than an accounting period if you want to exclude all invoices marked as fully paid, regardless of the accounting period in which the payment occurred.
Interest Column Select the user-defined column in which to display interest amounts. Select No Interest if you do not want to include interest amounts on the report. You specify the headings for the user-defined columns on the Ledger Headings tab of the Accounts Receivable Configuration form. You map invoice accounts and accounts receivable accounts on the Invoice Mapping Accounts tab and the AR Mapping Accounts tab of the same form.
Report at If you use multiple currencies, select the type of currency in which to display monetary amounts.