Tuesday, August 25, 2009

Dynamics GP 10– Service Pack 4

Dynamics GP 10– Service Pack 4

Finally the wait is over; Dynamics GP 10 Service Pack 4 has been released. Service Pack 4 addresses a number of issues and delivers new features, such as International ACH Transactions (IAT) and Extender enhancement capabilities for forms and detail forms.

To learn more about the Extender functionality, check out the link Functionality for Extender in Microsoft Dynamics GP 10.0 Service Pack 4

SP4 dictionary build number is 10.00.1368, for further please do read the Installation Guide topics.

There is an issue with Service Pack 4 that changes the OLEPath in the Dex.ini to the default local path. If you use OLE Notes and have a path to a network share, make sure to review the Dex.ini at each client workstation following the hotfix installation to ensure the path is correct. This issue is currently under review for a fix release. The default location for the Dex.ini is C:\Program Files\Microsoft Dynamics\GP\Data.

You can download Microsoft Dynamics GP v10 Service Pack 4 from:

Customer Source -
Click here
Partner Source -
Click here

Thursday, August 6, 2009

Dynamics GP – Multicurrency Exchange Rate Updating Tool

Dynamics GP – Multicurrency Exchange Rate Updating Tool


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


Step 1:

we have created an excel sheet, using Data Ribbon select “From Web” query option under Get external data connection section.




Step 2:

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




Step 3:

System will start importing the exchange rate table form web site




Step 4:

Once you have downloaded the contents, now insert one VBA button using Develop ribbon in Microsoft Excel







Step 4:

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 . . .