Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Queston on multicurrency with multiple databases. US based, one company in UK

Posted on by Microsoft Employee

I would like to get some feedback on what might be the most effective setup for multicurrency.   I am working with a client that is based in the US with over 125 databases.  They currently have one UK company that is being converted over to Dynamics.  They are the only company not using US dollars.   Normal operations in the past were to allow the UK company to process everything in pounds and when the information was posted to the  US (summary GL journal only), a month end process was run offline to revalue pounds to dollars using a EOM rate for balance sheet (with historical on PPE) and average monthly for income statement items.   The US company still wants to do exchange rate revaluation only at month end.

As I see it there are at least 2 options and I would appreciate some feedback on what would be the most efficient.

1. Set up the UK company with functional currency UK pounds, reporting currency US dollars.  If you enter everything in pounds you must use FRX or Management reporter to do the conversion for you.  Management’s concern here is that they do not want to have to do the calculation of exchange rate and if they do consolidated reporting the reports will not be correct.  This can be addressed with a report specific to the UK company and the converted amounts pulled in via use of a tree.

2. Set up the UK company with functional currency US dollars, with all accounts having the ability to use UK pounds and force all entries to be done using the originating debit and credit fields.  From my understanding, after you have set up the multicurrency rate and assigned accounts, then when you do a revalue the currency exchange gain or loss would be calculated.     My concern using this method would be that it is easier for reporting at month end, but during the month for processing the UK folks will have to be sure to enter the transactions in originating currency for gl, and originating debit and credits for payables.  I would worry that there could be some error and that some things would be posted in US dollars.  The UK company does have a UK install.

I need to make a decision in this week and before I make my presentation to management, I would appreciate some feedback.

THANK YOU

*This post is locked for comments

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    BS is Current, IS is Average, then they record an unrealized gain or loss for the difference each month.  Simple enought.

  • Suggested answer
    Howard Swerdloff Profile Picture
    Howard Swerdloff 845 on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    You can update the rate table as often as you want to keep realized and unrealized gains processing correctly. You are correct that the accounts can be revalued at month end prior to running reports from FRx or Management Reporter. Additionally, I have created a blog post that speaks to how to update the rate table on a daily basis.alldynamicsgp.com/.../gp-2010-multicurrency-rate-updates

    I hope this helps.

  • Doug Profile Picture
    Doug 110 on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    Susan,

    How do you calculate your Currency Translation adjustment on the Balance Sheet?

    thx,

    Doug

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    Best to use Sterling as the Functional currency if at all possible. If you transact in VAT in the UK - then you could run into issues with VAT reporting if you had functional currency of USD. The Revenue in the UK do publish FX rates for converting foreign denominated values to Sterling for VAT calculations - but there is no way to automate this in GP interface [although it could be completed using reports]. same would apply to Intrastat and ESL reporting. We have a number of clients facing the exact same issues as you. In most cases they denominate in Sterling and use MR to consolidate. However some denominate the UK company in USD - but these are exceptions where the benefits of doing it this way far outweigh the downsides.

    I presume the company databases [including the UK Company] are on the same instance of SQL server, and users are using remote desktop?

    Ian.

  • Suggested answer
    cgust Profile Picture
    cgust on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    Dynamics GP has a currency revaluation process where you can calculate exchange rate gain/loss automatically. Revaluation is different from Currency Translation, which is done for financial reporting, but currency translation also is supported for Dynamics GP and Management Reporter.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    Thanks for the feedback.  That is what I have now; however some management wants an automated currency exchange gain or loss created.  

    Thank you for taking the time to respond to me.  Truly appreciated.

  • sueconrod Profile Picture
    sueconrod 335 on at
    RE: Queston on multicurrency with multiple databases. US based, one company in UK

    We have a company in the UK as well.  Everything on the company is listed as Functional and reporting UK dollars and then when we do our month end, everything is converted.  We have an average listing and a current listing (spot) for the currency which we import at every month end.  There are only a couple of things you have to setup.  Access to US$ for the UK and assign either Current or Average to every currency.  It really is not that hard a setup and this way, your UK company continues doing what they do in GBP and nothing happens until you use Management Reporter at month end.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans