PRINT ACCOUNTS RECEIVABLE HISTORY REPORT

Use this screen to create reports that contain invoice and cash receipt activity based on selection criteria that you specify. Outstanding invoices and selected cash receipts can be displayed by any of the following means: customer account, project, customer type, project type, account, organization, customer name, and project manager.

You will normally use this screen after posting all of the cash receipts and billings for an accounting period. It does not show invoices or cash receipts that have not been posted.

If you are using multi-currency and opt to print the report showing functional currency detail, this report will include any realized and unrealized gains/losses in the functional currency amounts. The realized gains and losses will be included in the Receipt Amount and the unrealized gains/losses will be included in a new Unrealized Gain/Loss line on the report.

Select Grouping

Select By

Use this drop-down list to select the grouping by which you want the report sorted. Options are Customer Account, Project, Customer Type, Project Type, Account, Organization, Customer Name, and Project Manager.

Range Option

Enter, or use the drop-down list 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.

From

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

To

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

Include

Account Level      and below

This field is available only if you select Account or Organization in the Select By drop-down list. Enter the account 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. To see all levels of detail, enter zero. To view the number of levels available, see the Account Structure group box in the G/L Settings screen in Costpoint General Ledger.

Organizational Level      and below

This field is available only if you select Account or Organization in the Select By drop-down list. 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. To see all levels of detail, enter zero. To view the number of levels available, see the Account Structure group box in the G/L Settings screen in Costpoint General Ledger.

Project Level      and below

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

Page Break

Select this check box to insert a page break after each group.

Progress Payment Bills

Select this check box to include progress payments on the report. By selecting this check box and also selecting the same report criteria, you will be able to compare this report to the Print Accounts Receivable Aging Report.

Finance Charge Activity

Show Finance Charges

Select this check box to include finance charges on the report.

Sort By

Use this drop-down list to select how you wish to sort finance charges. Valid options are: Project, Account, and Organization.

Select Period

Range Option

Select the range to include on this report. Options are All, One, Range, From Beginning, and To End. The default for this field is All.

From Fiscal Year

Enter the fiscal year to be included in the report or select a fiscal year from the drop-down list. If you select All or From Beginning in the Range Option field, this field will be unavailable.

From Period

Enter the period to be included in the report or select a period from the drop-down list. If you select All or From Beginning in the Range Option field, this field will be unavailable.

From Subperiod

Enter the subperiod to be included in the report or select a subperiod from the drop-down list. If you select All or From Beginning in the Range Option field, this field will be unavailable.

End Date

This non-editable field displays the subperiod ending date.

To Fiscal Year

Enter, or use the drop-down list to select, the correct fiscal year for this report.

To Period

Enter, or use the drop-down list to select the correct fiscal period for this report.

To Subperiod

Enter, or use the drop-down list to select the correct fiscal subperiod for this report.

End Date

This field displays the subperiod ending date and is not editable.

Select Invoice Number

Select By

Make a selection in this drop-down list. Choices are Invoice Number or None.

Range Option

Use the drop-down list to select the range of invoice numbers to include on this report. Options are All, One, Range, From Beginning, and To End. The default for this field is All.

From

Enter the first invoice number to be included in the report. If you select All or From Beginning in the Range Option field, this field will be unavailable.

To

Enter the last invoice number to be included in the report. If you select All, One, or To End in the Range Option field, this field will be unavailable.

Select Cash Receipt

Select By

Make a section from the drop-down list. Choices are Receipt Number or None.

Range Option

Use the drop-down list to select the range of cash receipts to include on this report. Options are All, One, Range, From Beginning, and To End. The default for this field is All.

From

Enter the first cash receipt number to be included in the report. If you select All or From Beginning in the Range Option field, this field will be unavailable.

To

Enter the last cash receipt number to be included in the report. If you select All, One, or To End in the Range Option field, this field will be unavailable.

Select Print Options

This group box is enabled only if you are licensed for Costpoint Multicurrency.

Currency

Enter, or use to select, a valid currency code. The default is USD.

Show Functional Currency detail

This check box is unavailable if the billing currency is the U.S. dollar (the default). Select this check box to see the Accounts Receivable History Report in your company's functional currency and in the billing currency. This box must be checked if you want the report to include any realized and unrealized gains/losses. The realized gains and losses will be included in the Receipt Amount and the unrealized gains/losses will be included in a new Unrealized Gain/Loss line on the report.

The Total/Unrealized Gain/Loss amount added to the Invoice Amount total equals the Receipt Amount total.

Realized gains and losses are part and parcel of customer payments. They arise from variances in the currency exchange rates that are used to calculate the translation from transaction to functional currency for Accounts Receivable.

Table Information

This screen accesses the following tables: