Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Upgrade from Dynamics ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Upgrade from Dynamics V2016 to V2018 this weekend

(0) ShareShare
ReportReport
Posted on by Peggy Aitken 88

I'm upgrading from Dynamics GP V2016 to V2018 this weekend.  I see there was a problem with Error when opening User Access SY60101 does not exist.  If I upgrade from the latest GP V2016 sp (16.00.0864)  to the latest GP V2018 sp (18.5.1635) will I still have this problem? 

If so, at what point during the upgrade do I run the related scripts? As I understand it, I run the 1st script against the company databases and the 2nd script against the Dynamics database?

Any other tips would also be appreciated.  I used to always find the upgrade checklists with step by step info but seems those aren't available any longer.  If anyone has one I'd really appreciate if you could let me know!

Thanks,

Peggy Aitken



Categories:
Microsoft Dynamics GP
  • Peggy Aitken Profile Picture
    Peggy Aitken 88 on at
    Upgrade from Dynamics V2016 to V2018 this weekend
    Unfortunately this did not resolve my problem.  I restored back to Version 2016 until I can figure out what the problem is.  Thank you so much for taking the time to posting possible solutions!
  • Suggested answer
    Joseph Markovich Profile Picture
    Joseph Markovich 3,900 on at
    RE: Upgrade from Dynamics V2016 to V2018 this weekend

    Hi Peggy-

    Here is the note from the upgrade page on Microsoft Learn.

    4. New tables missing after upgrade to GP 18.2. Upgrading from certain builds of Microsoft Dynamics GP 2016 to Microsoft Dynamics GP (18.2) is not creating new tables. Example error you may get - Error when opening User Access SY60101 does not exist. Download and run the these scripts. Do the table script first, then the procs against the Dynamics (system) database.

    Here's the link:

    mbs2.microsoft.com/.../

    You'd run this before doing the upgrade. Otherwise, the upgrade is going to fail.

    I also have a HUGE checklist that I've relied on since my early days with GP (and have updated it throughout the years). If you'd like this blob of information, send me a note and I'll email it to you!

    Joe

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans