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
2 years agoNew Contributor III
Functional currency not Translating correctly to Reporting currency
Hi All,
For some reason, local entities are translating incorrectly to reporting entity - they are not using the FX rates given. The FX setting are to use scenario FX rate setting (see screenshot), not the cube.
When doing the recon - I identified the differences when translating (see screenshot). Additional, it's taking amount not reported in local entity, and reporting it to reporting entity.
What could be the problem?
7 Replies
- chul
OneStream Employee
Could be many things but given you're looking at CF, take a look at your account and flow settings to ensure they're correct.
- QinisoNew Contributor III
The account and flow settings are correct. What else possibly I can look at?
- RafaelVidalNew Contributor III
Let's start with basics, does AccountTypes are correct, on each account?
- QinisoNew Contributor III
yes they are correct.
- chul
OneStream Employee
I'm unable to follow the screenshot but my suspicion is that you're using a flow account type along with flow member with the switch type set to true resulting in the account becoming a balance account type which translates at the closing rate based on your settings.
- QinisoNew Contributor III
I'm using revenue account type, and switch type is set to false
- QinisoNew Contributor III
For example: this below is translated to reporting currency report
And the below is local currency report
RatesType Rate Revenue and Expenses AverageRate 9.38191 Asset and Liabilities ClosingRate 9.39572
Related Content
- 4 years ago
- 2 years ago
- 1 year ago