PRINT CASH REQUIREMENTS REPORT
Use this screen to create reports to help you forecast cash needs. The report is flexible enough to allow for consideration of pay dates, due dates, or discount dates, as well as voucher status and voucher amounts. The report accesses all posted vouchers that have not been paid completely, including any that are on hold, partially paid, or marked as pay-when-paid.
You can run this report at any time. You must post vouchers in order for them to be included in the report; they must exist in the voucher history tables to be included. For the most accurate information, do not run this report while Costpoint is posting vouchers or printing/posting checks.
This report ignores subcontractor issues. Any subcontractor liabilities display here in full; however, payment will be held if you try to print a check/EFT for a subcontractor with payment restrictions.
Screen Contents
This screen has the following elements:
-
Use the Identification block to enter a parameter ID and description.
-
Use the Selection Ranges block to specify selection criteria.
-
Use the Show/Sort By block to sort vouchers by invoice date or voucher number and to show supplemental amounts and open purchase orders. If you choose to show supplemental amounts, you must select a Cash Requirements Supplemental Amounts Schedule to include in the report. You set up the schedules on the Manage Cash Requirements Rpt Supplemental Amounts screen.
-
Use the Options block to tailor the appearance of your report.
Location
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
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."
-
Anticipated Pay Date — Select this setting to create a report based on the anticipated pay dates for your outstanding Accounts Payable vouchers. The results reflect your company's cash obligations for the voucher's anticipated pay date. This is the default setting.
-
Due Date — Select this setting to create a report based on the due dates for your outstanding Accounts Payable vouchers. The results reflect your company's cash obligations for the selected due date.
-
Discount Date — Select this setting to create a report based on the discount dates for your outstanding Accounts Payable vouchers. The results reflect your company's cash obligations for the selected discount date.
-
None — If you select this setting, Costpoint ignores the Requirements 'As of Date' option. All invoices, even those not yet due, are included in the report.
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 Vendors 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.
Option
Use this drop-down list to select the range of bank account abbreviations to be included. Valid options are:
-
All — Select this option to include all available bank account abbreviations. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one bank account abbreviation and then enter that bank account abbreviation in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of bank account abbreviations. Enter the beginning bank account abbreviation for the range in the Start field and enter the ending bank account abbreviation of the range in the End field.
-
From Beginning — Select this option to include a range of bank account abbreviations that begins with the first of all the available bank account abbreviations and ends with the bank account abbreviation that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of bank account abbreviations that begins with the specific bank account abbreviation that you enter in the Start field and ends with the last of all the available bank account abbreviations. The End field is disabled for this option.
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
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:
-
All — Select this option to include all available records. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one record and then enter that record in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of records. Enter the beginning record for the range in the Start field and enter the ending record of the range in the End field.
-
From Beginning — Select this option to include a range of records that begins with the first of all the available records and ends with the record that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of records that begins with the specific record that you enter in the Start field and ends with the last of all the available records. The End field is disabled for this option.
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.
Option
Use this drop-down list to select the range of transaction currencies to be included. Valid options are:
-
All — Select this option to include all available transaction currencies. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one transaction currency and then enter that transaction currency in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of transaction currencies. Enter the beginning transaction currency for the range in the Start field and enter the ending transaction currency of the range in the End field.
-
From Beginning — Select this option to include a range of transaction currencies that begins with the first of all the available transaction currencies and ends with the transaction 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 of transaction currencies that begins with the specific transaction currency that you enter in the Start field and ends with the last of all the available transaction currencies. The End field is disabled for this option.
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
Option
Use this drop-down list to select the invoice amounts to be included. Valid options are:
-
All — Select this option to include all available invoice amounts. The Start and End fields are disabled for this option. This is the default.
-
One — Select this option to include only one invoice amount and then enter that invoice amount in the Start field. The End field is disabled for this option.
-
Range — Select this option to include a contiguous range of invoice amounts. Enter the beginning invoice amount for the range in the Start field and enter the ending invoice amount of the range in the End field.
-
From Beginning — Select this option to include a range of invoice amounts that begins with the first of all the available invoice amounts and ends with the invoice amount that you enter in the End field. The Start field is disabled for this option.
-
To End — Select this option to include a range of invoice amounts that begins with the specific invoice amount that you enter in the Start field and ends with the last of all the available invoice amounts. The End field is disabled for this option.
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.
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:
-
None
-
Invoice Date
-
Voucher
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
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
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.