Cash Requirements Report

Yes, you must post vouchers in order for them to be included in the report. They must exist in the voucher history tables before they will be included.

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 is the date on which the report assumes that you will be printing your checks and EFTs. The default setting is the system (today's) date. Enter, or use the Calendar icon to select, another date. The date you select cannot be earlier than today's date.

The report will include the amount of cash needed to pay your company's A/P requirements as of this date. This field will be used in conjunction with the Voucher Date Cutoff selected to determine the vouchers that will be included in this report. Any vouchers that are equal to or past the chosen voucher cutoff date will print on the report.

Use this drop-down box to determine the reference point of your "As of Date." The options are Discount Date, Anticipated Pay Date, and Due Date.

Select the bank account abbreviations that you want to include in the report. You linked the vendor to a cash account description in the Vendor User Flow screen (Accounting\Maintain\Vendors). You can change this cash account description until the voucher is paid.

You linked the cash account descriptions to the bank account abbreviations in the Cash Accounts screen (Accounting\Maintain\Accounts).

Select a range option in this drop-down box. This range will indicate the bank account abbreviations.

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 bank account abbreviation for the range you want to include.

If you select "All" or "From Beginning" in the Option field, this field will be inactive.

Enter, or use Lookup to select, the ending bank account abbreviation for the range you want to include.

If you select "All," "One," or "To End" in the Option field, this field will be inactive.

Use this drop-down box to group your report by "Pay Vendor," "Vendor Group," or "Employee."

The default for this field is "Pay Vendor ." You defined the vendor groups in the Vendor User Flow screen (Accounting\Maintain\Vendors). They are used to tie vendors together.

Use this drop-down box to select the range of pay vendors, vendor groups, or employees 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 starting value for the range you want to include.

If you select "All" or "From Beginning" in the Option field, this field will be inactive.

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

Use this drop-down box to select the range of transaction currencies that you want included in the report.

Only those currencies that you set up in the Currencies screen (Administration\Maintain\Multicurrency) are eligible for entry or Lookup.

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 as the beginning of the range you want to include in the report.

If you select "All" or "From Beginning" in the Option field, this field will be inactive.

Only those currencies saved in the Maintain Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.

Enter, or use Lookup to select, the currency code as the ending of the range you want to include in the report.

If you select "All," "One," or "To End" in the Option field, this field will be inactive.

Only those currencies saved in the Maintain Currencies screen (Administration\Maintain\Multicurrency) will be available in Lookup.

Use this drop-down box to select which invoice amounts will be included in the report.

Options are "All," "One," "Range," "From Beginning," and "To End."

The default for this field is "All."

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.

Enter the starting invoice amount for the range 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 entered.

If you select "All" or "From Beginning" in the Option field, this field will be inactive.

Enter ending invoice amount for the range 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 entered.

If you select "All" or "From Beginning" in the Option field, this field will be inactive.

Select this checkbox to include all vouchers with a status of 'Pay.'

Vouchers with this status have already been selected for payment through the Select Vouchers process or through the Edit Voucher Payment Status screen (Accounting\Process\Pay).

Select this checkbox to include all vouchers with a status of 'Hold.'

This is the status most vouchers will have when they are posted.

Select this checkbox to include all vouchers with a status of 'Partial Paid/on Hold.'

When a voucher is partially-paid, this is the status that the unpaid portion of the voucher will have.

Select this checkbox to include all vouchers with a status of 'Deferred Payment.'

Vouchers with this status will not be included in the selection of vouchers for payment when the Select Vouchers process is run. This status is used for a voucher that you want to have on hold and do not want to have the status changed to pay in the Select Vouchers process. You can change this status manually in the Edit Voucher Payment Status screen (Accounting\Process\Pay) or in the Select Voucher process by selected Clear Deferrals that will change the status back to Hold and will make it eligible to be changed to a pay status.

Select this checkbox 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 once the vouchered items have been billed and the bill has been fully paid.

Select this checkbox to list each voucher individually.

Running this report with the checkbox unchecked will result in a substantially abbreviated report containing only the total cash requirements per each bank account.

This checkbox is selected by default.

Select this checkbox to include supplemental amounts in 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 will be included at the bottom of the report in a Supplemental Amounts section.

When you select this checkbox, the Schedule field becomes enabled.

Select this checkbox to include all open purchase orders in addition to the vouchers on the report.

Purchase orders will be included if Status in the Header is "open" and the purchase order type is "Purchase Order" or "Release Order". Lines on the PO will be included where the line status is "Open" or "Pending".

In this drop-down box you can sort vouchers by either invoice date or voucher number.

This drop-down box is enabled only when you select the Voucher checkbox.

Enter, or use Lookup to select, your chosen schedule of supplemental cash requirements.

The Cash Requirements Supplemental Amounts schedule is a user-defined schedule set up to allow the user to add funds to the Cash Requirements Report that are not reported through the selected vouchers or POs.

You can include only one schedule in each Cash Requirements Report.

Select this checkbox to begin each bank account abbreviation on a new page. Each bank account abbreviation will be subtotaled.

If you select neither the Page Break nor the Subtotal checkbox, there will be no subtotals printed for each bank account abbreviation.

If you select this checkbox, the Page Break checkbox (in the Report Group group box) will be inactive.

This box is unchecked by default.

Select this checkbox to subtotal each bank account abbreviation. There will be no page break.

If you select neither the Page Break nor the Subtotal checkbox, there will be no subtotals printed for each bank account abbreviation.

This checkbox is selected by default.

Select this checkbox to begin each bank account abbreviation, pay vendor/employee/vendor group, and transaction currency on a new page. Each group will be subtotaled by the page break.

If you select neither the Page Break nor the Subtotal box, there will be no subtotals by pay vendor, bank account abbreviation, or transaction currency.

If you select this checkbox, the Page Break checkbox (in the Bank Account Abbreviation group box) will be inactive.

This box is unchecked by default.

Select this checkbox to print subtotals for each pay vendor/employee/vendor group as selected. There will be no page break.

If you select neither the Page Break nor the Subtotal checkbox, there will be no subtotals in the report.

This checkbox is unselected by default.