Run the 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 window. 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 are printed on each date.
For a description of the report, see What the Report Shows at the end of the topic.
To run the Aged Cash Requirements Report:
From the A/P > Reports menu, select Aged Cash Requirements to display the Aged Cash Requirements window.
In the Branch/Territory field, enter the branch, branches, or territories to include in the report.
In the Col #1 Age Date field, enter the cutoff date for open payables to list 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 list 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 list 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 beforehis date is listed and added to the total in this column.
n the Sort By area, select whether to sort the report by ship-from vendor or remit-to vendor.
In the Display Options area, select one of the following:
Detail - Lists each payable and subtotals for each vendor.
Summary - Lists only subtotals for each vendor. This is the default.
In the Exclude Vendor with Credit Balance area, select whether to include vendors that have a credit balance in the report.
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. |
See Also: