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.
The Cash Receipts Register screen consists of four blocks that can be used as follows:
Use the Identification block to enter a parameter ID and description.
Use the Selection Ranges block to specify the selection ranges for the following: Period, Selection, Option ("Account," "Organization," "Receipt," "Receipt Date") and Pay Currency.
Use the Options block to include posted or unposted cash receipts, select receipt detail, and tailor the appearance of your report.
Use the Sort By block to specify how you want to sort your report.
Print this report at any time after entering and saving 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.
|
|
Note: Org security can be applied to this function. This optional feature allows you to grant or remove rights to view specific organizations to users. |
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously-saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
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.
When you save your record, all the selections you 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.
This field is only required if you attempt to save this screen or if you have entered a value in the Parameter ID field.
Period *
Enter, or use the drop-down box to select, the range of periods 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/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.
This report will include 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 will be included on the report regardless of the receipt date.
Options are "All," "One," "Range," "Beginning From," and "To End."
The default for this field is "All."
Enter, or use Lookup to select, the starting fiscal year for the cash receipts to be included on the report.
If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter the starting period to be included in the report or use Lookup to select a period.
If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Enter the starting subperiod to be included in the report or use Lookup to select a subperiod.
If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
This non-editable field displays the ending date (including month, day, and year) of the selected subperiod.
Enter, or use Lookup to select, the ending fiscal year for the cash receipts to be included on the posting report.
You can print this report across multiple fiscal years and have the ending fiscal year be a different fiscal year than the starting fiscal year.
Enter, or use the drop-down box to select, the fiscal year for the cash receipts to be included on the posting report.
Enter the ending period to be included in the report or use Lookup to select a period.
If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Enter, or use the drop-down box to select, the fiscal year for the cash receipts to be included on the posting report.
Enter the ending subperiod to be included in the report or use Lookup to select a subperiod.
If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
This non-editable field displays the ending date (including month, day, and year) of the selected subperiod.
(Select Grouping)
Use this drop-down box to limit your report to cash receipts based on specific criteria.
You can select "Account," "Organization," "Receipt," or "Receipt Date."
By selecting account or organization, you can limit your report to cash receipt lines entered for the selected account or organization.
By selecting receipt or receipt date, you can limit your report to specific cash receipt numbers and dates.
If you decide to limit by receipt date, the starting and ending fields will have calendar Lookup to assist you in choosing dates.
The default setting is "Account."
Use this drop-down box to select the range for the grouping you want to print. Options are "All," "One," "Range," "Beginning From," 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.
Pay Currency *
Use this drop-down box to select the range of pay currency to be included.
When cash receipts are entered, the functional currency of the currency (established in the G/L Settings screen) defaults into the screen. Only cash receipts with the selected pay currency will appear on the report.
Valid options are "All," "One," "Range," "From Beginning," and "To End."
Enter, or use Lookup to select, the starting pay currency code for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be unavailable.
Only those currencies saved in the Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.
Enter, or use Lookup to select, the ending pay currency code for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be unavailable.
Only those currencies saved in the Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.
|
|
You can only select one posting when printing the report. If you need to include both posted and unposted cash receipts, you will need to print the report several times. |
If you print this report to include posted receipts, the report pulls data from the CASH_RECPT_HDR_HS (Cash Receipt Header History) and the CASH_RECPT_TR_HS (Cash Receipt Transaction History) tables.
If you print this report to include open cash receipts, the report pulls the data from the CASH_RECPT_HDR (Cash Receipt Header) and CASH_RECPT_TRN (Cash Receipt Transaction) tables.
Select this checkbox to show detail by transaction. If this checkbox is not selected, the report will summarize data by account, organization, and fiscal year.
Select this checkbox to print amounts summarized by thousands. If report amounts are less than 500, and this checkbox is selected, the amount will display as zero.
1st Sort *
Use this drop-down box to specify whether you want to sort by account, organization, receipt, or receipt date.
If you sort by account, the receipts will be ordered by fiscal year/period/subperiod, by account, and then by organization.
If you sort by organization, the receipts will be ordered by fiscal year/period/subperiod, by organization, and then by account.
If you sort by receipt, the receipts will be ordered by fiscal year/period/subperiod, by receipt number, and then by receipt date.
If you sort by receipt date, the receipts will be ordered by fiscal year/period/subperiod, by receipt date, and then by receipt number.
Select this checkbox to insert a page break after each primary sort item.
* A red asterisk denotes a required field.
This screen accesses the CASH_RECPT_HDR_HS (Cash Receipt Header History) and the CASH_RECPT_TR_HS (Cash Receipt Transaction History) tables for posted cash receipts.
This screen accesses the CASH_RECPT_HDR (Cash Receipt Header) and CASH_RECPT_TRN (Cash Receipt Transaction) tables for unposted cash receipts.
