AR Statement Options Tab

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

Contents

Field Description
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.
Only Include Past Due Invoices Select this check box to display only invoices with a past due amount as of the statement date. The due date for invoices that are not assigned a due date based on billing terms is determined based on the invoice date and the number of days in Grace Period for Invoices Without a Due Date on the General tab.
Print Statement Summary Select this check box to include a summary (current amount, past due amount, and balance due amount) on the right side of the AR Statement.
Print Average Days Outstanding Select this check box to display the average number of days that payment is outstanding for the invoices included on the statement.
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 statements reflect all receipts for the invoices, regardless of receipt date. For example, you generate statements for invoices posted as of 09/2018. If you received full payment for some of those invoices in 10/2018, they would not appear on the statement as outstanding.
Print Footer Select this check box to include the text that you enter in Statement Footer (see below). DPS displays the footer text at the bottom of each page of the statements.
Report in If you use multiple currencies, select the type of currency in which to display monetary amounts.
Statement Footer

To display footer text at the bottom of each statement page, select Print Footer, and enter the text in this field.

Example footer text:

Invoices are due when rendered. Late payments are subject to a late charge.

Aging

Field Description
Print Aging Summary Select this check box to include a breakdown of the balance due into aging categories.
Age Using

Select the date from which you want to age invoice amounts. These options are only available if you select the Print Aging Summary check box.

  • Invoice Date: Calculate the age of invoice amounts as the difference between the invoice transaction date and the date you select in Statement Date on the General tab.
  • Due Date: Calculate the age of invoice amounts as the difference between the invoice due date and the date you select in Statement Date on the General tab. (The due date for invoices that are not assigned a due date based on billing terms is determined based on the invoice date and the number of days in Grace Period for Invoices Without a Due Date on the General tab.)
Aging categories Specify the age ranges (in days) for each aging category. You can change the default aging categories. For example, you can change Current from 30 to 60 if you consider invoices 60 days old or less as current.