7.4.1 Cash Requirements Report
Previous Topic  Next Topic 

The Cash Requirements Report shows the amount owed to each Vendor based on the criteria you selected.


You may select this report by Discount or Due Date.


A Cutoff Date must be entered.


You may print the report for a specific Accounts Payable Account and Accounts Payable Location.  The AP Location criterion is very useful if you enter an AP Account with the location number (example: 2000-2).


Using this selection effectively requires entering “All Vouchers” in “Voucher Entry” (7.1.1 field 12) with the AP Account and AP Location. You must enter “Y” to Multiple Account Payable Accounts in “AP Setup” in SYSTEM MANAGEMENT (10.2.1 field 5) to make the AP Account field accessible.


The Gross and Net amounts displayed on the reports denotes the Original amounts before any payments were applied.  The Check and Check Date columns show a check number and date if a payment has been applied. This is only a reference item and does not affect the amounts shown. If more than one check has been applied (or a check has been applied and then voided) the message "Multiple Checks" will be displayed rather than the check number and date. To see what checks have been applied, please refer to "Payables Review" (7.3.1).


Helpful Hint:  The Cash Requirement Report is very useful to see who to pay first for the available discounts. It will also show you how much cash you need by a certain date to pay the bills.


You may view on the screen or print this report.


The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in “Port Entry” in POINT OF SALE (1.10) to enable this function.


After the report is displayed to the screen you also have the option of entering a <D> to download the report to your local hard drive. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” in POINT OF SALE (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.


<F>ile Option - This will produce a flat and tab-delimited file containing all the cash requirement data with the vendor code at the beginning of each detail line.