Forum Discussion

jreis's avatar
jreis
New Contributor II
3 years ago

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...
Consolidation
Metadata
Methodology
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
3 years ago

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

jreis's avatar
jreis
New Contributor II
3 years ago

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