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. Once the report criteria have been selected, click Run to produce the report.

 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 (Personal Report Viewer) A STORIS printer output option that allows you to customize report results, for example to rearrange data columns.), 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.