Report Cash Requirements
Access
Use this routine to report cash requirements for a fiscal period. The report sorts and totals after each vendor, bank, and company.
This report includes an unmarked column between the Type and the Invoice Number columns. This unmarked column displays the AP bill status code. For example, for AP bills with a Hold status, "H" prints in the unmarked column.
Company
Bank
CountrySpecify a payables country (AP bill document currency) for reporting. If you leave the field blank, you report for all countries.
Sort by CountryTo sort the report by payables country, check the box. Otherwise, leave the box blank. If you check this field, the report provides a secondary sort and break on payables country.
As of DateEnter the as-of date for which you want to run this report.
Aging Method
Aging DaysEnter the number of days to use for aging buckets. The default is set based on the Bill Aging Days from the Payables Control Settings.
Pending Bills
Hold CodesTo include AP bills on hold in the report, check this box.
You can restrict the report to AP bills associated with one or more hold codes. If you click on the Arrow, a list of hold codes appears from which you can choose. If you click on the Action button, the Multiple Hold Codes Selection window appears from which you can choose.
Send Output toThe output destination of the report displays. To change the output destination, click on the Actions button and select Output Settings.
Export PathIf you select either the Personal Report Viewer ( PRV), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.
Once the run-time options have been selected, choose Run to produce the report.