Forum Discussion

New Contributor III

2 years ago

Eliminations not working in an Alternate hierarchy

We have our main hierarchy that has intercompany eliminations working as they should.

We also have 2 alternate hierarchies where one is eliminating as it should, and the other is not eliminating.

Consol - Primary Hierarchy - Percent Consolidation 100

Consol - Alternate hierarchy - Percent Consolidation 0 - Elimins not working at first common parent,

Second Alt Hierarchy - Percent consol 100 - Eliminations working as they should.

halbrooks100
2 years ago
Thank you for your feedback, it appears our issue is related to the account extensibility, the base level accounts are not valid for the parent rollups and therefore do not eliminate. Meeting further with OneStream to confirm.

NicolasArgente
Valued Contributor
2 years ago
Hi halbrooks100
You are correct, there should be an elim on Consol. Please review your elimination script probably under Finance BR rules. Is Consol rolling up to a parent? Remember Elim will happen after the local, translate....
Thanks,
- MikeG
  Contributor III
  2 years ago
  And halbrooks100 both hierarchies will need to be Consolidated separately at the respective Entity Parent. Make sure your V#CalculationStatus is OK on both hierarchies.
  - halbrooks100
    New Contributor III
    2 years ago
    Thanks Mike, sounds like I need to pull the alternate out into its own consolidation. and thanks v# calc status is OK in both.
- halbrooks100
  New Contributor III
  2 years ago
  Yes Consol rolls up to a consol all so we can run consolidations all at once, sounds like that my be hurting us in this scenario.
halbrooks100
New Contributor III
2 years ago
Thank you for your feedback, it appears our issue is related to the account extensibility, the base level accounts are not valid for the parent rollups and therefore do not eliminate. Meeting further with OneStream to confirm.