Mid-Year Divestiture Reversing full YTD Data
Hi All,
We have a client who wants to exclude a subsidiary from their reporting rollup starting mid year in May 2022. Unfortunately the consolidation view is set to YTD so it appears that when we s...
Forum Discussion
Hi Joe
The easiest solution is just to load (or copy i.e. with a datamanagement job) the Mai's information forward till the end of the year.
How is the Mai's balance sheet of the deconsolidated company looking? Is it already deconsolidated in the ERP? Or was it deconsolidated with a rule, or manually? Is it an international company with a foreighn currency (this adds some complexity if you're currency conversion is YTD)?
For the BS, I'm using a business rule to copy all end balances to a dedicated deconsolidation flow, with the returned earnings as a plug.
I hope this helps and regards
Christian
Hi Christian,
Thank you so much for the response here!
That makes sense to pull the May YTD IncStmt data forward with a business rule - I will get started on writing this. I'm assuming you leveraged a consolidation rule running at C#Share attached to the cube so I will try that route.
Otherwise I am not sure I am entirely following what you mean on the balance sheet specifically with regards to the returned earnings plug element.
To answer your questions:
- The balance sheet looks ok in that it excludes the discontinued entity starting in May only with no weird reversals happening. That being said, after you're comment above I am thinking I may have to do something to get the Apr YTD Net Earnings to still flow through the Current portion of RE. Interestingly enough though the Balance Sheet is still in balance.
- Nothing has been deconsolidated in the ERP, they are still loading data as the legal sale is lingering longer than expected but they want it to be divested in the MGMT hierarchy starting in May 2022.
- There are 4 total base entities being divested (roll up to a sub-parent) and they are all in Mexican pesos currency. That being said they are converting periodically so hopefully I can dodge some complexity there.
Best,
Joe