08-03-2023 07:22 AM
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
Solved! Go to Solution.
08-03-2023 11:28 AM
Hi, I have solved it.
NoDataZeroView for NonAdjustments was set to Use Scenario, when i changed it to Periodic, then the data flowed !
Thanks
08-03-2023 08:43 AM
HI @MarkHoughton can you show the data cell POV. Is it V#YTD or V#Periodic?
08-03-2023 09:09 AM
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.
08-03-2023 09:20 AM
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.
08-03-2023 10:17 AM
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
08-03-2023 10:19 AM
Oh and the force calculate made no difference.
08-03-2023 10:39 AM
Is that all 1 Scenario? Why are old periods open but future periods locked? I have a lot of questions, ha!
08-03-2023 10:42 AM
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.
08-03-2023 10:46 AM
Data sample with a full year unlocked in a random other entity. Also these postings are in a specific UD1 level.
08-03-2023 11:28 AM
Hi, I have solved it.
NoDataZeroView for NonAdjustments was set to Use Scenario, when i changed it to Periodic, then the data flowed !
Thanks
08-03-2023 11:37 AM
Nice find.
08-03-2023 11:39 AM
Thanks for your help Mike. It forced me to look again at every setting !