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

Qiniso's avatar
Qiniso
New Contributor III
2 years ago
Solved

FX translation for Reporting Currency

Hi All, 

Need assistance in posting a journal to eliminate the difference. 

I tried posting a journal using reporting currency (ZAR) to eliminate the difference, but it's not going through.

The translation should be periodic. 

 

Anyone have any idea what I'm missing?

 

Intercompany Matching
Journals
  • Qiniso's avatar
    Qiniso
    2 years ago

    Thanks I did. Turns out I had to Force Consolidate allowing data entered to consolidate into the reporting currency.

5 Replies

  • chul's avatar
    chul
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    I suggest checking the results of your journal in a cube view or quick view rather than in the IC matching report.

    • Qiniso's avatar
      Qiniso
      New Contributor III
      2 years ago

      Thanks I did. Turns out I had to Force Consolidate allowing data entered to consolidate into the reporting currency.

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    Did you check, if the IC matching definition includes adjustments?

    • chul's avatar
      chul
      Icon for OneStream Employee rankOneStream Employee
      2 years ago

      A limitation of the IC matching report is that it doesn't list adjustments that have no data in local currency.

    • Qiniso's avatar
      Qiniso
      New Contributor III
      2 years ago

      Yes it does. Turns out I had to Force Consolidate allowing data entered to consolidate into the reporting currency.