HomeRecommended LinksLatest LinksTop HitsWhere's that GP Window?Contact
Home » Listing Details
Top Websites
  1. Mark Polino's DynamicAccounting.net
    Over 3700 resources listed.
  2. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 700 resources listed.
  3. Mariano Gomez at The Dynamics GP Blogster
    Over 600 resources listed.
  4. Mohammad Daoud's Dynamics GP Blog
    Over 400 resources listed.
  5. Microsoft Dynamics Partner Community Blog
    Over 400 resources listed.
  6. Dynamics GP Help
    Over 400 resources listed.
  7. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 400 resources listed.
  8. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 300 resources listed.
  9. Frank Hamelly at GP2theMax
    Over 200 resources listed.
  10. About Dynamics, Development and Life
    Over 200 resources listed.
  11. eOne Business Solutions Blog
    Over 200 resources listed.
  12. Inside Microsoft Dynamics GP Official Blog
    Over 200 resources listed.
  13. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  14. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  15. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  16. Victoria Yudin's Dynamics GP Website
    Over 100 resources listed.
    Victoria Yudin
  17. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  18. Dynamics CPM
    Over 100 resources listed.
  19. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  20. Dynamics Small Business
    Over 100 resources listed.
  21. Belinda, The GP CSI
    Over 100 resources listed.
  22. Rose Business Solutions Blog New
    Over 100 resources listed.
  23. Microsoft Dynamics GP UK Blog
    Over 100 resources listed.
  24. Leslie Vail at Dynamics Confessor Blogspot
    99 resources listed.
  25. Michael Johnson at MBS Guru
    96 resources listed.
Useful Dynamics GP Links
  1. Dynamics GP Add-On Products and ISV Solutions
  2. Dynamics GP Community Homepage - Blogs, Product Forums and Newsgroups

ID:11739
Title:Dynamics GP Multi-currency ISO Code
URL:http://dynamicsgpland.blogspot.com/2010/02/dynamics-gp-multi-currency-iso-code.html
Description:If you have ever setup Multi-Currency in Dynamics GP, you may have noticed a field called "ISO Code".

It is located on the Currency Setup window, and is a required field. So any time you create a new currency ID, you have to enter an ISO Code. Values are defined by the International Organization for Standards (ISO), and are typically three letter values, like USD, CAD, AUD, etc.

It looks like the ISO organization charges for their standards document, but Wikipedia appears to have a decent listing.

The GP Help file explains that the field is a three letter code, but in typical frustrating fashion, offers no explanation as to where or when the field value might be used.

Well, I recently had a crash course on the topic, and learned of two areas where it is used.

First, it is apparently used by FRx. In this particular situation, a client had transactions for the same currency in GP using two different Currency ID values (long story). Rather than try and convert the data so that all of the Currency ID values matched, Microsoft support offered a workaround for FRx reporting: Set the ISO codes for both currency IDs to the same value. So if Currency ID USD and Z-US$ have the same ISO code, FRx will think that the transactions / data use the same currency.

Okay, so that workaround may have solved that problem, but then we uncovered a second place where the currency ISO code is used: GP Web Services.

I've never had to do a multi-currency integration using Web Services, so I never looked at the currency fields. But if you check the help file, you will notice that GP Web Services asks for an ISO Code, and not a Currency ID for integrated transactions.

So what happens when you have two currency IDs setup in GP that have the same value for the ISO code? Flip a coin!

It appears that Web Services grabs one of the two (either randomly or based on a table index or some sort order). Needless to say this isn't a good thing. In this case, it grabbed the one currency record that did not have rate tables setup, so the web service import failed with an error explaining that it could not find a current rate.

So if you are working with Multi-Currency, you now know at least two places where the ISO code matters.

I'm sure there is plenty of history behind the addition of the ISO Code field, but at this point the documentation is minimal and the inconsistent use of currency ID vs. ISO code makes for some fun times.
Category:TIPS AND TRICKS BY MODULES: Multicurrency Management
Link Owner:
Date Added:June 17, 2010 06:14:56 PM
Number Hits:8
RatingsAverage rating: (0 votes)
Reviews

No Reviews Yet.

 
Latest links
GPWindow.com

Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.

www.saci.com
PHP Link Directory