Consolidation stopped working
The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate ...
Forum Discussion
What's really strange is that I've done this, and it all aggregates and translates as expected until it gets to the top entity. Its direct children (which includes translation to USD) all are rolling up correctly. It's only not rolling up to the top parent, and only for certain periods. Still digging, but I'm perplexed at this point
In the end - when you finally find it - it will probably be quite simple. Happens to everyone. All one can do is keep digging.
You can also use a copy of this app in DEV and replicate the issue with a single data point. As you say, some data is rolling up, other data is not. Replicate both and see what the difference is. Translation you have checked (very often people forget to populate FX rates). Is it P&L data? Balance sheet data? ...
It's all the data, unfortunately.
Hi Michel, any luck with starting the consolidation now? I am following this one. Cheers
