8.7.10 Forecast Balance Sheet Summary in Consolidated Currency
Table 8-5 Forecast Balance Sheet Summary in Consolidated Currency
Report Name | Forecast Balance Sheet Summary in Base Currency Forecast Balance Sheet Summary in Cons Currency |
---|---|
Description | Balance Sheet Forecast Report. Provides views of both Ending and Average Balance, across time buckets. |
Dashboards Prompts |
Prompt – Income Scenario2
Prompt - Income Scenario3
Prompt Financial Results 03
|
Report Criteria |
Product < formula > case WHEN Product."Account Type" IN (100.00, 200.00) then 'Total Assets' WHEN Product."Account Type" IN (300, 400.00, 500.00) then 'Total Liabilities & Equity' end Product.Product Name Level 19 Standard Cash Flow Results.Average Balance (140) Standard Cash Flow Results.Ending Balance (100) Time Buckets.Start Date Time Buckets.End Date Currency.Base Currency |
Conditions | Product.Account Type IN (100,200,300,400,500) |
Compound Layout |
Title View Selector Pivot Table - Average and Ending Balance Pivot Table2 - Average Balance Pivot Table3 - Ending Balance |