WordCustomRefiner2#02b17d1e-6215-4e30-9035-1a7acd4667ee

​​​​​

Updating to Microsoft Dynamics GP 2010

Last Modified Monday, July 20, 2015
Top Solution

Download

Review this Hot Topic to prepare for the update to Microsoft Dynamics GP 2010.

On this page

Sign In Popup
Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Close

Lock Icon

The content of this page is locked.

To access this information log in to CustomerSource.

Unable to log in to CustomerSource?

Visit our CustomerSource Help Page.

Lock Icon

Your current service plan does not allow access to this information.

To learn more about Microsoft Dynamics Service Plans review our
service plan offerings.

On this page:

 

Ove​rview

It is time to start preparing for the update to Microsoft Dynamics GP 2010.  Review the information below to prepare for the upgrade to Microsoft Dynamics GP 2010.

Top

 

Up​date Paths

Updating FromPatch Requirement for the 2010 UpdateNotes

9.00.0371 (Hotfix KB ​​971017)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page

9.00.0372 (Hotfix KB 975177 & KB 977781)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0374 (Hotfix KB 978730)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0375 (Hotfix KB 980030)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0382 (Hotfix KB 983523)

2010 July Payroll Tax Update or later
(KB 983526 - Version 11.00.1307 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0385 (Hotfix KB 975706)

2010 July Payroll Tax Update or later
(KB 983526 - Version 11.00.1307 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0386 (2010 US Payroll Year End Update KB 2435593)

2010 US Payroll Year End Update or later
(KB 2435626 - Version 11.00.1585 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0386 (2010 Canadian Payroll Year End Update & 2011 Tax Update KB 2435598)

2010 Canadian Payroll Year End Update & 2011 Tax Update or later
(KB 2435622 - Version 11.00.1585 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0386 (2010 Canadian Payroll Year End Update & 2011 Round 2 Tax Update KB 2492902)

2011 Canadian Payroll Round 2 Tax Update KB 2492917 - Version 11.00.1677 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

9.00.0388 (2011 US Payroll Round 2 Tax Update KB 2477913)

2011 US Payroll Round 2 Tax Update or later (KB 2477921 - Version 11.00.1667 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 9.0 Service Pack Page 

10.00.1368 (Service Pack 4 - KB 971808)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page 

10.00.1400 (Hotfix KB 975174 & KB 977783)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1411 (Hotfix KB 978731)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1424 (Hotfix KB 980033)

Any Microsoft Dynamics GP 2010 patch can be installed prior to updating

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1441 (Hotfix KB 982415)

2010 July Payroll Tax Update or later
(KB 983526 - Version 11.00.1307 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1487 (Hotfix KB 983520)

2010 July Payroll Tax Update or later
(KB 983526 - Version 11.00.1307 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1502 (Hotfix KB 975707)

2010 July Payroll Tax Update or later
(KB 983526 - Version 11.00.1307 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1579 (Service Pack 5)

Service Pack 1 or later (KB 2249846 - Version 11.00.1524 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1634 (2010 US Payroll Year End Update KB 2435605)

2010 US Payroll Year End Update or later (KB 2435626 - Version 11.00.1585 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1634 (2010 Canadian Payroll Year End Update & 2011 Tax Update KB 2435617)

2010 Canadian Payroll Year End Update & 2011 Tax Update or later
(KB 2435622 - Version 11.00.1585 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1685 (2011 US Payroll Round 2 Tax Update KB 2477916)

2011 US Payroll Round 2 Tax Update or later (KB 2477921 - Version 11.00.1667 - English)

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1701 (2011 Canadian Payroll Round 2 Tax Update KB 2492915)

2011 Canadian Payroll Round 2 Tax Update KB 2492917 - Version 11.00.1667 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1727 (2011 US Payroll Round 4 Tax Update KB 2502038)

2011 US Payroll Round 4 Tax Update or later KB 2502043 - Version 11.00.1708 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1727 (2011 Canadian Payroll Midyear Tax Update KB 2540240)

2011 Canadian Payroll Midyear Tax Update or later KB 2549243 - Version 11.00.1752 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1757 (2011 June Hotfix KB 2552042)

2011 June Hotfix or later KB 2552044 - Version 11.00.1799 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1779 (2011 US Payroll Year End Update KB 2599501)

2011 US Payroll Year End Update or later KB 2599505 - Version 11.00.1860 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page  

10.00.1779 (2011 Canadian Payroll Year End Update/2012 Tax Update KB 2636462)

2011 Canadian Payroll Year End Update/2012 Tax Update or later KB 2636464 - Version 11.00.1860 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page 

10.00.1835 (2012 January Hotfix 2654141)

2012 January Hotfix or later KB 2654242 - Version 11.00.1914 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page 

10.00.1841 (2012 March Hotfix 2682498)

2012 March Hotfix or later KB 2682502 - Version 11.00.1935 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page

10.00.1841 (2012 Canadian Payroll Midyear Tax Update KB 2716824)

2012 Canadian Payroll Midyear Tax Update or later KB 2716822 - Version 11.00.1935 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page

10.00.1868 (2012 US Payroll Year End Update KB 2769061)

2012 US Payroll Year End Update or later KB 2769066 or later - Version 11.00.2106 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page

10.00.1868 (2012 Canadian Payroll Year End Update/2013 Tax Update KB 2769063)

2012 Canadian Payroll Year End Update/2013 Tax Update or later KB 2769064 or later - Version 11.00.2121 - English

Microsoft Dynamics GP 2010 Service Pack Page

Microsoft Dynamics GP 10.0 Service Pack Page

NOTE: There is no direct update from Microsoft Business Solutions-Great Plains 8.0 to Microsoft Dynamics GP 2010. You must update to Microsoft Dynamics GP 9.0 or Microsoft Dynamics GP 10.0 first.

 

Top

 

System Require​ments

1. Click HERE to review the Microsoft Dynamics GP 2010 System Requirements

2. Click HERE to review the Microsoft Dynamics GP 2010 Web Application System Requirements

3. Click HERE to review the Microsoft Dynamics GP 2010 Printer Compatibility

4. Click HERE to review the Microsoft Dynamics GP 2010 Feature Technology Requirements

NOTES:

1. The following are no longer supported with Microsoft Dynamics GP 2010:

a. All editions of Microsoft SQL Server 2000

​b. Microsoft Office XP and Microsoft Office 2003

​c. Internet Explorer 6.0 ​

Top

 

Update Resources

1. Click HERE to review all upgrade documentation for Microsoft Dynamics GP 2010.

2. Click HERE to download the upgrade manual for Microsoft Dynamics GP 2010.

3. Review the Known Issues list found in the manual above in Step 2.

4. If updating to Business Portal 5.0 for Microsoft Dynamics GP 2010 32bit Environments Only , click HERE to review a Hot Topic.

5. If updating to Business Portal 5.1 for Microsoft Dynamics GP 2010 x64 Environments Only , click HERE to review a Hot Topic.

6. If updating to Web Services for Microsoft Dynamics GP 2010, click HERE to review a Hot Topic.

7. Check out the Dynamics GP Support and Services Blog for the latest news!

Top



Critical Update Notes

1. **NEW**The company database upgrade appears to hang when updating with Service Pack 3 or later.
Service Pack 3 included a fix to improve performance when updating the GL30000 table. 

select distinct (a.YEAR1) AS "Re-Calculate this Year"

from SY40100 (nolock) a, GL30000 b

where b.HSTYEAR = a.YEAR1

and b.TRXDATE <= a.PERIODDT

and b.TRXDATE >= a.PERDENDT

​and b.PERIODID <> a.PERIODID


2. **NEW**Security Conversion causes the DYNAMICS database update to fail.
If the databases were migrated from Small Business Financials or if running in a multi-lingual environment, there may be extra records in the SY01000 table in each company database.  The extra records cause the security conversion to fail during the DYNAMICS database update.  The records are no longer used in Microsoft Dynamics GP 2010 and can be removed prior to the update to Microsoft Dynamics GP 2010.  Click HERE to download the MDGP2010_SecurityConversionCheck.sql script. Run the script in the SQL Server Management Studio PRIOR to updating to Microsoft Dynamics GP 2010.

If you have already attempted the update to Microsoft Dynamics GP 2010 and are in the state where the DYNAMICS database has failed, restore the DYNAMICS database to the previous release and click HERE to download the MDGP2010_SecurityConversionCheck.sql script.  Run the script in the SQL Server Management Studio PRIOR to updating to Microsoft Dynamics GP 2010.


3.  **NEW**The service running the Microsoft Dynamics Connector for CRM must be stopped prior to launching Utilities for the update.
The Microsoft Dynamics Connector for CRM installs a service called Microsoft Dynamics Adapter Service.  This service must be stopped prior to launching Microsoft Dynamics GP Utilities for the update.  At the Microsoft SQL Server, click Start, click Administrative Tools and then click Services.  Right-click the Microsoft Dynamics Adapter Service and click Stop.  Once the update is complete, the service can be started again.


4. **NEW**If you use the HRM Solution Series, Payroll Integration to Payable, Certification Manager or Employee Health and Wellness products, the latest download for these products must be installed prior to the update to Microsoft Dynamics GP 2010.
Prior to the update to Microsoft Dynamics GP 2010, download the latest release for HRM Solution Series (Product ID 1911), Payroll Integration to Payable (Product ID 4522), Certification Manager (Product ID 4933) or Employee Health and Wellness (Product ID 4955) to ensure these products are at the latest version for Microsoft Dynamics GP 9.0 or Microsoft Dynamics GP 10.0. Click HERE to download the latest releases for these products.

5. **FIXED**Potential Performance Issue when Updating the Company Database:This issue is now fixed in the Service Pack 3 (KB2672761) or any later patch.  If you have several hundred thousand records in the GL30000 table in your company database, the update to Microsoft Dynamics GP 2010 Service Pack 1 or later may take several hours to process the company database update. It is highly recommended to update to Microsoft Dynamics GP 2010 in a test environment to benchmark performance before installing in your production environment. The update may also grow the company database transaction log and the tempdb database to a proportional size of your company database (MDF) file. It is recommended to have enough free space for the company database transaction log and tempdb database to grow during this process. If you are concerned about having enough space available, click HERE to review Chapter 2 in the Upgrade Manual to calculate the spaced needed based on the size of the largest table.


6. **FIXED**SmartList Builder tables do not update correctly without the June 2011 Hotfix or any later patch installed.
If you are updating to Microsoft Dynamics GP 2010 and use SmartList Builder, click HERE to download and install the latest hotfix for Microsoft Dynamics GP 2010.  This hotfix fixes a critical update issue with SmartList Builder.  The hotfix must be installed prior to launching Microsoft Dynamics GP 2010 Utilities.


7. **FIXED**Electronic Funds Transfer for Payables Management:This issue is now fixed in the 2011 US Round 2 Payroll Tax Update (KB2577921) or any later patch.  Click HERE to download the latest patch release for Microsoft Dynamics GP 2010. If electronic funds transfer payables payments exist in Microsoft Dynamics GP 9.0 that have not been generated to an electronic funds transfer file, the update to Microsoft Dynamics GP 2010 will fail on the CM20202 table. It is recommended to generate the electronic funds transfer file for all electronic funds transfer payables payments prior to updating to Microsoft Dynamics GP 2010. To determine if you have this situation, go to Tools, click Setup, click Purchasing, click Electronic Funds Transfer and then click EFT File Generation. The records that exist in this window have not had the electronic funds transfer file generated. Please click the checkbox next to each record and generate the electronic funds transfer file. Make sure to check all checkbooks that are setup for EFT transactions. Once the EFT file(s) have been generated, you can submit the file(s) to your bank if appropriate or save them to a file for later use.


7.**FIXED**Performance Issue with the Security Conversion During DYNAMICS database update.This is an issue with the security conversion and is fixed in the 2010 Canadian Payroll Year End Update/2011 Tax Update KB 2435622 or any later patch. Click HERE to download the latest patch release for Microsoft Dynamics GP 2010. If you are updating from Microsoft Dynamics GP 9.0, you may experience slow performance when updating the DYNAMICS database if you have several users and several companies. The DYNAMICS database update may appear to hang on the "Updating Table Company Master". ​

Top

 


Fix It KnowledgeBase Articles

Fix It KnowledgeBase Articles are designed to provide a quick resolution for issues encountered by providing an installation that can be run from the KnowledgeBase Article to fix the issue encountered.

1. Fix It KB 2564486 - Error message when you update to Microsoft Dynamics GP 2010: "[Microsoft][SQL Server Native Client 10.0][SQL Server]Violation of PRIMARY KEY constraint 'PKUPRXXXXX'. Cannot insert duplicate key in object 'dbo.UPRXXXXXX'" ​

Top

 

Service Pac​k Downloads

1. Click HERE to download the latest patch release for Microsoft Dynamics GP 2010.

2. Click HERE to download the latest patch release for Microsoft Dynamics GP 10.0.

3. Click HERE to downl​oad the latest patch release for Microsoft Dynamics GP 9.0.​

Top

 


Update Sup​​portability

1. Microsoft Dynamics Technical Support can assist with upgrades from a supported version according to the Microsoft Product Lifecycle Policy to a supported version according to the Microsoft Product Lifecycle Policy. For example, Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010.

2. Microsoft Dynamics Technical Support can assist with upgrades from a non-supported version according to the Microsoft Product Lifecycle Policy to a supported version according to the Microsoft Product Lifecycle Policy. For example, Microsoft Business Solutions-Great Plains 8.0 to Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010.

3. Microsoft Dynamics Technical Support cannot assist with upgrades to a non-supported version according to the Microsoft Product Lifecycle Policy even if the end result is a supported version. For example, Microsoft Business Solutions-Great Plains 6.0 to Microsoft Business Solutions- Great Plains 7.5 or Microsoft Business Solutions-Great Plains 7.5 to Microsoft Dynamics GP 9.0.

4. Upgrade services through Advanced Product Support Services are not available when the end result is a non-supported version according to the Microsoft Product Lifecycle Policy. For example, Microsoft Business Solutions-Great Plains 6.0 to Microsoft Business Solutions- Great Plains 7.5 or Microsoft Business Solutions-Great Plains 7.5 to Microsoft Dynamics GP 9.0. If you have any questions regarding upgrade services, please reach out to your Microsoft Dynamics GP Partner and ask that they open up an Advisory Services Request with Microsoft for you.

5. Upgrade services through Advanced Product Support Services are available for upgrades to a supported version according to the Microsoft Product Lifecycle Policy. For example, Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 10.0 or Microsoft Dynamics GP 9.0 to Microsoft Dynamics GP 2010 or Microsoft Business Solutions-Great Plains 6.0 to Microsoft Dynamics GP 2010. If you have any questions regarding upgrade services, please reach out to your Microsoft Dynamics GP Partner and ask that they open up an Advisory Services Request with Microsoft for you.


6. Due to the length and potential complexity of upgrade cases, the following protocol is used to divide upgrade issues into separate technical support cases.

1. Case 1 - Pre-Upgrade Question

2. Case 2 - Installing Microsoft Dynamics GP and running the upgrade in Microsoft Dynamics GP Utilities on the company databases and the modified forms and reports.

3. Case 3 - A potential issue in Microsoft Dynamics GP following the upgrade.

NOTE: If the technical support cases were for a test upgrade and assistance is required for the live upgrade, a new case will need to be created to troubleshoot the issues for the live upgrade.   

NOTE:  The above breakdown of Upgrade Cases still requires us to align with our overall policy of the definition of a support incident which can be found at the following location:

What is a "Support Incident"? ​

Top

 


Support Information

Once you update to Microsoft Dynamics GP 2010 and need assistance, please have the following items available before contacting Technical Support to assist in the troubleshooting process.

1. A Dexsql.log that traced the update process.

​If a Dexsql.log was not created, please refer to Knowledge Base Article 850996 for the steps to create a Dexsql.log.

2. The results of the following script executed in Query Analyzer or the SQL Server Management Studio. The results of this script will list all tables that failed during the table conversion process.

SELECT b.fileOSName, a.fileNumber, a.PRODID, a.Status, a.errornum, a.errordes, c.CMPANYID, c.INTERID

FROM DYNAMICS.dbo.DU000030 a

JOIN

DYNAMICS.dbo.DU000010 b

ON a.fileNumber = b.fileNumber

AND a.PRODID = b.PRODID

JOIN

DYNAMICS.dbo.SY01500 c

ON a.companyID = c.CMPANYID

​WHERE (a.Status <> 0 or a.errornum <> 0) and a.Status <>15

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.


You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.
Partners - Global Support Contacts (requires PartnerSource login)
Customers - Global Support Contacts 

Top

http://mbsauthor.partners.extranet.microsoft.com/sites/CSGP/northamerica/Support/Pages/HOTTOPIC_MDGP2010_Update.aspx
No
GP 2010