Running the Aged Cash Requirements Report

Run an Aged Cash Requirements Report to see what your future cash requirements are by sorting payables that can be paid on the three dates specified in the report setup screen. For example, if your company runs checks three times a month, on the 10th, the 15th, and at the end of the month, this report shows you the projected cash requirements for covering the checks that will be printed on each date.

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

To run an Aged Cash Requirements Report:

From the A/P > Reports menu, select Aged Cash Requirements to display the Aged Cash Requirements Report screen.
In the Col #1 Age Date field, enter the cutoff date for open payables to be listed in this column. You can enter an actual or a variable date, but you cannot enter a date prior to the current date. Any open payable with a payment date that falls on or before this date is listed and added to the total in this column.
In the Col #2 Age Date field, enter the cutoff date for open payables to be listed in this column. You can enter an actual or a variable date. Any open payable with a payment date that falls after the Col # 1 Age Date and on or before this date is listed and added to the total in this column.
In the Col #3 Age Date field, enter the cutoff date for open payables to be listed in this column. You can enter an actual or a variable date. Any open payable with a payment date that falls after the Col #2 Age Date and on or before this date is listed and added to the total in this column.
In the Br/Tr/All field, enter the branch, territory, or All to be included in the report.
In the Detail/Summary field, press F10 and select one of the following:

Detail – Lists each payable and subtotals for each vendor.
Summary – Lists only subtotals for each vendor.

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.
In the Sort By field, press F10 and select one of the following to determine how to sort the report:

Remit To – Sorts the report by remit-to vendors.
Ship From – Sorts the report by ship-from vendors.

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.

Set options, if needed, and generate the report.

What the Report Shows

The Aged Cash Requirements Report shows the following information:

Column	Description
Branches	The branch number associated with this payable.
Sort by	The way in which the report was sorted, either by Ship From accounts or by Remit To accounts.
Ship From Vendor	The name of the vendor from whom the products were received.
Col #1	The open payables as of the first cutoff date.
Col #2	The open payables that fall after the Col #1 cutoff date.
Col #3	The open payables that fall after the Col #2 cutoff date.
Subtotal	The open payables in all three columns.
Outside Age Date	The payables that fall outside the given aging buckets.
Total	All open payables.