Contents of the AR Options Dialog Box

Use the fields and options to specify the aging date for invoices and to establish the aging columns.

Fields

Field Description
Display Using This field applies if you use multiple currencies. Select a project's billing currency or project currency to use for displaying aged accounts receivable.

Aging Date Section

Field Description
Today's Date Select this option to use today's date to age invoices.
Period End Date Select this option to use the last day of your enterprise's current accounting period to age invoices.
Specific Date Select this option to use a specific date to age invoices. Specify the date in the field beside this option.

Aging Grid

Use this grid to specify the number of days that make up aging columns for the Aged Accounts Receivables grid. Each column in the Aged Accounts Receivable grid shows the receivables that are a certain number of days old. Each row in the Aging grid on this dialog box represents an aging column in the Aged Accounts Receivables grid.

Aging Grid Toolbar

Field Description
Aging columns drop-down

Click the drop-down arrow on a grid header to complete any of the following actions:

  • To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer.
  • To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
  • To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.

Not all options are available on all grids.

Delete Select a row in the grid and then click this option to delete the row from the grid and remove the aging column from the Aged Accounts Receivables grid.

If you delete all of the rows and no active row displays, click OK on the dialog box to close it. Then reopen the dialog box to display an active row and begin entering the aging columns.

Aging Grid Columns

The rows in this grid define the aging columns in the Aged Accounts Receivable grid. For each aging column (row), you identify the range of days for the aging column in the first and third columns in the grid.

Field Description
First Column The first column displays the beginning number of days in the range of days that make up an aging column in the Aged Accounts Receivable grid. The beginning number of days prefills in the first column, based on what you enter in the previous row's number of days in the third column. The number of days in the third column of the previous row is then incremented by one.

The default entries in the first column for the first five rows are blank, 31, 61, 91, and 121 days, which you can change by making entries in the third column of the previous row.

The entry in the first row, which defines the first aging column in the Aged Accounts Receivable grid, is always blank.

Second Column Click in this field and from the drop-down list select one of the following operators that define the range of days you enter in the first and third columns:
  • >=Days<=: Select this option if you want the aging column to include invoices whose age is greater than or equal to the number of days that you entered in the first column and less than or equal to the number of days that you entered in the third column. You typically use this operator for all aging columns except the last column.
  • +: Select this option if you want the aging column to include invoices that are equal to and greater than the number of days that are entered in the first column in the Aging grid. You typically use this for the last aging column.
Third Column Enter the ending number of days for the range of days that make up the aging column in the Aged Accounts Receivable grid. The number that you enter in this column is used for calculating the number to prefill the first column of the next row. The first column of the next row prefills with the number in the third column, plus one.