Running the Cash Requirement Report

Run a Cash Requirement Report to see what your cash requirements will be by listing open payables with payment dates that fall within a designated date range.

For a description of the report, see What the Report Shows at the end of the topic.

To run the Cash Requirement Report:

From the A/P > Reports menu, select Cash Requirement to display the Cash Requirement Report window.
In the Branch/Territory field, enter the branch, branches, or territories to include in the report.
In the Start Date and End Date fields, enter the date range for which you want to run the report in MM/DD/YYY format.

To list payables for a single date, enter the same date in each field.

In the Mode area, select one of the following to determine the level of detail you want in the report:

Totals - Displays only a total amount for each payment date or vendor, depending on the sort order defined in the Sort by field. This is the least detailed mode.
Summary - Displays only subtotals of the invoices for each vendor within each payment date. These subtotals are shown within each payment date or for each payment date within each vendor, depending on the sort order selected in the Sort By area. This is a more detailed mode.
Detail - Displays each invoice amount and subtotals of the invoices for each vendor within each payment date or for each payment date within each vendor, depending on the sort order selected in the Sort By area. This is the most detailed mode.

In the Sort By area, select one of the following to determine how to sort the payables on the report:

Pay Date - Sorts the payables by payment date for each vendor.
Vendor - Sorts the payables by vendor for each payment date. This is the default.

In the Exclude Vendor with Credit Balance area, select whether to include vendors with which you currently have that credit.
Set options, if needed, and generate report.

What the Report Shows

The Cash Requirements Report shows the following information:

Column	Description
Branch	The branch number associated with the payable.
Pay On	The date the invoice amount is due.
Vendor Name	The name of the vendor to which the payable is due. If the payable is for a customer refund, or a one-time payment that uses a generic vendor, the vendor name and OVERRIDE displays in this field.
Invoice #	The invoice number connected with the payable.
Inv Amt	The total due on the invoice.
Deduct Amt	The amount, if any, of deductions applied to the invoice.
Gross Amt	The amount of the invoice after applying any deductions.
Disc Amt	The amount of the discount, if any, applied to the invoice.
Disc Date	The date the discount was applied.
Approve Amt	The amount of the invoice that has been approved for payment.
Unapproved	The amount, if any, that has not been approved for payment.
Payable ID	The system-assigned, unique identification number associated with the payable.