Running the Cash Requirement Report

Run a Cash Requirement Report to see what your cash requirements are 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 a Cash Requirement Report:

From the A/P > Reports menu, select Cash Requirement to display the Cash Requirement Report screen.
In the Br/Tr/All field, enter the branch, territory, or All to include in the report.
In the Start Date field, enter the date that you want the report to start from in the MM/DD/YYYY format. The default is the current date.
In the End Date field, do one of the following:

To list the payables for a single date, press Enter to copy the start date information to this field.
To list the payables for a range of dates, enter the date that you want the report to finish at, in the MM/DD/YYYY format.

In the Detail/Summary/Totals field, press F10 and select one of the following to determine the level of detail you want in the report:

Detail – Includes 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 defined in the Sort by PayDate/Vendor field.
Summary – Includes only subtotals of the invoices for each vendor within. The subtotals are shown within each payment date or for each payment date within each vendor, depending on the sort order defined in the Sort by PayDate/Vendor field.
Totals – Includes only a total amount for each payment date or vendor, depending on the sort order defined in the Sort by PayDate/Vendor field.

In the Sort by PayDate/Vendor field, press F10 and select one of the following to determine how to sort the payables on the report:

PayDate – Sorts the payables by vendor for each payment date. This is the default.
Vendor – Sorts the payables by payment date for each vendor.

In the Exclude Vendors with Credit Balance field, enter one of the following:
Y – Excludes vendors with a positive credit balance. This is the default.
N – Include vendors with a positive credit balance.

Use the Slct key to display the Additional Selection Input screen, where you can enter additional criteria, for example, to select orders associated with a particular batch number.
Set options, if needed, and generate the report.

What the Report Shows

The Cash Requirements Report shows the following information:

Column	Description
Branches	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 to be paid.
Unapproved	The amount, if any, that has not been approved to be paid.
Payable ID	The system-assigned, unique identification number associated with the payable.