AR30005 - Cash Forecast Report

This SQR report shows open balances on an as of date by customer in the base currency. It also displays the amount of cash that you can expect to receive in the cash forecast categories. The system determines in which period the cash will be received using the average days late figure for a customer.

The amounts in each forecast category are based on the number of days that you enter in the Days Per Category field on the Cash Forecast page. For example, if you enter 30, the categories on the report would be:

Field or Control	Description
Pre-Forecast	The open balance on the as of date.
Forecast 1	The amount you would expect to receive 1 to 30 days after the as of date.
Forecast 2	The amount you would expect to receive 31 to 60 days after the as of date.
Forecast 3	The amount you would expect to receive 61 to 90 days after the as of date.
Post-Forecast	The amount you would expect to receive 91 days or more after the as of date.
Post-Forecast	The amount you would expect to receive 91 days or more after the as of date.
In Dispute	The total amount of items in dispute.