Forum Discussion

LisaC's avatar
LisaC
New Contributor II
3 years ago

Derived data on base and parent level entities

Dear community,  We are now helping a client to set up a data management sequence to copy six months (T#YearM1-M6) of Actual data to Forecast. And user can start entering figures for Forecast M7-12....
Data Management
JackLacava's avatar
JackLacava
Community Manager
3 years ago

I'm going out on a limb here, but it could be a function of the Retain Next Period Data, which can be a bit surprising; adjustments already posted in M7 at parent level; or some custom rule being funny.

I would try clearing any data for M7 with a one-off rule and looking at results. Then consolidating again M6 - if it appears again, chances are it's a rogue calculate somewhere.