AR Aged Options Tab

The Options tab gives you additional control over the data displayed on the AR Aged report.

For example, you can use these options to exclude unassigned receipts from the report or to include only those invoices that are more than 60 days old.

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 AR Comments	Select this check box to display comments that were entered for the invoices in Invoice Review or Project Review. In Start Date and End Date, specify the date range for the comments you want to see. To include comments, you must also sort and group the report by Primary Client Number, Project Number, or both. If the invoice has no project associated with it, the comment prints under the client group header. If the invoice has a project, the comment prints under the project group header. The Accounts Receivable Comment Review Access option on the Accounting tab of the Roles form (Settings > Security > Roles) controls whether or not you can view invoice comments.
Start Date	Specify the start date of the date range for which you want to include comments.
End Date	Specify the end date of the date range for which you want to include comments.
Print Invoice Detail	Select this check box to display the invoice number, date, and amount of each invoice.
Print Last Receipt By Project	Select this check box to display the most recent receipt for each project.
Print Final Average Age	Select this check box if you want the final totals section to display the average of the number of days between the date selected in Age Using and the date selected in Aging Date on the General tab for all receivables included on the report.
Print Final Receipt Date	Select this check box if you want the final totals section to display the most recent receipt date for all receivables included on the report.
Print all Invoices with Retainage	Select this check box to display all invoices with retainage amounts. This option is only available if you select Enable Retainage on the General tab of the Accounting System Settings form (Settings > Advanced Accounting > System).
Only include invoices over _____ days old	Select this check box to restrict the report to invoices over a specified number of days old. Enter that number of days in the field next to the check box label. Use this option to focus the report on your older unpaid invoices.
Only include invoices through _____	Select this check box to restrict the report to invoices dated in or before a specified 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.
Clients with balances over _____	Select this check box to include only those clients with an outstanding balance equal to or greater than the amount that you specify. DPS determines the total outstanding balance for all of a client's projects. DPS then compares that total outstanding balance to the amount you enter in this field. If the outstanding balance is greater than or equal to the amount you specify, that client is included on the report. If you use this option, do the following: Use the Client Info to Display options on this tab to print some level of client detail. Sort the report by client name or client number.
Invoices with balances over _____	Select this check box to include only those invoices with an outstanding balance equal to or greater than the amount you specify. For example, if you select this check box and enter 1000 as the minimum amount, the report only includes those invoices with balances of $1,000.00 or more.
Drill Down Interest Column	Select the column in the AR Aging Amount Drill Down report in which you want DPS to include interest amounts. For example, if you select Interest and you drill down on an outstanding balance in the AR Aged report that includes interest, DPS displays the interest amount in the Interest column of the AR Aging Amount Drill Down report.
Report at	If you use multiple currencies, select the type of currency in which to display monetary amounts. Options are: Project Currency Billing Currency Project's Functional Currency Presentation Currency If you select Presentation Currency in this field: Two additional fields, Presentation Currency and Exchange Rate as of, display below the Report at field and require an entry. Amounts on the AR Aged report will not have hyperlinks that allow you to drill down to more detailed information. The footer of the AR Aged report identifies the presentation currency in which the report is run.
Presentation Currency	If you selected Presentation Currency in the Report at field, use this field to select the currency in which you want the report to display all monetary amounts. The drop-down list includes all currencies that are enabled for use by your enterprise (in Settings > General > Company Settings). When you run the report, any accounts receivable amount with a billing currency that is not the same currency as the presentation currency will be converted to the presentation currency. The date that you specify in the Exchange Rate as of field determines the exchange rates to use to calculate the presentation amounts.
Exchange Rate as of	If you selected Presentation Currency in the Report at field, use this field to specify the date that will determine the exchange rates to use for calculating the presentation currency amounts from billing currency amounts. The daily exchange rate (in Settings > General > Daily Exchange Rates) with a date that is on or before (and closest to) the date that you enter in the Exchange Rate as of field is used to calculate the presentation currency. When you run the AR Aged report, if no exchange rate is found with a date on or before (and closest to) the date that you entered in the Exchange Rate as of field, a message displays in the footer of the report to indicate that no exchange rate was found. Invoice amounts are left blank on the report.
Age Interest	Select this check box if you want the amounts in the aging columns to include any unpaid interest on past due amounts.
Exclude Unassigned Receipts	An unassigned receipt is a cash receipt posted to an invoice for which there is no record in DPS. Select this check box to exclude such receipts from the report.
Age Unassigned Receipts	An unassigned receipt is a cash receipt posted to an invoice for which there is no record in DPS. Select this check box if you want DPS to include unassigned receipts in the calculation of amounts in the aging columns. DPS reduces the outstanding balance by the amount of the unassigned receipt. The column affected depends on the date of the receipt.
Print Retainer's Balance	Select this check box to show retainer amounts. This option is available only if Enable Retainers is selected on the General tab of the Accounting System Settings form.
Print Pre-Invoices	This check box only displays if you select the Enable Pre-Invoices option on the Miscellaneous tab of the Billing Setup form (Settings > Billing > General). Select this check box 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. Because pre-invoices have no due date, the Aging Date option (Current Date, Period End Date, or Specific Date) that you select on the General tab of the AR Aged Options dialog box is compared to a pre-invoice's invoice date, regardless of whether you select the Invoice Date or Due Date Age Using option. Pre-invoices are included on the AR Aged report based on whether or not the date of the pre-invoice is within the time frame that you select on the General tab. Pre-invoices are included in the report for each of the following options that you select on the General tab of the AR Aged Options dialog box: Print Last Receipt by Project Print Final Average Aged Print Final Receipt Date Only include invoices over <days old> Only include invoices through <period> Clients with balances over <x amount> Invoices with balances over <x amount> When you sort and group the AR Aged report by invoice, the pre-invoice number displays in the Invoice column of the report. The drill-down hyperlinks for pre-invoices are disabled in the report. If you use multiple currencies: The Report at field on the AR Aged Option tab changes automatically to Billing Currency. You can only run the report with the billing currency when pre-invoices are included on the report.