Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum (Archive) / Upgrade from Dynamics ...
Microsoft Dynamics GP forum (Archive)
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:
Install and Upgrade
  • 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,782 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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard > Microsoft Dynamics GP forum (Archive)

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans