Cash Requirements Report
This report prints a list of Vendor Bills due for payment, in chronological order, in descending order of payment due date. The payments are further subtotalled in one-week increments and within each one-week group, by vendor. This lets you easily schedule payments. A running total of the amount due on each invoice and the discounted total is displayed so you can see the benefit of early payment on all invoices. This report is run from the A/P Main Menu.
Seven days is the default grouping. You can alter this in Security Extensions under the Custom Settings menu.
Procedure
Use the Query Window to refine your list of records. Common uses would be to:
-
List records for only one Vendor ID.
-
List only those invoices linked to a particular EMPLOYEE ID. This is useful if the majority of your work is invoices automatically generated from Sales Orders. If that is the case, you can use this feature to determine the cash requirements for each sales persons upcoming orders.
-
Avoid printing past due items on the report. Usually any items past due appear at the top of the report, but if your only past due items are contested bills, this distracts from the true purpose of the report. To eliminate these, enter:
Due Date > 12/15/97
… as one of your Filter Options. (Remember to substitute the current date for 12/15/97.)
