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."

  • 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 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:

  • 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
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:

  • 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.

Field Description
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

Field Description
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.

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:

  • 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

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.