Contents of the AR Options Dialog Box

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.

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.

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.

Contents

Index

Glossary

Search Results