PERIODIC and QTD for Balance Sheet accounts in YTD based model

[trond_valldal]

Hi experts,

having a slight issue with how to report PERIODIC and QTD numbers for balance sheet accounts in a YTD based model.
Based on the measures in UJ_MAINTAIN_MEASURES_FORMULA, it seems that BS accounts are excluded from the PERIODIC and QTD calculations (it works fine for the P&L accounts). For the record, accounts have the correct account types, i.e. AST, LEQ, INC, and EXP. In order words, no matter what measure is chosen in the report, BS accounts only shows YTD amounts. However, my client wants to see the PERIODIC and QTD amounts (i.e. the movements) for all accounts, not only P&L accounts. I don't know why BPC measures are set up like this, but I'm guessing this is not a unique problem.
Anyway, I assume the easiest way to overcome this is to modify the measure formulas, but I just wanted to ask if anyone out there has faced this issue, and how you dealt with it. And if you did it by modifying the measure formulas, would love to see a copy of that!
Thanks!
Trond

[trond_valldal]

OK, see your point. Let's see what I can do with Flow and some Logic Script.

[trond_valldal]

I have, but they have some unique requirements where certain postings in a given period should be part of the opening balance (as opposed to the carry-forward from last period of previous year only) which created a bit of a mess. I therefore thought modifying the measures so that BS accounts were treated the same as P&L accounts would be the way to go.

[former_member186338]

"I therefore thought modifying the measures so that BS accounts were treated the same as P&L accounts would be the way to go." - bad idea!

[former_member186338]

And in general - please install IFRS kit as a sample! Please read also very detailed IFRS kit documentation.

[trond_valldal]

I have, and they're not budging....lol. I sort of understand -- seeing the movements of a balance sheet account can be useful. But BPC doesn't work that way for BS account unless you change the measure formula.

[former_member186338]

Think about flow dimension...

[former_member186338]

"However, my client wants to see the PERIODIC and QTD amounts (i.e. the movements) for all accounts, not only P&L accounts." - very strange requirement! Please talk to finance people...