Cash Forecast Period Amount
The CashForecastPeriodAmount compass extract query limits records to where forecast date is greater than three months ago. To expand the time frame, update the “WHERE” clause of the query.
Analyze by Date: Forecast Date
| Measure | Source and/or calculation |
|---|---|
| Cash Forecast Account Actual Amount | ActualAmount |
| Cash Forecast Account Adjustment Amount | AdjustmentAmount |
| Cash Forecast Account Forecast Amount | ForecastAmount |
| Cash Forecast Account Inflow Actual Amount | IF CashTransactionCategory.NaturalBalance = C THEN ActualAmount |
| Cash Forecast Account Inflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = C THEN ForecastAmount |
| Cash Forecast Account Original Forecast Amount | OriginalForecastAmount |
| Cash Forecast Account Outflow Actual Amount | IF CashTransactionCategory.NaturalBalance = D THEN ActualAmount * -1 |
| Cash Forecast Account Outflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = D THEN ForecastAmount * -1 |
| Cash Forecast Account Unclassified Actual Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ActualAmount |
| Cash Forecast Account Unclassified Forecast Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ForecastAmount |
| Cash Forecast Account Variance Amount | ActualAmount - ForecastAmount |
| Cash Forecast Enterprise Actual Amount | ActualAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Adjustment Amount | AdjustmentAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Forecast Amount | ForecastAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Inflow Actual Amount | IF CashTransactionCategory.NaturalBalance = C THEN ActualAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Inflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = C THEN ForecastAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Original Forecast Amount | OriginalForecastAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Outflow Actual Amount | IF CashTransactionCategory.NaturalBalance = D THEN (ActualAmount * -1) * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Outflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = D THEN (ForecastAmount * -1) * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Unclassified Actual Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ActualAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Unclassified Forecast Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ForecastAmount * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Enterprise Variance Amount | (ActualAmount – ForecastAmount) * CashForecastAccount.CorporateBaseCurrencyRate |
| Cash Forecast Location Actual Amount | ActualAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Adjustment Amount | AdjustmentAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Forecast Amount | ForecastAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Inflow Actual Amount | IF CashTransactionCategory.NaturalBalance = C THEN ActualAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Inflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = C THEN ForecastAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Original Forecast Amount | OriginalForecastAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Outflow Actual Amount | IF CashTransactionCategory.NaturalBalance = D THEN (ActualAmount * -1) * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Outflow Forecast Amount | IF CashTransactionCategory.NaturalBalance = D THEN (ForecastAmount * -1) * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Unclassified Actual Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ActualAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Unclassified Forecast Amount | IF CashTransactionCategory.NaturalBalance IS NULL THEN ForecastAmount * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Location Variance Amount | (ActualAmount – ForecastAmount) * CashForecastAccount.LocationCurrencyRate |
| Cash Forecast Period Amount Count | CashForecastPeriodAmount record count |