Page 4 of 11012345678910...2025303540...Last »

Author Archive

Currency Symbol is incorrect for some GP forms

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:

image

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

Visit site:
Currency Symbol is incorrect for some GP forms

June 5, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 108

Update Company ID field across all company database

A couple of weeks back I needed to consolidate two DYNAMICS databases and move companies from the first DYNAMICS to the second, this for sure requires Company IDs to be changed as it might be taken by another companies on the main DYNAMICS, to fix this once for all I have wrote the following script:

DECLARE @Statement VARCHAR(8000)
DECLARE @TABLENAME VARCHAR(500)
DECLARE CURR Cursor FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'CMPANYID' 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 CMPANYID = NEW COMPANY ID WHERE CMPANYID = OLD COMPANY ID'
EXEC (@Statement)
FETCH NEXT FROM CURR INTO @TABLENAME
END
CLOSE CURR
DEALLOCATE CURR

 

Hope that this helps.


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

View article:
Update Company ID field across all company database

June 5, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 99

Consolidating multiple Dynamics GP Companies into single DYNAMICS database

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).
  • Windows Server 2003 & FRx

Server II:

  • Dynamics GP 11 RTM with 3 active companies.
  • SQL Server 2008 R2 (Collation is Latin)
  • Windows Server 2008 & FRx

The customer simply wanted to upgrade to Dynamics GP 2013 SP2 and to SQL 2012, and also wanted to consolidate the databases into one single DYNAMIMCS database.

Challenges:

Now we have few challenges detailed below:

  1. Dynamics GP 2013 does not support upgrading from GP 9.0
  2. Dynamics GP 2013 does not support SQL 2005 and GP 9.0 does not support SQL 2012.
  3. Database collation differences between companies.
  4. Data stored in DYNAMICS database like currencies, users and BP objects.
  5. Changes that will occur on columns like “Company ID” and “Currency Index” which will be changed due to DYNAMICS data consolidation.
  6. Security migration from GP 9.0 to GP 2013.
  7. FRx migration to Management Reporter.
  8. Minimum downtime need to be maintained! 17 companies across multiple countries cannot stay down forever!

Resolutions:

Well we believe that nothing is impossible in the IT field, we have planned for everything and scheduled the upgrade process, below the steps we followed:

Server I:

  • Took a backup for all databases.
  • Upgraded from version (GP 9.00.0114) to 9.00.0371 that supports the upgrade to GP 2010 (we need GP2010 because it supports both SQL 2005 and SQL 2012!)
  • Upgrade from (GP 9.00.0114) to GP 2010 (GP 11.00.2320) that supports direct upgrade to GP 2013.
  • Moved upgraded databases from SQL 2005 to SQL 2012 with moving all users and configurations.
  • Upgraded to GP 2013 SP2.
  • Checked System stability.
  • Updated Users permissions and passwords.
  • Installed Dynamics GP 2013 with SP2 on all clients
  • Installed Management Reporter that replaces the FRx on the server and on the clients.
  • Migrated existing FRx Reports to Management Reporter
  • Activated SQL Reporting Services
  • Installed and activated Dynamics GP Web Client
  • Started the data entry!

This operation took the first weekend!

Server II:

  • Took a backup for all databases.
  • Upgraded from your current version GP to the service pack that supports the upgrade to GP 2013.
  • Upgraded to GP 2013 SP2.
  • Checked System stability
  • Created new companies on the new server
  • Restored databases from old server to PROCCOSQL over newly created databases
  • Update databases collation to match old server collation (I used the tool that updates the SQL database collation by dropping all functions, constraints and indexes that is collation dependence)
  • Updated CURRENCY ID in all databases columns to match the newly added currencies, it was indexed as “100X” and changed to “10XX”
  • Update Company ID in all databases columns to match the newly added companies.
  • Add newly created companies to Management Reporter
  • Activate SQL Reporting Services

This operation took the second weekend! Till now everything is working properly and this is how their GP looks like right now:

image


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Read More:
Consolidating multiple Dynamics GP Companies into single DYNAMICS database

June 5, 2014 ·  · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 129

Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

This morning i been working on the R2 release and been enjoying the newly added features and been playing around the newly added paste feature

Factor GP Paste DI Paste Winner
Speed (when pasting 1500 rows) 100 seconds 60 seconds DI
Data Validation Data validated No data validation Microsoft
Coverage* GL Only All forms DI
Intercompany** Not Available Available DI
Columns Order Modifications** Not available Available DI
Update Existing Journal Not available Available DI
Paste Multiple Journals** Not available Available DI
    • * All GP forms is covered in purchased version only.
    • **This feature is only currently available with purchased version, we expect this to be free soon.

Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Visit site:
Dynamics GP 2013 Excel Paste vs Dynamics Innovations Excel Paste

May 30, 2014 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 134

First look to Dynamics GP 2013 R2

I just upgraded to GP2013 R2! I liked the way the changed the “Login” form, this to apply the identity management process!

image

Next thing I liked is the new look and feel:

image


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Originally posted here:
First look to Dynamics GP 2013 R2

May 29, 2014 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 160

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

See the article here:
Dynamics GP 2013 R2 has been Released

May 29, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 99

Management Reporter CU9 does not support windows XP

One of my customers recently upgraded his environment to SQL 2012 and GP 2013 from windows 2003 and GP 9.0, upon installing Management Reporter with CU 9.0 that supports SQL 2012 I have realized that it cumulative update no longer supports windows XP, therefore I had to rollback my installation and install CU8 then re-imported my reports.

Published to let you know before planning any upgrades!


Regards,


Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Read More:
Management Reporter CU9 does not support windows XP

May 28, 2014 ·  · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 105