Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Management Reporter - ...
Finance | Project Operations, Human Resources, ...
Unanswered

Management Reporter - Foreign Translation

(0) ShareShare
ReportReport
Posted on by JGarcia123 1,608

My client has both a US company and foreign company and we are in the process of setting up financials in Management Reporter. Both are denominated in their own currency.  As part of that process we have configured an exchange table to take the foreign currency and translate it to US dollars.  Both companies have access to each currency, and accounts in the foreign entity have been setup to translate using the "current" rate. 

So far it seems to be working, except I have one or two accounts that will not translate.  If I look at the foreign currency setup option under Cards/Account I see no difference between the working accounts and the problem account.  Any thoughts as to why one account may not be translating.

Will welcome any thoughts or suggestions.

Thank you.

JG

Categories:
Microsoft Dynamics GP
  • JGarcia123 Profile Picture
    JGarcia123 1,608 on at
    RE: Management Reporter - Foreign Translation

    Thanks Greg,

    For the account in question, I see the Currency Method set to 2.  Within card/account/currency screen the currency type is set to "Current".  I think all of that is in line with what it should be or am I missing something?

    JG

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Management Reporter - Foreign Translation

    Is this a Data Mart or Legacy install of MR?  If this is Data Mart and the account is not translating at all, there some script you can run against the Data Mart database to see what Translation Type the account is using.  

    select * from datamart.Organization
    --find Id for your organization.  Use it for the OrganizationId in the next query.

    select * from datamart.DimensionDefinition where OrganizationId = 2
    ---find Id for the main segment.  Use it for the DefinitionId in the next query.  The Name value will be the main segment for the account.  

    select * from datamart.DimensionValue where name = '1100' and DefinitionId = 2
    --find Id for account.  Use it for the Id in the next query.

    select * from datamart.Account where Id = '537'

    The results here will show the CurrencyMethod.  If it is set to 0 (unknown), MR won't translate the amounts for that account.  This can happen if the account does not have a Currency Translation Type in the MC00200 table.  You could run this statement to check that:

    SELECT * FROM GL00100 WHERE ACTINDX NOT IN (SELECT ACTINDX FROM MC00200) AND ACCTTYPE = 1

    If you're using the Legacy provider, check the GL20001 table.  You can search by ACTINDX.  If there is a record for the account, go to Cards | Financial | Account.  Click Currency and then change the translation method from Current to Historical.  You'll likely get a message about rates being lost.  You won't lose your actual exchange rates, so you can click Yes to the message.  Save the account and then change it back to Current.  

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans