About cash flow forecasting

You can choose the level of detail to be used for forecast calculation by using the elements in the top part of the Cash management preferences (CA101000) window.
By default, released documents of the following types are included in calculation:

• Purchase invoices and adjustments
• Sales invoices and notes (only the unapplied amounts)
• Customer ledger payments (only the application amounts)
• Supplier prepayments
• Customer prepayments

You can also include in calculation the following documents with other statuses:

• Unreleased purchase invoices, adjustments, sales invoices, and notes
• Recurring documents scheduled for the dates within the forecast's 30-day period
• Unapplied payments

Some sales and purchase invoices may be entered into the system with no cash accounts specified.
To include such documents into a forecast, in the Cash account selection area of the Cash management preferences (CA101000) window, select the Include customer ledger and supplier documents with no cash account specified check box.

Before calculating the forecast, the system attempts to assign a cash account to each document without a cash account specified, based on supplier or customer default settings; after this, some documents will still have no cash account assigned.

The system processes the documents with unassigned default cash accounts a bit differently, depending on whether you run cash flow forecasting for a single selected cash account or for all cash accounts:

• Forecasting for a selected cash account:
  The system includes only the documents with the assigned cash account that matches the cash account.
  If the system fails to assign a cash account using the default settings, it assigns the cash account selected for forecasting provided the branch of the document matches the branch of the cash account.
• Forecasting for all available cash accounts:
  The system adds the documents with the assigned cash accounts to the balances of respective cash accounts.
  If the system fails to assign a cash account to a document, it adds the document to the balance of the cash account specified in the Default cash account field (which is available if you select the Include customer ledger and supplier documents with no cash account specified check box).
  No branch matching is performed.

• Forecasts based only on the entered documents are not especially correct.
  To improve forecasts, you can manually enter information about expected cash flows received from external sources and not yet supported by available documents.

• Using the Anticipated cash transactions (CA305500) window, you can select a cash account and enter the cash amounts you expect to collect or to pay out and the dates of such cash transactions.

• These transactions will be used only in the forecast calculations.

You can perform forecasts in any of the currencies defined in the system. In the Cash management preferences (CA101000) window, select the target currency and the exchange rate.