This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft
Dynamics 365 Community
  • Home
    • Home
      • Sales
      • Customer Service
      • Field Service
      • Talent
      • Finance and Operations
      • Retail
      • Project Service Automation
      • Marketing
        • AI for Sales
        • AI for Customer Service
        • AI for Market Insights
        • Remote Assist
        • Layout
      • Business Central
      • General
      • Microsoft Dynamics CRM
      • Microsoft Dynamics AX
      • Microsoft Dynamics NAV
      • Microsoft Dynamics GP
      • Microsoft Dynamics SL
      • Other Products
  • GP Forum
  • Ideas
    • Community Events
    • Partner Events
    • Learning Resources
    • Documentation
    • Community Gallery
    • GP Blogs
    • Webinars
  • User Groups
    • Community News
    • Get Started
    • Introduce Yourself
      • Earn Badges
      • View Badges
      • Compete on Leaderboards
      • View Leaderboards
    • Become a Top Contributor
    • Request a New Blog
    • Provide Feedback
    • Access personal data
      • Power BI Community
      • Flow Community
      • PowerApps Community
      • Microsoft Tech Community
      • Microsoft 365
      • Azure
      • Office 365
      • Dynamics 365
      • SQL
      • Windows 10
      • Windows Server
      • Enterprise Mobility + Security
      • Power BI
      • Teams
      • Visual Studio
      • Microsoft Advertising
      • AI
      • Internet of Things
      • Azure Cognitive Services
      • Quantum
      • Microsoft HoloLens
      • Mixed Reality
      • Docs
      • TechNet
      • Developer Network
      • Windows Dev Center
      • Windows IT Pro Center
      • FastTrack
      • Partner Network
      • Solution Providers
      • Partner Center
      • Cloud Hosting
      • Education
      • Financial services
      • Government
      • Health
      • Manufacturing & resources
      • Retail
      • Security
      • Licensing
      • AppSource
      • Azure Marketplace
      • Events
      • Research
    • View Sitemap
    Sign in

    • Sign In/Sign Up
    • Home
    • Forum
    • Blogs
    • Videos
    • Experts
    • Support
    • Communities
      • Microsoft Dynamics AX
      • Microsoft Dynamics CRM
      • Microsoft Dynamics GP
      • Microsoft Dynamics NAV
      • Microsoft Dynamics SL
      • Other Products
      • Partner Community
      • Envision

    1. Home
    2. Microsoft Dynamics GP
    3. Dynamics GP Support and Services Blog
    4. Microsoft Dynamics GP 2016 - Known Upgrade Issues

    SBX - Search With Button

    ASK A QUESTION

    SBX - Finance Heading

    Microsoft Dynamics GP 2016 - Known Upgrade Issues

    Options

    • Sign In
    • Home
    • Share
      • Twitter
      • LinkedIn
      • Facebook
      • Email
      • Print
    • RSS

    Dynamics GP Support and Services Blog

    Lance Koplin Lance Koplin
    on 5 Apr 2016 1:32 PM

    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 5th, 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

    RSP - Blog Comment List

    Comments

    WindyCityGP picture
    WindyCityGP on 4/12/2016 8:26:47 AM

    Hi Lance,

    Many of these seem like "known" issues with previous upgrades, but you are still finding them with 2016 upgrades?

    bossbcs picture
    bossbcs on 5/9/2016 1:23:52 PM

    It would be nice if links were embedded in the text of article such as "Account_Framework_Validation.txt". This way reader can download relevant items from the article.

    Top Tags

    View All
    Dynamics GP Microsoft Dynamics GP GP Dynamics Dynamics GP Blogs Microsoft Dynamics GP Blogs GP 2013 GP 2010 year end Dynamics GP 2010 GP 2010 R2 payroll update Microsoft Dynamics GP 2010 Great Plains year-end YE GP2010 Year end update Year end close GP 2015 Year-End Close Upgrades Whats New GP 2013 R2 GP 2016 year end closing upgrade Dynamics GP Human Resources & Payroll Dynamics GP Human Resources and Payroll GP 10 GP 2015 R2 Dynamics Communities YEC support End of Year GP 2010 R2. BP technical GP2010 R2 Download Dynamics GP Human Resources &amp Service Pack Dynamics GP GL EOY GP SP4 release microsoft dynamics gp 10 SmartList Project PM GP 2016 R2 2016 Dynamics GP Product Recertification Dynamics Newsgroups R2 Analytical Accounting Canadian Payroll Video project accounting Dynamics GP Fixed Assets fixed asset Receivables Management workflow Dynamics Conference GP 2018 R2 GP 2018 Inventory RM Payroll Garnishments FA business portal MR ACA Purchase Order Processing word template partnersource Sales 2012 Tax tables W2 Word Templates web client Dynamics GP Integration Manager Convergence Employee Excel hotfix Feature Pack error Canada PDK Sales Order Processing BP 5.1 professional services tools library security Management Reporter Tax email New features SSRS

    SBX - Heading

    Helpful resources

    Name

    FEATURED CONTENT

    Learn all the new features in Microsoft Dynamics GP 2018 R2 and are you ready for year end. 

    Get Started with 2018 R2 | Year End Blog Series

    Name

    RELEASE NOTES

    Dynamics 365 October ‘18 release notes
    Discover the latest updates to our business applications.
    Learn more | Weekly Deployment Notes | Update Cadence Webinar

    Name

    PARTNER CONSULTING SERVICES

    Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.
    Explore service offerings

    Name

    ISV

    Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.

    ISV self-service portal

    Name

    FASTTRACK

    The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence. 

    FastTrack Program | Finance and Operations TechTalks

    SBX - Two Col Forum

    Business Applications communities

    Select Community
      • Dynamics 365 Community
      • Power BI Community
      • Flow Community
      • PowerApps Community
      • Microsoft Tech Community

    SBX - Migrated JS

    What's new

    • NEW Surface Pro 6
    • NEW Surface Laptop 2
    • NEW Surface Go
    • Xbox One X
    • Xbox One S
    • VR & mixed reality
    • Windows 10 apps
    • Office apps

    Store & Support

    • Account profile
    • Download Center
    • Sales & support
    • Returns
    • Order tracking
    • Store locations
    • Support
    • Buy online, pick up in store

    Education

    • Microsoft in education
    • Office for students
    • Office 365 for schools
    • Deals for students & parents
    • Microsoft Azure in education

    Enterprise

    • Microsoft Azure
    • Enterprise
    • Data platform
    • Find a solution provider
    • Microsoft partner resources
    • Microsoft AppSource
    • Manufacturing & resources
    • Financial services

    Developer

    • Microsoft Visual Studio
    • Windows Dev Center
    • Developer Network
    • TechNet
    • Microsoft developer program
    • Channel 9
    • Office Dev Center
    • Microsoft Garage

    Company

    • Careers
    • About Microsoft
    • Company news
    • Privacy at Microsoft
    • Investors
    • Diversity and inclusion
    • Accessibility
    • Security
    English (United States)
    • Contact Us
    • Privacy & Cookies
    • Terms of Use
    • Trademarks
    • © Microsoft 2019