A/R Aging Report

Yes; you can print the AR Aging Report in different currencies based on the currency you selected in the Selection Ranges block of this screen.  

If necessary, you can also revalue your functional currency for this report. To do this, select the Revalue Currency checkbox and enter the exchange rate to be to revalue the functional currency due in this report.

You can also print the AR History Report to display only receivables for a specified billing currency.

This occurs when the workstation sends too much data at one time to the printer.  To solve the problem, check the properties of your printer to see if spooling is enabled. If it is, disable it, and make the workstation print directly to the printer.

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections.  Once the default selections display in the screen, you can override the defaults as necessary.

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

Use this drop-down box to select the grouping by which you want the report sorted.  Options are "Customer Account," "Project," "Customer Type," "Project Type," "Account," "Organization,"  "Customer Name," "Project Manager," "AR UDF Label 1," and "AR UDF Label 2."

Enter, or use the drop-down box to select, the range of information you want to see on the report.  Options are "All," "One," "Range," "From Beginning," and "To End."  The default for this field is "All."

Enter, or use Lookup to select, the starting value for the range you want to include.  If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter, or use Lookup to select, the ending value for the range you want to include.  If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Select this checkbox to specify non-contiguous ranges within the range you have selected.

Select this checkbox to insert a page break after each group on the report.

Use this drop-down box to select the grouping by which you want the report sorted.  Options are "Customer Account," "Project," "Customer Type," "Project Type," "Account," "Organization," "Customer Name," "Project Manager," "AR UDF Label 1," and "AR UDF Label 2."

Enter, or use the drop-down box to select, the range of information you want to see on the report.  Options are "All," "One," "Range," "From Beginning," and "To End."  The default for this field is "All."

Enter, or use Lookup to select, the starting value for the range you want to include.  If you select "All" or "From Beginning" in the Option field, this field will be unavailable.

Enter, or use Lookup to select, the ending value for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.

Select this checkbox to specify non-contiguous ranges within the range you have selected.

Select this checkbox to insert a page break after each group.

This non-editable field displays the accounting period.

Enter, or use Lookup to select, the correct fiscal year for this report.

Enter, or use Lookup to select, the period for which you are running the report.

Enter, or use Lookup to select, the subperiod for which you are running the report.

This non-editable field displays the subperiod ending date you have selected.

Enter, or use the drop-down box to select, the range of currencies you want to appear on the report.  Options are "All," "One," "Range," "From Beginning," and "To End."  The default for this field is "All."

Enter, or use Lookup to select, the starting value for the range you want to include.  If you select "All" or "From Beginning" in the Range field, this field will be unavailable.

Enter, or use Lookup to select, the ending value for the range you want to include.  If you select "All," "One," or "To End" in the Range field, this field will be unavailable.

This field is available only if you select "Account" in the Select By drop-down box in the Selection Ranges block.

Enter the account level at which you want to print the report; all lower levels will be rolled up for the report. The larger the level number, the more detailed the report; the smaller the number, the less detailed.

Enter zero to include all levels of detail.

To view the number of levels available, see the Account Structure group box in the Corporate G/L Settings subtask of the G/L Settings screen.

This field is available only if you select "Organization" in the Select By drop-down box. Enter the organization level at which you want the report printed; all lower levels will be rolled up for the report.

The larger the level number, the more detailed the report; the smaller the number, the less detailed. Enter zero to include all levels of detail.

This field is available only if you select "Project" in the Select By drop-down box.  Enter the project level at which you want the report printed; all lower levels will be rolled up for the report.  Enter zero to include all levels of detail.

Use this drop-down box to age the receivables either by invoice date or by due date.

Use the Calendar Lookup, or enter the date from which you want to age your receivables.

Select this checkbox to revalue your functional currency totals by the rate that you enter in the adjoining Exchange Rate field.

Note: Selecting this checkbox will cause the Currency Range value to default to "One."

Enter the rate you wish to use for the revaluation of the functional balance totals.  This field will be available only if you select the Revalue Currency checkbox.

Select this radio button to print a detailed report in all currencies, including your company's functional currency.  This radio button is selected by default.

Select this radio button to print two reports - one by transaction currency and the other by functional currency.

Select this checkbox to specify that currency is the primary sort.

Select this checkbox to display receivables by invoice or bill number.

If you do not select this checkbox, the report will summarize 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.

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

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 AP totals back to the accounts payable balance sheet account.

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

The selections in this drop-down box will be unavailable unless you select the Detail checkbox in the Include group box. The choices are:

Invoice Number:  The invoice number is a unique system-generated identification number assigned to each bill. Make this selection to display A/R detail by invoice number.

Bill Number: Make this selection to display A/R detail by bill number.  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.

Select this checkbox to print notes on the report.

Select this checkbox to show receivable balances in thousands.

If you do not select this checkbox, outstanding receivables will print 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.

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 past due, an appropriate column heading may be "Current." Because this column contains receivables less than five days past due, the days included in this column would be from zero to five. Therefore you would enter the number "05" in the Days To field.

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.