Use this screen to print a list of all the checks that have been recorded in the system. This will include checks that were printed in the system and those that were recorded as manual checks.
You can record checks that were issued manually by entering the check information in the Record Manual Checks screen (Accounting\Transactions\Checks) or the Check tab of the Enter A/P Vouchers screen (Accounting\Transactions\Vouchers).
You can also view checks on this report prior to posting them to the General Ledger.
This screen consists of three 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 range of cash accounts, cash organizations, pay currencies, the periods, and checks that will appear on the register.
Use the Options block to specify if you wish to have zero balance checks appear on the register.
|
|
Note: If you have changed a vendor's name in the Vendor User Flow screen (Accounting\Maintain\Vendors), remember that the Check Register screen uses the name the vendor had when the check was issued. Also, the Check Register screen displays the address code used when the check was issued, which may not necessarily be the current address code for the vendor. |
You will generally run this screen at the end of an accounting period to obtain an audit trail for the checks issued or recorded in the accounting period. This report can also help you reconcile the bank statement, which is typically done on a monthly basis.
|
|
Note: You can apply org security to this function.
|
Unposted checks will print on the check register. Once a check is printed in the system, you will be prompted to update the history tables with the check information. Since this report gets its information from the history tables rather than from the General Ledger, checks are available on this report prior to posting them to the General Ledger.
If you enter a manual check in the Check tab of either the Enter AP Vouchers (Accounting\Transactions\Vouchers) or Enter PO Vouchers screen (Accounting\Transactions\Vouchers), the manual check will appear on this report once you have posted the voucher.
If you record manual checks in the Enter Manual Checks screen, the manual check will appear on this report once you have saved the record.
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.
Cash Account *
Use these fields to specify a range of cash accounts for which to print the report.
The accounts you enter here should be valid cash accounts, which are entered in the Cash Accounts screen (Accounting\Maintain\Accounts). The cash account and cash organization you specify should be linked in the Cash Accounts screen (Accounting\Maintain\Accounts) to be a valid combination in this screen. Although no validation is done in this screen, if you do not select a valid Cash Account/Cash Organization, the report will not return any results.
Use this drop-down box to select the range of cash accounts to be included.
Valid 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 cash account for the range you want to include.
If you select "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
The only accounts available for Lookup will be the accounts entered in the Cash Accounts screen (Accounting\Maintain\Accounts).
Enter, or use Lookup to select, the ending cash account for the range you want to include.
If you select "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
The only accounts available for Lookup will be the accounts entered in the Cash Accounts screen (Accounting\Maintain\Accounts).
Cash Organization *
Use these fields in conjunction with the Cash Account fields to select a valid cash account organization combination for which to print a check register. In order to be a valid combination, you must link the accounts/organizations together in the Cash Accounts screen (Accounting\Maintain\Accounts). Although no validation is done in this screen, if you do not select a valid Cash Account/Cash Organization, the report will not return any results.
Use this drop-down box to select the range of cash organizations to be included.
Valid 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 cash organization for the range you want to include.
If you select "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
The only accounts available for Lookup will be the accounts entered in the Cash Accounts screen (Accounting\Maintain\Accounts).
Enter, or use Lookup to select, the ending cash organization for the range you want to include.
If you select "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
The only accounts available for Lookup will be the accounts entered in the Cash Accounts screen (Accounting\Maintain\Accounts).
Pay Currency *
Use this drop-down box to select the range of pay currencies that you want included in 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 currency code that is the beginning of the range you want to include in the report.
If you select "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
Only those currencies you saved in the Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.
Enter, or use Lookup to select, the currency code that is the ending of the range you want to include in the report.
If you select "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
Only those currencies you saved in the Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.
Period *
Use these fields to specify the period by which the report should be printed.
Any checks issued into the period specified in these fields will display on the report, for those Cash Account/Organization combinations you specified in the Cash Account and Cash Organization fields.
This report does NOT look at a check date to determine a check's inclusion in this report, but instead looks at the period in which the checks will be or have been posted as set in the Print/Void AP Checks screen (Accounting\Process\Pay).
Use this drop-down box to select the range of periods that you want included on the report.
If you want to run the report for one period, you must select "Range," then specify the first subperiod for the starting subperiod, and the last subperiod for the ending subperiod within the desired subperiod.
If you want to print the report for one subperiod, select the "One" range option and fill in the Start Subpd field with the subperiod number.
Use Lookup to select the fiscal year for which you want the report printed.
You can print a check register for multiple fiscal years.
Use Lookup to select the starting period for the Check Register report.
If you selected "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
Use Lookup to select the starting subperiod for the Check Register report.
If you selected "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
Use Lookup to select the ending fiscal year for the Check Register report.
If you selected "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
Use Lookup to select the ending period for the Check Register report.
If you selected "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
Use Lookup to select the ending subperiod for the Check Register report.
If you selected "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
Checks *
The Option in this drop-down box defaults to "All." However, if you want to print a check register that includes only a certain range of check numbers recorded for the cash account/organization and period you have specified in the other group boxes, enter a range here. The Lookup will include all checks and will not be limited by the cash account/cash organization, period, or pay currency selected. However, only checks within the selected criteria will print on the report.
If you want to see all the checks for the selected cash account/organization and period, leave the Option field set to "All."
Use this drop-down box to select the range of check numbers for your Check Register 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 check number for the range you want to include.
If you select "All" or "From Beginning" in the Option drop-down box, this field will be inactive.
Enter, or use Lookup to select, the ending check number for the range you want to include.
If you select "All," "One," or "To End" in the Option drop-down box, this field will be inactive.
This option will default as unchecked.
If you select this option, it will include all zero balance checks that were issued in the system. Zero balance checks are cut in the Print/Void AP Checks screen (Accounting\Process\Pay) when all selected vouchers for a vendor sum to zero. Zero balance checks will not print but will use a check number from the Zero Balance Check Start and Zero Balance Check End range specified in Company Bank Accounts Detail Information.
* A red asterisk denotes a required field.
This screen accesses the VEND_CHK (Vendor Check) table.
