We came across so many requests from our customers asking for a utility which can update the exchange table in Dynamics GP on daily basis from a specific source. We have deviced a toll using Microsoft Excel spread sheet and Microsoft Data web query to achieve this
Have a look
we have created an excel sheet, using Data Ribbon select “From Web” query option under Get external data connection section.
In the new web query window, input the exchange rate source web site address and press Go. It will load the web site then select the exchange rate section table from the web site and click import
System will start importing the exchange rate table form web site
Once you have downloaded the contents, now insert one VBA button using Develop ribbon in Microsoft Excel
Right Click on the button and click view code, write the SQL query here for to import the data in Multicurrency exchange table
I hope this gives a brief idea for this tool . . .