Cash Forecast Apply Selection Panel

You must set these values to view the data in the graph:

Company Selection

Currency
The currency in which the cash forecast data must be displayed. Possible values:
  • Forecast Currency: The currency in which the forecasted cash inflow and outflow data is displayed in the grid. This value is defaulted from the Currency for Cash Forecast field in the CMG Parameters (tfcmg0100s000) session and cannot be modified.
  • Transaction Currency: The original currency in which the transaction is recorded. This value can be specified.
Company
The company for which the forecasted or transactional cash inflow and outflow data is displayed in the grid. You can select a specific company or multiple companies.
Note: 
  • You can select multiple companies only if the current currency is part of the group currency.
  • By default, the company number of the logged in company is displayed.

Period Selection

Start Date
The start date for the cash inflow and outflow graph. By default, the current date is displayed.
Period Definition
The number of periods to be displayed in the graph.
Note: The opening cash balance is the first period followed by a maximum of 25 periods.

Amounts

Opening Balance
The type of opening balance to be displayed in the graph. Possible values:
  • Automatically Calculated: The opening balance is calculated automatically based on the values specified in the Balance on Cash Account field of the Bank Relation (tfcmg0110s000) session. This value is considered only if the Exclude from Cash Forecast check box is cleared.
    Note: If the Currency field is set to Forecast Currency, the sum of the cash forecast currency of bank relations and cash registers of the selected companies is calculated. However, if this value is set to Transaction Currency, the sum of all bank relations and cash registers where the currency is equal to the selected Currency Code for the selected company or companies, is calculated.
  • Manual Input
  • Manual Opening Balance: The amount in which the opening balance is specified by the user in the Manual Opening Balance field that is displayed. This amount is displayed in the currency selected in the Currency field. This field is displayed only if the Opening Balance field is set to Manual Input.
Minimum Cash Position
The amount used to display the minimum cash position in the Cash In versus Cash Out widget. This amount is displayed in the currency selected in the Currency field.
Show Budget Amounts by Ledger Account
If this check box is selected the budget amount is split by ledger account in the cash inflow and outflow widget. Else, the budget amount is displayed as the sum of each inflow and outflow.

The Apply Selection panel works as a fly-in or fly-out panel. After applying the selection criteria, users can minimize the panel to view the workbench in full screen.