You’re offline. This is a read only version of the page.
Announcements
Hi All,
I am generating a side by side "USD consolidated" report for few set of GP companies that has different functional currencies ( columns) like (CHF(swiss), GBP, HKD(hongkong) ) translated to "USD" in the consolidation report. I use a single Row Definition with multiple company dimension links. & reporting tree.
When the report is generated which ever column has the "Currency Display blank" it should be translating to "USD value" based on the exchange rate. For two company YTD column(ex; SWZ - CHF) MR is not translating to USD value for "some accounts/rows" . But for some rows MR is translating correctly see the below:
My Column Definition (partial image )is as follows:
Exchange Rates are added in GP exchange table. But still MR is not translating for some account rows. Can anyone help us on the above. MR Version is latest CU 14 and GP2015
Appreciate your help on the above ..
Thanks
*This post is locked for comments
have you checked all the steps from this tutorial ?
and the KB article from Microsoft:
support.microsoft.com/.../currency-translation-for-microsoft-management-reporter-2012-with-micro
[quote user="showlik"]
Hi All,
I am generating a side by side "USD consolidated" report for few set of GP companies that has different functional currencies ( columns) like (CHF(swiss), GBP, HKD(hongkong) ) translated to "USD" in the consolidation report. I use a single Row Definition with multiple company dimension links. & reporting tree.
When the report is generated which ever column has the "Currency Display blank" it should be translating to "USD value" based on the exchange rate. For two company YTD column(ex; SWZ - CHF) MR is not translating to USD value for "some accounts/rows" . But for some rows MR is translating correctly see the below:
My Column Definition (partial image )is as follows:
Exchange Rates are added in GP exchange table. But still MR is not translating for some account rows. Can anyone help us on the above. MR Version is latest CU 14 and GP2015
Appreciate your help on the above ..
Thanks
[/quote]
Hi Showlik,
Were you able to resolve this? If so, please tell us how.
Thank you
David Forman
Hi,
Can you try something different, the row is not translating is a balance sheet account can you change that into some other profit & loss account and run the report to narrow down the issue is relates to account type.
Hi Babu,
I am only using posted activity only. Thanks & Regards
Showlik
Hi,
Are you including posted activity only or both. Please confirm the depreciation account entry is posted.
Hi Guys,
Thanks for all for inputs. I am using single row definition using mutiple dimension links Below is the portion of the row definition( its a huge image). In the below snapshot account highlighted in RED is not translating. And Account row highlited in Green is translating correctly
Also the Exchange table for this company - and a default table is defined and also rates.
Thanks for your continuous help
Hi,
How did you define your row for both row which is translating correctly and not translating, can you please share screen shot.
Hi Showlik,
Go to Financial >> Setup >> Financial >> Multicurrency
Make sure currency translation default exchange table ID are setup for all the currency. Also, this needs to be done in all the companies.
Hi Babu,
I tried reconcile & check link and also rebuild the datamart as per the steps above. Still no luck.
Let me know if you have any other thoughts.
Thanks for your help.
Showlik
#1
André Arnaud de Cal...
294,017
Super User 2025 Season 1
#2
Martin Dráb
232,852
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
