Balances roll-up for Financial year and Accounting Periods defined in GL Accounting calendar
We have Financial year defined as below
2018 -- Apr-17 to Mar-18
2019 -- Apr-18 to Mar-19
First open period is Apr-17 , but no transaction / entries are postedin FInance year 2018.
In finance year 2019, we have transaction/ entries posted in Apr-18, Mar-18, May-18, Jun-18 periods. But none of the periods where never closed.
When we create Essbase reports ( using SmartView , finance reporting studio )
In the reports we selected any one of Accounting Periods as "Apr-18 or Mar-18 or May-18 or Jun-18 " - Balance Amount as "Ending Balance". Amount Type as PTD, YTD, QTD. The reports shows balances.
But when we select Accounting Period as 2019 ( financial year ) with Balance Amount as "Ending Balance". Amount Type as PTD, YTD, QTD.