REPORT OPTIONS

Use this subtask to specify the level of detail and range(s) you wish to appear on the Accounts Receivable Aging report.

Include

Progress Payment Bills

Select this checkbox to include all progress payment bills from your aging report. This checkbox is selected by default.

Detail

Select this checkbox to display receivables by invoice. If this checkbox is not selected, the report summarizes receivable balances in the appropriate columns by the group selected. For example, if you print this report by "Customer" and have not selected this checkbox, the report summarizes receivable balances by column. Therefore, the report shows a receivable balance in each column for each customer selected.

Show

The selections in this group box will be unavailable unless you select the Detail checkbox in the Include group box.

Invoice Number

Select this radio button to print the invoice number on the report. The invoice number is a unique system-generated identification number assigned to each bill.

Bill Number

Select this radio button to print the bill number on the report. The bill number is a second invoice identifier, separate from the system invoice number; it is normally used to track project-specific billing numbers required by a particular job.

Invoice Notes

Select this checkbox to print notes on the report.

Show Amts in Thousands

Select this checkbox to show receivable balances in thousands. If this checkbox is not selected, outstanding receivables are printed in actual amounts. If balances exceed the field size, you will see "####" instead of amounts. If this happens, you must print the report showing receivables in thousands.

Include Unrealized Gain/Loss

Select this checkbox to include unrealized gains/losses on the accounts receivable aging report.  You must first select the Detail checkbox in the Include groupbox before you can do this.

Selecting the Include Unrealized Gain/Loss checkbox will allow you to track the open AR totals back to the accounts receivable balance sheet account. You must also select Print Report for Functional Currency in the Currency subtask to show unrealized gains and losses on the report. If selected, the report will include indented rows where the unrealized gains/losses will display.

The Include Unrealized Gain/Loss checkbox is unselected by default.

Ranges for A/R Aging

These fields display the defaults initialized in the A/R Settings screen. They can be modified at the time the report is run. Accounts Receivable invoices are aged based on due date. You should take this into consideration when defining columns for this report.

For example, typically the first column is initialized as the column reflecting current Accounts Receivable. A standard date range for this column is often 0 to 30 days, since Accounts Receivables are aged based on due date or invoice date, depending on your selection. In this instance, the Current column contains all current invoices not yet due, and invoices 30 days past the due or invoice date. Alternatively, this column could be defined as "Current" receivables with a date range of zero to one day. In this instance, the Current column still reflects all Accounts Receivables not yet due and, as those receivables become past due, they shift to Past Due columns.

Headings 1-4

These fields display the defaults initialized in the A/R Settings screen. They can be modified at the time the report is run. To modify the column headings, enter the information and range in days that each column represents. For example, if you want the first column to contain receivables less than five days old  an appropriate column heading may be "Current." Because this column contains receivables less than five days old, the days included in this column would be from zero to five. Therefore you would enter the number "05" in the Days To field.

Days From and To

Once you have entered the headings for the ranges of days, use the Days To field to specify the upper limit of the day ranges. For example, if the range of days in the Headings 1-4 field is 31-60, the entry in the Days To field should be 60. The Days From field is calculated as the previous row's Days To entry plus one. All entries will be labeled as specified on the Accounts Receivable Aging report.

Include Ranges

By default, all four of these checkboxes are selected. Leave these checkboxes selected to include these columns on your report. If you do not want to include a heading in the Ranges for A/R Aging group box, make sure the appropriate checkbox is not selected. You must leave at least one of the checkboxes checked or you will not be able to print or save the report. If you choose not to include a heading in your report, a blank column prints in its space, and any lines containing all zeroes across the remaining columns will be suppressed. Final totals print only for those columns included in the report. Even if you choose not to print two columns (leaving only Headings 2 and 4, for example), the system will ensure the Days From and To fields are entered in consecutive order.