The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

MarkHoughton's avatar
MarkHoughton
Contributor
2 years ago
Solved

New balance sheet accounts do not feed through all months i.e. derived data is not working. Why ?

Hi,

I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. 

Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month.

So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that.

Where else do I need to look ?

Cheers

Mark

Dimensions
  • MarkHoughton's avatar
    MarkHoughton
    2 years ago

    Hi, I have solved it. 

     

    NoDataZeroView for NonAdjustments was set to Use Scenario, when i changed it to Periodic, then the data flowed !

     

    Thanks

11 Replies

  • MarkHoughton's avatar
    MarkHoughton
    Contributor
    2 years ago

    Hi, I have solved it. 

     

    NoDataZeroView for NonAdjustments was set to Use Scenario, when i changed it to Periodic, then the data flowed !

     

    Thanks

  • MarkHoughton's avatar
    MarkHoughton
    Contributor
    2 years ago

    Data sample with a full year unlocked in a random other entity. Also these postings are in a specific UD1 level.

     

    • MarkHoughton's avatar
      MarkHoughton
      Contributor
      2 years ago

      Hi Mike.

       

      View is V#YTD for all rows and the "Rows" are just an A#AllPPE.Base setting, so no individual variations there either.

      • MikeG's avatar
        MikeG
        Contributor III
        2 years ago

        OK, for a sanity check can you post the Account member properties here.  My guess is the Account Type would be set to Asset.  For testing purposes, add the View to the Columns.  Show V#Periodic, V#YTD, and V#CS for the calculation status.  Curious if you ran a Force Consolidate on period 2023M9 if that may be what all is needed.

        Hope this helps.

  • MarkHoughton's avatar
    MarkHoughton
    Contributor
    2 years ago

    Hi Mike, yes "ASSET" as you surmised. 

    Details for Periodic...

    Calc status...

     

    Question though, why would all other accounts 'autofill' but not these new ROU's if none of them have been calculated. 

    Regards

    Mark

     

     

     

  • MikeG's avatar
    MikeG
    Contributor III
    2 years ago

    Is that all 1 Scenario?  Why are old periods open but future periods locked?  I have a lot of questions, ha!

    • MarkHoughton's avatar
      MarkHoughton
      Contributor
      2 years ago

      Yes, all one scenario - Actual. This is a copy of our live system from May which I am using as a test application. Hence future periods being locked, but the problem is in live and the group accountant only just told me that they have been manually 'fixing' this value each month since P01-23 in the ROU accounts.  I have just used these sample numbers to demonstrate the problem.

    • MarkHoughton's avatar
      MarkHoughton
      Contributor
      2 years ago

      Thanks for your help Mike. It forced me to look again at every setting !