Contents of the Print Cash Requirements Report Screen
Use the fields and options to configure the Print Cash Requirements Report screen.
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, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.
Field | Description |
---|---|
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 on the screen, such as PERIOD or QUARTERLY. When you save your record, all the selections made on 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 on the screen, you can override the defaults. |
Description |
Enter, or click to select, a parameter description of up to 30 alphanumeric characters. |
Selection Ranges
Field | Description |
---|---|
Requirements 'As of Date' |
This is the date on which the report assumes that you are printing your checks and EFTs. The default setting is the system date (today's date). You can specify another date but it cannot be earlier than today's date. The report includes the amount of cash needed to pay your company's Accounts Payable requirements as of this date. Costpoint uses this field in conjunction with the Voucher Date Cutoff selected to determine the vouchers that are included in this report. Any vouchers that are equal to or past the chosen voucher cutoff date print on the report. |
Voucher Date Cutoff |
Use this option to determine the reference point of your "As of Date."
|
Bank Account Abbreviation
Select the bank account abbreviations that you want to include in the report. You linked the vendor to a cash account description via the Manage Vendor screen. You can change this cash account description until the voucher is paid.
You linked the cash account descriptions to the bank account abbreviations on the Manage Cash Accounts screen.
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of bank account abbreviations to be included. Valid options are:
|
Start |
Enter, or click to select, the starting bank account abbreviation for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive. |
End |
Enter, or click to select, the ending bank account abbreviation for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive. |
(Select by)
From the drop-down list, select a setting by which to group data on the report. You define vendor groups on the Manage Vendors screen. Valid settings are:
- Pay Vendor
- Vendor Group
- Employee
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of pay vendors, vendor groups, or employees that you want included in the report. Valid options are:
|
Start |
Enter, or click to select, the starting record for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive. |
End |
Enter, or click to select, the ending record for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive. |
Transaction Currency
Use the fields in this group box to select the criteria for choosing the transaction currencies. Only those currencies established via the Manage Currencies screen are available from the lookups in these fields.
Field | Description |
---|---|
Option |
Use this drop-down list to select the range of transaction currencies to be included. Valid options are:
|
Start |
Enter, or click to select, the starting transaction currency for the range that you want to include. If you select All or From Beginning in the Option field, this field is inactive. |
End |
Enter, or click to select, the ending transaction currency for the range that you want to include. If you select All, One, or To End in the Option field, this field is inactive. |
Invoice Amount
Field | Description |
---|---|
Option |
Use this drop-down list to select the invoice amounts to be included. Valid options are:
Use the Start and End fields to include all invoices greater than a specific payment amount or all invoices less than a specific payment amount. |
Start |
Enter, or click to select, the starting invoice amount for the range that you want to include. The amount you enter here will mean that you want to include all invoices with amounts due that are greater than the amount you enter. If you select All or From Beginning in the Option field, this field is inactive. |
End |
Enter, or click to select, the ending invoice amount for the range that you want to include. The amount you enter here will mean that you want to include all invoices with amounts due that are less than the amount you enter. If you select All, One, or To End in the Option field, this field is inactive. |
Payment Status
In this group box, you can customize the report by payment status.
- PAY: Select this check box to include all vouchers with a status of Pay. Vouchers with this status were already selected for payment through the Select Vouchers process or through the Edit Voucher Payment Status screen.
- HOLD: Select this check box to include all vouchers with a status of Hold. This is the status most vouchers have when they are posted.
- PPHOLD: Select this check box to include all vouchers with a status of Partial Paid/on Hold. When a voucher is partially paid, this is the status of the unpaid portion of the voucher.
- DEFER: Select this check box to include all vouchers with a status of Deferred Payment. Vouchers with this status are not included in the selection of vouchers for payment when you run the Select Vouchers process. Use this status for a voucher that you want to have on hold, when you do not want the status changed on the Select Vouchers screen. You can change this status manually on the Edit Voucher Payment Status screen or the Select Vouchers screen.
- PAYWPD: Select this check box to include all vouchers with a status of Pay When Paid. Vouchers with this status belong to a vendor set up as a Pay When Paid vendor and charge a Pay When Paid project. You can only change this status to Pay after the vouchered items are billed and the bill is paid in full.
Show/Sort By
Use the fields in this block to sort the vouchers.
Field | Description |
---|---|
Voucher |
Select this check box to list each voucher individually. If you run this report with this option cleared, Costpoint generates a substantially abbreviated report containing only the total cash requirements per each bank account. This check box is selected by default. |
Supplemental Amounts |
Select this check box to include supplemental amounts on the Cash Requirements Report. Supplemental amounts are amounts that need to be included in your Cash Requirements Report but are not part of the selected vouchers. The supplemental amounts are included at the bottom of the report in a Supplemental Amounts section. When you select this check box, the Schedule field becomes enabled. |
Open Purchase Orders |
Select this check box to include all open purchase orders in addition to the vouchers on the report. Purchase orders are included if the Status in the Header is Open and the purchase order type is Purchase Order or Release Order. Lines on the purchase order are included if the line status is Open or Pending. |
1st sort |
From this drop-down list, select one of the following settings to specify the voucher sorting:
This option is enabled when you select the Voucher check box. |
Schedule |
Enter, or click to select, a schedule of supplemental cash requirements. The Cash Requirements Supplemental Amounts schedule is a user-defined schedule that allows you to add funds to the Cash Requirements Report that are not reported through the selected vouchers or purchase orders. You can include only one schedule in each Cash Requirements Report. You set up the schedules on the Manage Cash Requirements Rpt Supplemental Amounts screen. |
Options
Bank Account Abbreviation
Field | Description |
---|---|
Page Break |
Select this check box to begin each bank account abbreviation on a new page. Each bank account abbreviation will be subtotaled. If you select this check box, the corresponding Page Break check box in the Report Group group box becomes inactive. If you select neither the Page Break nor Subtotal check box, no subtotals print for each bank account abbreviation. This box is cleared by default. |
Subtotal |
Select this check box to subtotal each bank account abbreviation. There are no page breaks. If you select neither the Page Break nor Subtotal check box, no subtotals print for each bank account abbreviation. This check box is selected by default. |
Report Group
Field | Description |
---|---|
Page Break |
Select this check box to begin each bank account abbreviation, pay vendor/employee/vendor group, and transaction currency on a new page. Each group is subtotaled by the page break. If you select neither the Page Break nor Subtotal check box, no subtotals print. If you select this check box, the corresponding Page Break check box in the Bank Account Abbreviation group box becomes inactive. This box is cleared by default. |
Subtotal |
Select this check box to print subtotals for each pay vendor/employee/vendor group as selected. There are no page breaks. If you select neither the Page Break nor Subtotal check box, no subtotals print on the report. This check box is cleared by default. |