The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Intercompany Report for Non-consolidating entities
I am running into an issue with putting together intercompany reports. Basically, if an entity has an intercompany partner that is not a consolidating entity, no elimination would occur at the parent...
Thank you for your reply. This works for certain cases, however I am running into an additional complexity. In this example, if Base 2 and Base 3 have intercompany, those should show up as they eliminate at Parent 2. However, if Base 2 has intercompany with Base 1, that is the instance where we wouldn't want to see on the report because no elimination will occur.
T_Kress
OneStream Employee
OneStream EmployeeIf Base 2 has intercompany with Base 1, it should eliminate at the "Total" parent so you would still want it on the report because Parent 1 and Parent 2 come together in "Total" correct?
Not in this instance because Parent 2 is an Equity method investment with no consolidation to the Total
- T_Kress
If that is the case and Parent 2 is a non-consolidating parent then I would move it out of "Total" rollup and put it in it's own, stand-alone rollup. You can have one intercompany report that checks "Parent2" eliminations which are between Base 2 and 3 as those will still happen at the Parent 2 level. But by moving Parent 2 out of "Total", no elims will happen with Base 1.
Generally, any entities that are non consolidating like joint ventures or supplemental, non-consolidating entities I would not put in the "Total" rollup. I would create a rollup called "Alt_Rollups" or something and tuck them there. You can put a parent over everything which itself is IsConsol = False (and "Alt_Rollups" can also be IsConsol = False) and group "Alt_Rollups" + "Total" together in a "AllConsolParent" if you want to consolidate on one parent. But in this way "Total" will only include eliminations between consolidating base entities. If you commingle your hierarchy, you would need a custom elim rule to stop the elims between Base 1 and Base2/3 from happening, I believe.