8.7.16 Forecast Balance Sheet Detail in Consolidated Currency
Table 8-8 Forecast Balance Sheet Detail in Consolidated Currency
Report Name(s) | Forecast Balance Sheet Detail in Base Currency Forecast Balance Sheet Detail in Consolidated Currency |
---|---|
Description | Forecast Balance Sheet across time buckets, with Product level detail and option to choose Avg + End, Avg Only or End Only. |
Dashboards Prompts |
Prompt Financial Results 01 Prompt Financial Results 02 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' end Time Buckets.Start Date Time Buckets.End Date Product.Product Name Level18 Standard Cash Flow Results.Ending Balance (100) 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 |