Microsoft Dynamics GP 2016 - Known Upgrade Issues

With the new release of Microsoft Dynamics GP 2016, we want to make sure we are sharing any known issues that we run into with the upgrade of the new release so that you can be the most prepared for your upgrade. 

We do have great documentation on the known upgrade issues list in the Microsoft Dynamics GP 2016 Upgrade Manual. Again, it is very important to review the known issues prior to upgrading to accomplish a successful upgrade.  Along with reviewing the known issues prior to upgrade, it is always recommended to perform a test upgrade to insure that you will have minimal downtime when it comes time for your production upgrade.

 We currently have the following known upgrade issues for Microsoft Dynamics GP 2016 as of April 5^th, 2016:

1. Account Framework Table Conversion:  We convert several tables that have account framework information in them.  If the account framework tables in the company database, do not match the SY003001 and SY00302 tables in the DYNAMICS database, the upgrade will fail.  Please run the Account_Framework_Validation.txt script from the Upgrade Guide to validate your tables prior to the upgrade.  If results are returned, please work with your Partner or contact Technical Support to talk about the options for those tables.  We do have other account framework tables that can be changed but these are a few of the main tables we look at when it comes to account framework. Here are the tables we convert:

GL10110
GL10111
GL70500
GL70501
GL00100
GL00201
IV70500

2. Microsoft Dynamics GP OLE Object Migration Utility: 

**This tool is provided for your convenience to assist in transferring OLE Notes over to Document Attach. Circumstances may be encountered in which this tool may not be able to convert all of your OLE Notes. In these scenarios, the notes that do not convert, will need to be manually attached in Document Attach.

3. Budget date records in Analytical Accounting: The AA Budget Tree Balance (AAG00904) table contains the records for each budget in Analytical Accounting. If there are budget date records in the AAG00904 table that do not exist in the aaDateSetup (AAG00500) table, the upgrade will fail and the following error occurs.

AAG00904 135 [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert the value NULL into column'YEAR1', table 'XXXX.dbo.AAG00904'; column does not allow nulls. UPDATE fails.

4. Database Compatibility:  If you are moving to a new SQL Server in addition to the upgrade to Microsoft Dynamics GP 2016, you can restore your databases to the new SQL Server and start your upgrade.  Please refer to KnowledgeBase Article 878449 for the steps to move to a new SQL Server.  Once the databases are restored to the new SQL Server, you must change the database compatibility. 

a. In the SQL Server Management Studio. right-click your database and click Properties.  
b. Under Select a Page on the left, click Options.
c. Change the Compatibility Level to match the version of SQL Server you are running SQL 2012 = 110, SQL 2014 = 120.

5. Purchase Order Tables: If there are detail records in the POP10110 and the POP30110 that do not have a matching header record in the POP10100 and the POP30100, the upgrade may fail on those tables.  Run the Invalid_Records_POTables.txt script from the Upgrade Guide to validate all detail records have a header record.  If results are returned, you can either remove the detail records or run checklinks in the current version you are running.

6. Server Drop Down List Blank: When launching Microsoft Dynamics GP 2016, the Server drop down list may be blank.  The Server drop down is the OBDC DSN that Microsoft Dynamics GP needs to connect to your SQL Server databases.  If the ODBC DSN is an older version or an x64 DSN, it will not show up in the list.  Please make sure you have a 32-bit ODBC DSN created using either the Native Client 10.0 or Native Client 11.0 driver. Click HERE for the steps to setup an ODBC DSN.

7. Workflow Documents Must be Final Approved: If you use our Workflow for GL/PM/RM batches, Purchase Orders, Vendor Approvals, Credit Limit Overrides, Sales Quotes. Employee Onboarding, etc., all Workflow Documents must be final approved prior to the upgrade.  No documents can be pending.  The upgrade does check for this and will stop Utilities and provide a report showing what documents need to be approved.

8. Microsoft Dynamics Adapter Service: If you use the CRM Connector for Microsoft Dynamics GP and the Microsoft Dynamics Adapter Service is running on the server where you are performing the upgrade, please stop the service temporarily.  Once the upgrade is complete, the Microsoft Dynamics Adapter Service can be restarted.

9. Professional Services Tools Library: If you receive an invalid version error on PSTL (Professional Service Tools Library), you will need an updated version of PSTL for GP 2016.  Download soon to come (Partner Only).

10. Microsoft Dynamics GP Utilities Stops Responding: When you launch Utilities for the upgrade, most of the processing is done on the SQL Server.  If you happen to client away, Utilities may appear to stay white and show "not responding".  Please do not close out of Utilities, the upgrade is still running.  Please give the upgrade time to continue working.  If you feel the upgrade is hanging or locked up, please start a SQL Server Profiler trace to review activity.

11. Overlapping Fiscal Periods:  When you launch GP Utilities to start the upgrade, if you have overlapping fiscal periods, it will hang on the Multicurrency Setup Master Table.  Run the scripts below to determine if you have overlapping fiscal periods and correct the periods prior to starting the upgrade process.

-- Show overlapping Periods
SELECT distinct a.YEAR1, a.PERIODID, a.PERIODDT, a.PERDENDT
FROM SY40100 a JOIN SY40100 b
ON  a.PERIODID<>b.PERIODID
AND a.PERIODDT <= b.PERIODDT
AND a.PERDENDT >= b.PERIODDT
AND (a.PERIODID <>0 AND b.PERIODID <>0)
order by YEAR1, PERIODID

Please review the known issues above prior to your Microsoft Dynamics GP 2016 upgrade!  Going through the information will help alleviate any known issues that you may run into!  Also, remember to always run a test upgrade first!

Be sure to check back to Microsoft Dynamics GP 2016 Upgrade Blog Series Schedule page to review upcoming blog posts related to Upgrading Microsoft Dynamics GP and other helpful resource links.

Thanks,
Lance Koplin | SR Support Engineer | Microsoft Dynamics GP