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
|
More Posts By RSM US LLP
- Creating A Unified Experience Across Channels With Dynamics 365 Retail
- White Paper: Spend Visibility and Shared Services, Strategies to Address Growing Pains for Care Organizations
- What a Microsoft Dynamics AX ETL Tool Can Do for Your Implementation
- Video: US Based Manufacturer Implements Microsoft Dynamics AX for Global Operation
- New White Paper – Apples to Apples: Comparing ERP Costs Accurately
Related Posts
- Making It Easier with Dynamics GP – Quickly Modify Your Chart of Accounts
- Recommendations for a Backup Policy for Microsoft Dynamics GP
- Make your Accounting Department More Efficient with Microsoft Dynamics GP
- Adding Filters to Microsoft Dynamics GP Excel Reports
- How To: Create Custom Themes to Help Organize Dynamics GP
