Cash Requirements [report] [A/P]
Cash Requirements [report] [A/P]
From the DockMaster menu, select Accounts Payable> Reports > Cash Requirements
The Cash Requirements report is used to show the amount of cash needed to pay open invoices as of four user-defined due dates. The report can be run for one Vendor or a list of vendors, and one Vendor Category or a list of categories.
The report can be printed as a one-line summary totaling all vendors, a summary total for each vendor, or a detailed invoice listing for each vendor. You can exclude vendors who have a zero balance and also show an Expected Receipts figure for each date range chosen (this figure is generated using your open A/R invoices aged by due date).
-
Starting Date for Column 1 - Enter the Starting Due Date for Column 1 or press
Enter
to accept the default, which is the first day of the current month. -
Starting Date for Column 2 - Enter the Starting Due Date for Column 2 or press
Enter
to accept the default date. -
Starting Date for Column 3 - Enter the Starting Due Date for Column 3 or press
Enter
to accept the default date. -
Starting Date for Column 4 - Enter the Starting Due Date for Column 4 or press
Enter
to accept the default date. -
Detail, Summary, or Total - Press
Enter
to print the report in SUMMARY or click the down arrow and select DETAIL or TOTAL. This option affects the amount of vendor and invoice detail printed on the report. The Total option only shows one line of totals for all open invoices categorized by the defined ranges; the Summary option shows totals for all open invoices for each vendor categorized by the defined ranges; and the Detail option shows each vendor and all open invoices categorized by the defined ranges. -
Vendors – Enter one or multiple Vendor IDs or leave the prompt blank to include ALL vendors. Type a name preceded by a backslash "" to access a cross-reference list.
- Press F6 to list vendors.
- Press F7 to delete a row.
-
Vendor List – Enter a Vendor List name or press
Enter
to bypass this prompt. -
Vendor Category Codes - Enter one or multiple Vendor Category Codes or leave the prompt blank to include ALL category codes.
- Press F6 to list all category codes.
- Press F7 to delete a row.
-
Print Zero Balance Vendors – Click on this option to include vendors that have open invoices with a net balance of zero.
-
Print Expected Receipts – Click on this option to include an Expected Receipts figure for each date range chosen (this figure is generated using your open A/R invoices aged by due date).
-
Click the Print button to display the report.