Microsoft Dynamics GP Year End Release 2011 - Install and Upgrade Tips and Tricks

  • Article

The payroll year end update is a key component to the year end process. It is very important to ensure the payroll year end install and upgrade goes as smooth as possible.  Review the install and upgrade tips below to ensure your payroll year end update installation is successful!

 

Install and Upgrade Overview

1. The 2011 payroll year end release is only available for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010.

2. The Microsoft Dynamics GP 10.0 release is an EXE file. If you would like to push the update out to client workstations, the MSP for Microsoft Dynamics GP 10.0 can be downloaded from the link below:

https://mbs.microsoft.com/customersource/downloads/servicepacks/MDGP10_FAQNewPatchProcess

3. The Microsoft Dynamics GP 2010 release is an MSP file.

4. All MSP and EXE files are cumulative. All prior service packs, hotfixes, compliance, and year end updates are included in the most recent release.
a. For example, Service Pack 2 is included in the most recent update for Microsoft Dynamics GP 2010.

5. The update must be installed at all servers and workstations that have a Microsoft Dynamics GP installation otherwise a version error will occur when launching Microsoft Dynamics GP.

Pre-Install and Upgrade Tips

1. Backup the DYNAMICS database and all company databases prior to installing the year end update.

2. Export all modified reports and forms to package files.   (Microsoft Dynamics GP | Tools | Customize | Customization Maintenance).

3. Make a backup copy of the modified reports and forms .DIC files.  Refer to the Dynamics.set file for the path to the modified .DIC files.

4. Configure a test environment to test the upgrade prior to installing in the live environment.

Install and Upgrade Tips
1. The user running the MSP or EXE update must have local admin rights on the workstation or server operating system.

2. When installing the update at the first machine, there are two components to the installation:
a. Upgrade the application install
b. Upgrade DYNAMICS and all company databases in Microsoft Dynamics GP Utilities

3. Typically, the update is installed at the SQL Server first to upgrade the databases in Microsoft Dynamics GP Utilities.

4. Verify the Microsoft Dynamics GP installation used to upgrade the databases includes all additional product installations.  For example, if Project Accounting is used, verify that Project Accounting is installed at the machine where running Microsoft Dynamics GP Utilities for the database upgrade.

5. If the installation of the MSP or EXE fails, refer to the Windows Installer Log or Windows Event Viewer for more information. Refer to KB 2545723 for steps to create a Windows Installer Log.

KB 2545723 - How to Capture a Windows Installer Log
support.microsoft.com/kb/2545723

6. Open the Windows Installer Log in a text editor and search for “Return Value 3” to find the failure location in the log.

7. If the installation of the MSP or EXE fails, try installing via the command line. Refer to
KB 912997 #13 for steps.

KB 912997 - Frequently Asked Questions about the Windows Install MSP files for Microsoft Dynamics GP
support.microsoft.com/kb/912997

8. Enable a Dexsql.log prior to upgrading the databases in Utilities. If an error occurs during the database upgrade, the Dexsql.log can be used to troubleshoot the issue.  Refer to KB 850996 for steps.

KB 850996 - How to Enable a Dexsql.log
support.microsoft.com/kb/850996

9. If the database upgrade fails, do not restore the databases as all troubleshooting can take place at the point of failure.

10. If a red X appears next to the company name in the Update Company window, the table conversion failed. Refer to the Support Information Section of the Upgrade Hot Topic for troubleshooting steps.

Microsoft Dynamics GP 2010 Upgrade Hot Topic
https://mbs.microsoft.com/customersource/support/selfsupport/hottopics/hottopic_mdgp2010_update.htm?printpage=false
https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/hottopic_mdgp2010_update.htm?printpage=false

Microsoft Dynamics GP 10.0 Upgrade Hot Topic
https://mbs.microsoft.com/customersource/support/knowledgebase/hottopics/hot_topic_updatingmicrosoftdynamicsgp10.htm?printpage=false
https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/Hot_Topic_UpdatingMicrosoftDynamicsGP10

11. All modified reports and form dictionaries must be upgraded using the Update Modified Forms and Reports process at the Additional Tasks window in Microsoft Dynamics GP Utilities.

12. If all modified reports and form dictionaries are shared, only upgrade the dictionaries once.

13. The MSP file can be pushed out to client workstations using Automatic Client Update, Group Policy or other mass deployment tools.

Post-Install and Upgrade Tips
1. Backup the DYNAMICS database and all company databases following the upgrade.

2. Export all modified reports and forms to package files following the upgrade. (Microsoft Dynamics GP | Tools | Customize | Customization Maintenance).

Assistance for the Year End Install and Upgrade
1. Microsoft Dynamics GP Blog
blogs.msdn.com/b/dynamicsgp/

2. Microsoft Dynamics Community https://community.dynamics.com/product/GP/default.aspx

3. Microsoft Dynamics Support https://mbs.microsoft.com/support/newstart.aspx

If you are creating a case with the Technical Support Team, please refer to the routing below to ensure you are routed to the correct Professional for assistance.
1. Assistance with the install of the MSP or EXE
a. Support Topic Selection: System and Security Setup, Installation, Upgrade and Migrations
b. Sub-topic Selection: System Installation

2. Assistance with the database or report/form upgrade in Microsoft Dynamics GP Utilities
a. Support Topic Selection: System and Security Setup, Installation, Upgrade and Migrations
b. Sub-topic Selection: System Upgrade

3. Assistance with installing the tax table update in Microsoft Dynamics GP
a. Support Topic Selection: Payroll
b. Sub-topic Selection: Payroll Tax Update

4. Assistance with Payroll-specific issues related to the Year End release and procedures
a. Support Topic Selection: Payroll
b. Sub-topic Selection: Year End Procedures

KnowledgeBase Articles and Resources
1. 2011 U.S. Payroll Year End Update for Microsoft Dynamics GP 2010 Download Page
https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye2010.htm?printpage=false
https://mbs.microsoft.com/partnersource/downloads/taxupdates/usgpye2010.htm?printpage=false

2. 2011 U.S. Payroll Year End Update for Microsoft Dynamics GP 10.0 Download Page
https://mbs.microsoft.com/customersource/downloads/taxupdates/usgpye10.htm?printpage=false
https://mbs.microsoft.com/partnersource/downloads/taxupdates/usgpye10.htm?printpage=false

3. Microsoft Dynamics GP 2010 Upgrade Hot Topic
https://mbs.microsoft.com/customersource/support/selfsupport/hottopics/hottopic_mdgp2010_update.htm?printpage=false
https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/hottopic_mdgp2010_update.htm?printpage=false

4. Microsoft Dynamics GP 10.0 Upgrade Hot Topic
https://mbs.microsoft.com/customersource/support/knowledgebase/hottopics/hot_topic_updatingmicrosoftdynamicsgp10.htm?printpage=false
https://mbs.microsoft.com/partnersource/support/selfsupport/hottopics/Hot_Topic_UpdatingMicrosoftDynamicsGP10

5. KB 2545723 - How to Capture a Windows Installer Log
support.microsoft.com/kb/2545723

6. KB 912997 - Frequently Asked Questions about the Windows Install MSP files for Microsoft Dynamics GP
support.microsoft.com/kb/912997

7. KB 850996 - How to Enable a Dexsql.log
support.microsoft.com/kb/850996

 

Enjoy!

Kelly Y.