How to use multiple currencies in dynamics GP? I am unable to work on it
My requirement is i want to Convert Functional Currency into another Currency If anybody aware of it Please share to me?
*This post is locked for comments
This is from a blog post I did a while ago:
I developed my own cheat sheet / checklist for setting up the Multicurrency module. I wanted something that I could fit on a single page just to remind me of what I needed to do next.
Recently, I’ve had a few colleagues ask me whether I had some kind of easy to follow checklist and I’ve been sending them this one. It seems more and more companies are implementing multicurrency these days, so I thought I’d share it with the community. It’s not fancy, nor does it provide any explanations – but it does provide the navigation to the various widows.
I welcome your comments on ways to improve it or if you think things should be re-ordered.
|
1. Create Currency (use the ISO code for the ID, don’t use the ‘Z’ entries) |
|
2. Create Exchange Table |
|
3. Establish Rates |
|
4. Grant Company access to currency and rate table (all must exit Dynamics) |
|
5. Set Rate Types |
|
6. Set Posting Account Defaults. The system will search for an account in the order listed below. As soon as it finds one, it stops looking. If all should share the same account, enter it at the Company level. Rate Type Accounts Currency ID Company-level Posting Accounts |
|
7. Assign Currency Access to your GL Accounts. Identify which accounts should accept transactions in a foreign currency. |
|
8. Assign Currency ID and Rate Type ID to Checkbook ID |
|
9. Assign default Currency ID and Rate Type ID to appropriate Customers (or roll down from Customer Classes) and set revaluation options |
|
10. Assign default Currency ID and Rate Type ID to appropriate Vendors (or roll down from Vendor Classes) and set revaluation options |
Enjoy!
Hello George Stavropoulos
Actually I'm new to this So can you please provide me some more resources related to this and where can i see this transalations occur in GP console.
Hello Bill Campbell
Where can i see this converted currencies in dynamics GP Console and respective table names where functional currency amount and REPORTING currency amount will be stored. Actually I'm new to this So can you please provide me some more resources related to this
Hello Mallesh.
Unless you are running an extremely old version of GP multi-currency management is inherent to GP and there are three currency types you need to understand:
-Originating Currency
-Functional Currency
-Reporting Currency
Depending on the version of GP you are running you will find a view currency button or menu option which allows you to toggle back and forth between Originating or Functional currency. When you setup a GP company you need to set your functional(home) currency along with other variables such as Exchange Rates and Exchange Rate tables.
When you are entering a transaction in GP such as a JE the functional currency of that company DB will default, however you do have the option of selecting another currency which would be your originating currency. By selecting this other foreign currency GP will take into account the transaction date and select an exchange rate from the Exchange tables and then convert your currency to your home Functional currency. While in the transaction entry window you can actually toggle back and forth between the Originating and Functional currency. When the transaction is posted the Functional amount will be posted to your GL and the originating amount will be available for review in history.
When you see reference to the "Reporting" currency in GP, it allows users to enter an adhoc reporting exchange rate but this is not the amount which will be posted to your GL.
There are a lot of moving parts to MC in GP and can get even more complex if you introduce "Currency Translation" in MR.
Hope the above helps.
Reporting Currency is the currency in which you want to present Financial Statements, Reports and documents for outside consumption.
Functional Currency is the currency that you might do business with different Customers and even Vendors.
If you have international Customers you might receive payment in British Pounds, Hong Kong Dollars, US Dollars - those would be the functional currency of the customer. All of those currency amounts has to be converted to a single REPORTING currency.
Hope this helps - with the definition of the two.
Hi Almas Mahfooz,
Actually I'm not understading the difference between functional currency and reporting currency.
And Here Functional currency is converted to reported currency but how to check that functional currency is converted or not in dynamics gp.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (