Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Dynamics GP Multi-Currency distributions within the same company transactions ?

Posted on by 9

Hello GP Users,

We are currently using Dynamics GP 18.4.1361. I have been asked by our management to find out if it is possible to implement Multi-Currency within the same company in GP. In other words we would like to create transactions with distributions pointing to multiple currencies, is it possible ? Based on my research i found that we can have multi currency transactions as part or "Inter Company Process" but i couldn't find any information within the same company. Also, As per below screenshot of Currency Setup window there is "Accounts" option, what exactly that Accounts option does ? Is that ok if i can setup different accounts with different currencies in below mentioned Currency Setup window ?

I know i am asking very high level question but if anyone can provide details about how can we post transactions in GP using multiple currency distributions that will be great. Thanks in advance for your help.

pastedimage1683327109576v2.png

Categories:
  • Preetham theGP Profile Picture
    Preetham theGP 9 on at
    RE: Dynamics GP Multi-Currency distributions within the same company transactions ?

    Thanks again for your help Cheryl, apparently we are not moving forward with Multi-Currency because of uncertainty of GP existence as we need to implement this in new system anyway.  

  • Verified answer
    RE: Dynamics GP Multi-Currency distributions within the same company transactions ?

    When you activate Multi-currency, it will prompt you to run check links, and that process will put the functional currency ID on all 'existing' transactions (work/open/history) in all modules.. 

    All GL accounts automatically have access to the functional currency ID.   You only grant access for GL accounts to 'other' additional currency ID's.

  • Preetham theGP Profile Picture
    Preetham theGP 9 on at
    RE: Dynamics GP Multi-Currency distributions within the same company transactions ?

    Hello Cheryl,

    Thanks for your response, this definitely helps to move forward however i have couple of follow up questions,

    --> When you said "all documents hit GL in your functional currency.    The 'ACCOUNTS' button on the currency setup window, allows you to mark what GL accounts you can use that currency ID with."  does that mean the accounts which have been setup to use difference currency than the original functional currency will be posted in the currency which they have been setup with ? or they will still be posted in functional currency as you mentioned in your response ?

    --> When you said "For example, for a single vendor, you could key one invoice in US$ and the next invoice in Canadian dollars.  So the currency ID is per transaction and not 'per distribution'" , As i understood this is all being done as part of Vendor setup however if i change currency option now what will happen to all historical transactions for that vendor ?

    Again, thanks in advance for your help.  

  • Verified answer
    RE: Dynamics GP Multi-Currency distributions within the same company transactions ?

    Yes, you can enable Multi-Currency on any existing company.  You would have to grant access to the additional currency ID's to the company, the user and the GL accounts used, and then the users can key any documents in any currency ID they have access to.   For example, for a single vendor, you could key one invoice in US$ and the next invoice in Canadian dollars.  So the currency ID is per transaction and not 'per distribution'.   All the distribution entries will be in the same currency for the same document.  However, all documents hit GL in your functional currency.    The 'ACCOUNTS' button on the currency setup window, allows you to mark what GL accounts you can use that currency ID with.  (Conversely, under Cards | Financial | Account, there is also a CURRENCY button where you can add the currency ID to the GL account there as well.)  Here are 3 more resources you can use to find out about setup:

    RESOURCS:

    • System setup checklist for Multicurrency Management in Microsoft Dynamics GP

    support.microsoft.com/.../858556

    •  How to set up a company in Multicurrency Management in Microsoft Dynamics GP

    support.microsoft.com/.../858730

    community.dynamics.com/.../multicurrency-should-i-enable-it

    NOTE: Should I still activate MC if I do not need to use other currency ID's?   Yes, it is recommended.   All new features in GP would have only been tested with MC enabled, so we encourage all users to enable MC, whether you will be using it or not.   If you will not be using it, you can grant access to the functional currency ID only for users, so they are only allowed to use one currency.  You don't need to set up any exchange rate tables for the functional currency ID so the setup is minimal.  And there is no risk of using other currency ID's if the user does not have access to it, so the users would not know the difference (i.e. if MC is enabled or not).  

    Hope that helps,

    Cheryl

    Microsoft Dynamics GP Support

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

Product updates

Dynamics 365 release plans