Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter No...
Microsoft Dynamics GP (Archived)

Management Reporter Not Translating Correctly

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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:

6378.error.jpg

My Column Definition (partial image )is as follows:

7245.error2.jpg

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

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Management Reporter Not Translating Correctly

    have you checked all the steps from this tutorial ?

    community.dynamics.com/.../on-demand-learning-management-reporter-multicurrency-configuration-for-microsoft-dynamics-gp-2015

    and the KB article from Microsoft:

    support.microsoft.com/.../currency-translation-for-microsoft-management-reporter-2012-with-micro

  • Jeyakumar Profile Picture
    Jeyakumar 592 on at
    RE: Management Reporter Not Translating Correctly

    Hi Showlik,

    Were you able to resolve this? 

    Thank you,

    Jeyakumar

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Not Translating Correctly

    [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:

    7245.error2.jpg

    My Column Definition (partial image )is as follows:

    7245.error2.jpg

    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

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Management Reporter Not Translating Correctly

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Not Translating Correctly

    Hi Babu,

    I am only using posted activity only.  Thanks & Regards

    Showlik

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Management Reporter Not Translating Correctly

    Hi,

    Are you including posted activity only or both.  Please confirm the depreciation  account entry is posted.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Not Translating Correctly

    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

    error7.jpg

    Also the Exchange table for this company - and a default table is defined and also rates.

    error7.jpg

    Thanks for your continuous help 

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Management Reporter Not Translating Correctly

    Hi,

    How did you define your row for both row which is translating correctly and not translating, can you please share screen shot.

  • Manikandan Profile Picture
    Manikandan 2,845 on at
    RE: Management Reporter Not Translating Correctly

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter Not Translating Correctly

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans