Use this screen to create reports that will 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 amount. The report will access all posted vouchers that have not been completely paid, even those on hold.
You can run this report at any time. For the most accurate information, do not run this report while the system is posting vouchers or printing/posting checks.
This is the date on which the report will assume that you will be printing your checks and EFTs. The report will include the amount of cash needed to pay your company's A/P requirements as of this date. The default setting is the system (today's) date.
Use this group box to determine the reference point of your "As of Date."
Select this radio button to create a report based on the anticipated pay dates for your outstanding A/P vouchers. The results will reflect your company's cash obligations for the voucher's anticipated pay date. This is the default setting.
Select this radio button to create a report based on the due dates for your outstanding A/P vouchers. The results will reflect your company's cash obligations for the selected due date.
Select this radio button to create a report based on the discount dates for your outstanding A/P vouchers. The results will reflect your company's cash obligations for the selected discount date.
If you select this radio button, the Requirements 'As of Date' field will be ignored and all invoices, even those not yet due, will be included in your report.
Use this group box to sort vouchers by invoice date or voucher number. In the default setting, the Voucher checkbox and the Invoice Dt radio button are selected.
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 a radio button in this group box to sort vouchers by either invoice date or voucher number. This group box is enabled only when you select the Voucher checkbox.
Select this radio button to sort vouchers by the invoice date entered in the Enter A/P Vouchers screen.
Select this radio button to sort vouchers by the voucher number assigned in the Enter A/P Vouchers screen.
In this group box, you can include or exclude vouchers based on the vouchers' bank account.
Select a range option in this drop-down box. This range will indicate the bank accounts, by abbreviated name, that will be included. 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 Range 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 Range Option field, this field will be inactive.
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. The default for this field is unchecked.
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. The default for this field is checked.
Use this drop-down box to group your report by "Pay Vendor ID," "Vendor Group," or "Employee ID." The default for this field is "Pay Vendor ID."
Use this drop-down box to select the range of pay vendor IDs, vendor groups, or employee IDs 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 Range 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 Range Option field, this field will be inactive.
Select this checkbox to begin each group or ID on a new page. Each group or ID will be subtotaled. If you select neither the Page Break nor the Subtotal box, there will be no subtotals for any group or ID. If you select this checkbox, the Page Break checkbox (in the Select Bank Account Abbreviation group box) will be inactive. The default for this field is unchecked.
Select this checkbox to print subtotals for each group or ID. There will be no page break. This checkbox is unselected by default. If you select neither the Page Break nor the Subtotal checkbox, there will be no subtotals for each group or ID.
In this group box, you can customize the report by payment status. The default settings are "PAY," "HOLD," and "PPHOLD."
Select this checkbox to include all vouchers with a status of "Pay."
Select this checkbox to include all vouchers with a status of "Hold."
Select this checkbox to include all vouchers with a status of "Partial Paid/on Hold."
Select this checkbox to include all vouchers with a status of "Deferred Payment."
Select this checkbox to include all vouchers with a status of "Pay When Paid."
Use this drop-down box to select the range of transaction 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 as the beginning of the range you want to include in the report. If you select "All" or "From Beginning" in the Range Options field, this field will be inactive. Only those currencies saved in the Maintain Currencies screen in Costpoint General Ledger 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 Range Options field, this field will be inactive. Only those currencies saved in the Maintain Currencies screen in Costpoint Multicurrency will be available in Lookup.
Use this group box to customize your report by invoice amount. Use the From and To fields to include all invoices greater than a specific payment amount or all invoices less than a specific payment amount. The default setting is "All."
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."
Enter, or use Lookup to select, the starting invoice amount for the range you want to include. If you select "All" or "From Beginning" in the Range Options field, this field will be inactive.
Enter, or use Lookup to select, the ending invoice amount for the range you want to include. If you select "All," "One," or "To End" in the Range Options field, this field will be inactive.
Select the checkboxes in this group box to include additional information on the report. By default, both checkboxes are unchecked.
Select this checkbox to include supplemental amounts in the Cash Requirements Report. When you select this checkbox, the Schedule field becomes enabled.
Enter, or use Lookup to select, your chosen schedule of supplemental cash requirements. Individual schedules are created in the Cash Requirements Report Supplemental Amounts screen. The schedule you select will print at the end of the Cash Requirements Report. You can include only one schedule in each Cash Requirements Report. For more information, please see the documentation for the Cash Requirements Report Supplemental Amounts screen.
Select this checkbox to include all open purchase orders in addition to the vouchers on the report.
The following tables will be accessed for this report:
BANK_ACCT
DFLT_CASH_ACCTS
OPEN_AP
PO_HDR
PO_LN
SUPPL_CASH_REQ
SUPPL_CASH_REQ_SCH
VCHR_HDR
VCHR_HDR_HS
VEND
VEND_TERMS
VEND_TERMS_SCH