Skip to main content
Newcomer
October 20, 2023
Solved

FX translation for Reporting Currency

  • October 20, 2023
  • 2 replies
  • 0 views

Hi All, 

Need assistance in posting a journal to eliminate the difference. 

Qiniso_0-1697787211348.png

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

Qiniso_1-1697787316819.png

The translation should be periodic. 

 

Anyone have any idea what I'm missing?

 

Best answer by Qiniso

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

2 replies

OneStream Employee
October 20, 2023

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

QinisoAuthorAnswer
Newcomer
October 25, 2023

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

OneStream Employee
October 22, 2023

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

OneStream Employee
October 24, 2023

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