Microsoft Dynamics GP Year-End Release 2012: Install & Upgrade

  • Comments 5

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 2012 payroll year-end release is only available for Microsoft Dynamics GP 10.0 and Microsoft Dynamics GP 2010.  The 2012 year-end update will be automatically included in Microsoft Dynamics GP 2013 once released.

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. For example, Service Pack 3 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.  **It is highly recommended to first test the year-end update in a test 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 and all modified reports and forms 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. If a Microsoft Dynamics GP installation does not exist at the SQL Server, the databases can be updated from the first client workstation or Terminal Server.

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
http://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
http://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
http://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 Support and Services Blog
https://community.dynamics.com/product/gp/gptechnical/b/dynamicsgp/default.aspx

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. 2012 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. 2012 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
http://support.microsoft.com/kb/2545723

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

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

 

***MORE Year-End Blogs to come!!!*** 
Check out our 2012 Year-End Blog Series Schedule!

  • It is not stated in the above instructions, but Microsoft released a new tax update (Nov 6, 2012) that is required to be downloaded prior to installing the Year End updates.

  • Hi Doug, great comment.  I wil cover the series of events specific to Payroll on Thursday withe the payroll year end post.  Thanks!

  • Does the year-end update include the smartlist builder reminder hotfix? (KB 2731285)

  • Hi Steven,

    Yes, the Year End Update includes all previous service packs, hotfixes and payroll compliance updates.  This includes the hotfix for the SmartList Builder Reminder issue.  Thanks!

  • Question regarding the tax update of Nov 2012.   If a customer does the Year-End update without applying the November 2012 (round 6 or round 7), what effect will there be when Round 1 of the 2013 tax updates are applied?