AR Aged Options Tab
The Options tab of the AR Aged Options dialog box 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.
Contact names and phone numbers are only included on the AR Aged report if the contact is specified in billing terms. This is true even if you select Contact and Telephone in Client info to display on the Options tab of the Options dialog box for the AR Aged 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 Billing Client Number or Billing Client Name, the options have the following results:
If you sort and group by Client Number or Client Name, the options have the following results:
If you sort and group by Project Number or Project Name, the options have the following results:
If you sort and group by Billing Contact or Primary Contact, the options have the following results:
For example, if you selected Billing Client and then Project Number in your sorting/grouping, the contact information for all project’s contacts will show with the Client. If you select Billing Client, Project Number, and then Billing Contact, the contact information will show with each project. |
Print Client Notes | Select this check box to include the text entered in the
Notes field on the General tab of the Client Info Center. Vision displays the notes as the last line of the client information section. (This option is not available if you select
None in
Client info to display.)
Vision displays the complete text of the notes on the report. If you commonly want to include notes on this report, Deltek recommends that you try to limit the length of the notes you enter for clients. Otherwise, they 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 Client Info Center. |
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 ( ) 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. Enter the date, or click and select the date. |
End Date | Specify the end date of the date range for which you want to include comments. Enter the date, or click and select the date. |
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 Enable Retainage is selected on the General tab of the Accounting System Settings form ( ). |
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/2013. If you received payments for those invoices in 10/2013 and 11/2013, 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.
Vision determines the total outstanding balance for all of a client's projects. Vision 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:
|
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 Vision 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, Vision displays the interest amount in the Interest column of the AR Aging Amount Drill Down report. |
Report at | If you use the Multicurrency feature, select the type of currency in which you want Vision to display monetary amounts.
Options are:
For more information about currency types, see Currency Types. If you select Presentation Currency in this field:
|
Presentation Currency | This field displays if you selected
Presentation Currency in the
Report at field.
From the drop-down list in the Presentation Currency field, 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 ). 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 | This field displays if you selected
Presentation Currency in the
Report at field.
In the Exchange Rate as of field, 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 ) whose date 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. Enter the date directly in this field, or click and select the date. 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 Vision. 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 Vision. Select this check box if you want Vision to include unassigned receipts in the calculation of amounts in the aging columns. Vision 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 displays only if you have the Pre-Invoices feature enabled for a company on the Miscellaneous tab in
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:
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. |
.