As new versions of Microsoft Dynamics GP are released, there are increasing points of contact between Dynamics GP and Microsoft Office. One connection that hasn’t appeared yet concerns multi-currency. However, you can simplify finding the multi-currency rates by using Microsoft Office Excel 2007 or 2010.
Dynamics GP and Microsft FRx need access to multi-currency rate tables. Instead of manually creating these tables you can use a feature in Excel 2007/2010 to pull the rates into Excel.
Open Excel. Select the Data tab. Click on the Existing Connections icon.
The Existing Connections window opens, scroll down and select the MSN MoneyCentral Investor Currency Rates connection, click Open.
Enter a location for the rate table (the current cell location will be the default), click OK
Shortly a list of currencies showing exchange rates with US dollars will appear.
| Currency Rates Provided by MSN Money | |||
| Name | In US$ | Per US$ | |
| 0.24444 | 4.091 | ||
| 1.0555 | 0.947 | ||
| 2.6487 | 0.378 | ||
| 0.14389 | 6.95 | ||
| 0.60976 | 1.64 | ||
| 1.6129 | 0.62 | ||
| 1.0228 | 0.978 | ||
| 0.00211 | 473.8 | ||
| 0.1537 | 6.506 | ||
| 0.00055 | 1823 | ||
| 0.05724 | 17.47 | ||
| 0.18884 | 5.295 | ||
| 1.4077 | 0.71 | ||
| 0.16792 | 5.955 | ||
| 0.12858 | 7.777 | ||
| 0.00521 | 191.8 | ||
| 0.02211 | 45.22 | ||
| 0.00012 | 8580 | ||
| 0.01222 | 81.84 | ||
| 1.4075 | 0.711 | ||
| 0.01154 | 86.68 | ||
| 0.00091 | 1094 | ||
| 3.6199 | 0.276 | ||
| 0.12474 | 8.016 | ||
| 0.32744 | 3.054 | ||
| 0.08532 | 11.721 | ||
| 0.17934 | 5.576 | ||
| 2.5967 | 0.385 | ||
| 0.36153 | 2.766 | ||
| 0.02302 | 43.45 | ||
| 0.01161 | 86.11 | ||
| 0.26661 | 3.751 | ||
| 0.8018 | 1.247 | ||
| 0.14259 | 7.013 | ||
| 0.15789 | 6.334 | ||
| 1.1343 | 0.882 | ||
| 0.03459 | 28.907 | ||
| 0.03285 | 30.44 | ||
| 0.71669 | 1.395 | ||
| 0.27221 | 3.674 | ||
| United States Dollar | 1 | 1 | |
| 0.23283 | 4.295 | ||
The table can be formatted or refreshed as needed.
Add a macro and a particular currency can be added to a table located elsewhere in the spreadsheet and you can track the currency on a periodic basis.
RSM has been implementing Microsoft Dynamics ERP Business Solutions for more than 30 years. Please contact us for more information on or how we can help you with .
By: Claude Frymark, RSM - Microsoft Dynamics GP Specialist
