Tag: microsoft

eOne now compatible with Microsoft Dynamics GP 2013 R2

| 06/05/2014 | 0 Comments
eOne now compatible with Microsoft Dynamics GP 2013 R2

Today is the day many of you (like us) have been looking forward to! We are excited to announce multiple product releases today, many which are needed to be compatible with the Microsoft Dynamics GP 2013 R2 release that was posted by Microsoft on May 28th. We have posted new installs of the following products: Extender 2013 (12.00.0103) – This release includes the compatibility for Microsoft

Continue Reading

Update Currency Index field across all database

| 06/05/2014 | 0 Comments
Update Currency Index field across all database

You might need to change the currency index for one of your currencies, I needed this during a consolidation project for multiple DYNAMICS databases and needed to change the currency index field for all company tables, take a look into the below script, I have used the “Information_Schema” to get all columns that are called “ CURRNIDX” and updated these using SQL Cursor, considering that I taking a backup for each table before doing the operation: DECLARE @Statement VARCHAR (8000) DECLARE @TABLENAME VARCHAR (500) DECLARE CURR Cursor FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = ‘ CURRNIDX ‘ AND COLUMN_DEFAULT IS NOT NULL OPEN CURR FETCH NEXT FROM CURR INTO @TABLENAME WHILE @@FETCH_STATUS = 0 BEGIN SET @Statement = ‘ SELECT * INTO ‘ + @TABLENAME + ‘ _BAK FROM ‘ + @TABLENAME EXEC (@Statement) SET @Statement = ‘ UPDATE ‘ + @TABLENAME + ‘ SET CURRNIDX = NEW CURRENCY ID WHERE CURRNIDX = OLD CURRENCY ID ‘ EXEC (@Statement) FETCH NEXT FROM CURR INTO @TABLENAME END CLOSE CURR DEALLOCATE CURR Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Currency Symbol is incorrect for some GP forms

| 06/05/2014 | 0 Comments

After updating the currency index field across all database, one of the users has reported that currency symbol does not match the functional currency symbol defined in the currency setup, and for some screens multiple currencies are shown as below: After looking for this I have found this in MC40000 table, the Currency ID field represents the correct functional currency but the index was referring to another currency, updating the currency index field fixed the issue. Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

| 06/05/2014 | 0 Comments

Recently I had an interesting project with one of my customers, they had the following environment: Server I: Dynamics GP 9 RTM with 14 active companies. SQL Server 2005 (Collation is Arabic_CI_AS)

Continue Reading

The path specified must be an absolute path

| 06/04/2014 | 0 Comments

Have you ever tried to install a service pack, do a ‘repair’ or uninstall the software and received this  message? KB article 974600 describes a couple of fixes, but that is probably not the problem.

Continue Reading

Dex.ini switches download link

| 06/04/2014 | 0 Comments
Dex.ini switches download link

Hi all, I just uploaded my DEX.INI switches list to the GPUG ‘Share my Code’ site.

Continue Reading

Dynamics GP 2013 R2 has been Released

| 05/29/2014 | 0 Comments
Dynamics GP 2013 R2 has been Released

It has been finally released! With a long list of enhancements and new modules, below are download links: Microsoft Dynamics GP 2013 Product Download Page  – NEW DVD is HERE ! Microsoft Dynamics GP 2013 Service Pack Page – click HERE Regards, — Mohammad R. Daoud MVP – MCT MCP, MCBMSP, MCTS, MCBMSS +962 – 79 – 999 65 85 me@mohdaoud.com http://www.di.jo

Continue Reading