PRINT ACCOUNTS RECEIVABLE HISTORY REPORT
Use the Print Accounts Receivable History Report screen to create reports that contain invoice and cash receipt activity based on the 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 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 use multi-currency and opt to print the report showing functional currency detail, the A/R History report includes any realized and unrealized gains/losses in the functional currency amounts. The realized gains and losses are included in the Receipt Amount, and the unrealized gains/losses are included in a new Unrealized Gain/Loss line on the report.
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. 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 run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
(Select By)
From the drop-down list, select the grouping by which you want to sort the report. The options are:
-
Customer Account
-
Project — When you select this option, enter the project level in the Project Level field in the Include group box in the Options block on this screen.
-
Customer Type
-
Project Type
-
Account — When you select this option, enter the account level in the Account Level field and the organization level in the Organization Level field in the Include group box in the Options block on this screen.
-
Organization — When you select this option, enter the account level in the Account Level field and the organization level in the Organization Level field in the Include group box in the Options block on this screen.
-
Customer Name
-
Project Manager
Option
From the drop-down list, select the range of items to include in this report. The options are:
-
All — Select this option to include all available items. The Start and End fields are disabled for this option.
-
One — Select this option to include only one item. Enter that item in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of items. Enter the beginning item for the range in the Start field and the ending item of the range in the End field.
-
From Beginning — Select this option to include a range of items that begins with the first of all the available items and ends with a specific item that you enter End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of items that begins with a specific item that you enter in the Start field and ends with the last of all the available items. The End field is disabled for this option.
Start
Enter the starting item for the range that you want to include in the report. If you select All or From Beginning in the Option field, the Start field is unavailable.
End
Enter the ending item for the range you want to include in the report. If you select All, One, or To End in the Option field, the End field is unavailable.
Period
Option
From the drop-down list, select the range of periods that you want to include on the report. You can enter a range of periods that cross fiscal years.
When you enter cash receipts, you enter a fiscal year, period, and subperiod for the cash receipt. These determine the year, period, and subperiod to which the cash receipt will be posted.
The Cash Receipts Register report includes cash receipts entered or posted (depending on the report selection) that are within the range of fiscal years, periods, and subperiods selected. All cash receipts entered or posted within the range of the fiscal year, period, and subperiods that you select are included on the report regardless of the receipt date.
The options are:
-
All — Select this option to include all periods on the report. The Start and End fields are disabled for this option.
-
One — Select this option to include only one period on the report. Enter the period in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of periods on the report. Enter the beginning period in the Start field, and enter the ending period in the End field.
-
From Beginning — Select this option to include a range that starts from the beginning of all available periods and ends with the period that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range that starts with the period that you enter in the Start field and ends with the last period of all the periods. The End field is disabled for this option.
Fiscal Year (Start)
Enter, or click 
to select, the starting fiscal year for the cash receipts to be included on the report.
Period (Start)
Enter, or click to select, the starting period to include in the report. If you select All or From Beginning in the Period Option field, the Start Period field is unavailable.
Subpd (Start)
Enter, or click to select, the starting subperiod to include in the report. If you select All or From Beginning in the Period Option field, the Start Subpd field is unavailable.
Ending Date (Start)
After you enter subperiod numbers, the ending dates (including the month, day, and year) of the selected subperiods display in the field on the right of the SubPd (Start) field.
Fiscal Year (End)
Enter, or click to select, the ending fiscal year for the cash receipts to be included on the report.
Period (End)
Enter, or click to select, the ending period to include in the report. If you select All, One, or To End in the Period Option field, the Period (End) field is unavailable.
Subpd (End)
Enter, or click to select, the ending subperiod to include in the report. If you select All, One, or To End in the Period Option field, this field is unavailable.
Ending Date (End)
After you enter subperiod numbers, the ending dates (including month day and year) of the selected subperiods display in the field on the right of the Subpd (End) field.
Select Invoice Number
(Select By)
From the drop-down list, select whether or not you want to include invoice detail and amounts on the report. The options are:
-
Invoice Number — Select this option if you want invoice detail and amounts to print on the report.
-
None — Select this option if you do not want invoice detail or invoice amounts to print on the report. The remaining fields in this row are disabled.
Option
If you selected Invoice Number in the (Select By) field, select the range of invoice numbers to include on the report from the drop-down list. The options are:
-
All — Select this option to include all invoice numbers. The Start and End fields are disabled for this option.
-
One — Select this option to include only one invoice number. Enter the invoice number in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of invoice numbers. In the Start field, enter the beginning invoice number. In the End field, enter the ending invoice number for the range.
-
From Beginning — Select this option to include a range that begins with the first invoice number of all the available invoice numbers and ends with a specific invoice number that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range that starts with a specific invoice number that you enter in the Start field and ends with the last invoice number of all the available invoice numbers. The End field is disabled for this option.
Start
Enter the first invoice number to include in the report. If you select All or From Beginning in the Option field, the Start field is unavailable.
End
Enter the last invoice number to include in the report. If you select All, One, or To End in the Option field, the End field is unavailable.
Select Cash Receipt
(Select By)
From the drop-down list, select whether or not you want to include cash receipt information on the report. The options are:
-
Receipt Number — Select this option if you want cash receipt information and amounts to print on the report.
-
None — Select this option if you do not want cash receipt information and amounts to print on the report. The remaining fields in this row are disabled.
Option
If you selected Receipt Number in the (Select By) field, select the range of cash receipt numbers to include on the report from the drop-down list. The options are:
-
All — Select this option to include all cash receipt numbers. The Start and End fields are disabled for this option.
-
One — Select this option to include only one cash receipt number. Enter the cash receipt number in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of cash receipt numbers. In the Start field, enter the beginning cash receipt number. In the End field, enter the ending cash receipt number for the range.
-
From Beginning — Select this option to include a range that begins with the first cash receipt number of all the available cash receipt numbers and ends with a specific cash receipt number that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range that starts with a specific cash receipt number that you enter in the Start field and ends with the last cash receipt number of all the available cash receipt numbers. The End field is disabled for this option.
Start
Enter, or click to select, the first cash receipt number to include in the report. If you select All or From Beginning in the Option field, the Start field is unavailable.
End
Enter, or click to select, the last cash receipt number to include in the report. If you select All, One, or To End in the Option field, the End field is unavailable.
Options
Include
Account Level __ and below
This field is available only if you select Account or Organization in the Selection Ranges (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 the report. To see all levels of detail, enter zero. To view the number of levels available, see the Account Structure group box on the Configure General Ledger Settings screen in Costpoint General Ledger.
The account level that you enter must not be higher than the level for the Accounts Receivable accounts that you want to include on the report. For example, if your billed A/R account is 01100-010, 01100-020, and 01200, and you enter account level 3 and below, you will not have any invoices or cash receipts posted against these A/R accounts.
If you enter account level 1 and below, you will have invoice details grouped by Accounts Receivable account 01100 and 01200.
If you select account level zero and below, you will see invoice and cash receipt detail grouped by each Accounts Receivable account.
Organizational Level __ and below
This field is available only if you select Account or Organization in the Selection Ranges (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 the report. To see all levels of detail, enter zero. To view the number of levels available, see the Account Structure group box on the Configure General Ledger Settings screen in Costpoint General Ledger.
The organization level that you enter must not be higher than the level of the organization to which your Accounts Receivable was posted. For example, if you want to include customer invoices from projects with owning orgs of 1.1.2.3, 1.1, and 1.2, you must select an org level of 2 or below to include all invoices and/or associated posted cash receipts.
If you choose to select an org level of 4 and below, the invoices and cash receipts posted to org 1.1 and 1.2 will be excluded.
Entering an org level of 2 or below will sum invoices and cash receipts by org 1.1 and 1.2.
Entering an org level of 0 and below, will group posted invoices and cash receipts by each Accounts Receivable organization.
Project Level __ and below
This field is available only if you select Project in the Selection Ranges (Select By) drop-down list.
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.
Exclude
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.
You may want to exclude your progress payment bills on this report if you have not selected the Progress Bills to GL When Billed check box in the 1443 Postings group box on the Configure Billing Settings screen. With this check box cleared, when you post a progress payment bill, the A/R and billing history tables are updated but nothing posts to the GL until the cash receipt paying the invoice is posted.
Finance Charge Activity
Show Finance Charges
Select this check box to include finance charges on the report.
Sort By
1st sort
This non-editable field displays the grouping that you chose in the (Select By) field in the Selection Ranges block.
Page Break
Select this check box to insert a page break after each group.
2nd sort
Use this drop-down list to select how you want to sort finance charges. The options are:
-
Project
-
Account
-
Organization
Select Print Options
This group box is enabled only if you are licensed for Costpoint Multicurrency.
Currency
Enter, or click 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 generate the Accounts Receivable History Report in your company's functional currency and in the billing currency. This check box must be selected if you want the report to include any realized and unrealized gains/losses. The realized gains and losses are included in the Receipt Amount. The unrealized gains/losses are 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.