PRINT CASH RECEIPTS REGISTER REPORT
Use this screen to print the Cash Receipts Register, which provides a listing of cash receipts. You can run this report for open cash receipts or receipts posted to the General Ledger.
Print this report at any time after you enter and save cash receipts. It should be printed and retained for all cash receipts. It is a significant audit trail document and should be printed as part of the month-end closing reports.
Org security can be applied to this function. This optional feature allows you to grant or remove rights to view and/or update specific organizations to users. In order to do so, you must first set up the necessary org security screens in Costpoint System Administration. You can then activate org security through the use of the Manage Users and Configure System Settings screens in that module. For more information about org security and how to apply it, see the Costpoint Organizational Security module.
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
Period
Option
From the drop-down list, select the range of periods that you want to include in the report. You can enter a range of periods that cross fiscal years.
When you enter cash receipts, you enter a fiscal year/period/subperiod in the header of the record. The fiscal year/period/subperiod entered will determine the year/period/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/subperiods selected. All cash receipts entered or posted within the range of the fiscal year/period/subperiod selected 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 the starting period to include in the report, or click to select a period. If you select All or From Beginning in the Period Option field, the Start Period field is unavailable.
Subpd (Start)
Enter the starting subperiod to include in the report, or click to select a period. 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 to 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 the ending period to include in the report, or click to select a period. If you select All One, or To End in the Period Option field, the Period (End) field is unavailable.
Subpd (End)
Enter the ending subperiod to include in the report, or click to select a subperiod. 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 Subpd (End) field.
(Select Grouping)
Use this row to create a report by selected Accounts Receivable items.
(Select By)
From the drop-down list, choose the criteria by which to limit the cash receipts on the report.
The options are:
-
Account (default)
-
Organization
-
Receipt
-
Receipt Date
Option
From the drop-down list, select the range for the grouping that you want to print.
For example, if you select Account in the first field, select the range of accounts to be included on the report.
The options are:
-
All — Select this option to include all available items for (Select By) option that you selected. The Start and End fields are disabled for this option.
-
One — Select this option to include only one item for the (Select By) option that you selected. You must make an entry in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of items for the (Select By) option that you selected. In the Start field, enter the beginning item for the range. Enter the ending item of the range in the End field.
-
From Beginning — Select this option to include all the items for the (Select By) option that begin with the first item of all the available items and end with the specific item that you enter in the End field. Start field is disabled for this option.
-
To End — Select this option to include all the (Select By) items that begin with the specific item that you enter in the Start and end with the last item in the list of all items. The End field is disabled for this option.
Start
Enter, or click to select, the starting value 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, or click to select, the ending value 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.
Pay Currency
Use this row to specify a range of pay currency codes to further limit the cash receipts to include in the selection routine. If you do not want to further restrict the selection process, leave the Option set to All.
Option
From the drop-down list, select the range of pay currencies to include on the report. The pay currency is the currency in which the cash receipt was recorded.
The options are:
-
All — Select this option to include all pay currencies on the report. The Start and End fields are disabled for this option.
-
One — Select this option to include only one pay currency on the report. Enter the currency in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of pay currencies on the report. Enter the beginning pay currency in the Start field. Enter the ending pay currency in the End field.
-
From Beginning — Select this option to include a range that starts from the beginning of all the available pay currencies and ends with the pay currency 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 pay currency that you enter in the Start field and ends with the last pay currency of all the available pay currencies. The End field is disabled for this option.
Start
Enter, or click to select, the starting pay currency code for the range to include in the report. When you select All or From Beginning in the Option field, this field is unavailable. Only those currencies that are saved on the Manage Currencies screen in Costpoint Multicurrency are available in .
End
Enter, or click to select, the ending pay currency code for the range to include in the report. If you select All, One, or To End in the Option field, the End field is unavailable. Only those currencies that are saved on the Manage Currencies screen in Costpoint Multicurrency are available in .
Options
Select Posting Status
Posted and Unposted
Select whether you want to print this report for Posted or Unposted cash receipts by choosing the appropriate option.
If you print this report for posted receipts, the report pulls data from the AR_HDR_HS and AR_DETL_HS tables.
If you print this report for unposted (open) cash receipts, the report pulls the data from the CASH_RECPT_HDR and CASH_RECPT_TRN tables.
You can only select one posting when you print the report. If you need to include both posted and unposted cash receipts, you must print the report several times.
Show
Receipt Detail
Select this check box to show detail by transaction. If this check box is cleared, the report summarizes data by receipt.
Amounts In Thousands
Select this check box to print amounts summarized by thousands.
Sort By
1st Sort
From the drop-down list, select whether you want to sort by one of the following:
-
Account
-
Organization
-
Receipt
-
Receipt Date
Page Break
Select this check box to insert a page break after each primary sort item.
The report parameters specified can be optionally saved for future use. To save the selected report parameters, click 
on the toolbar after you have entered your report selections. Enter an appropriate ID and description for the report, and click OK to save. Stored report parameters are especially useful if reports are to be run through Process Manager.