Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

UPGRADE DYNAMICS GP2015 RTM TO 2016 R2

Posted on by 385

[View:/cfs-file/__key/communityserver-discussions-components-files/32/sql.mp4:320:240]

I am facing sp execution error during run GP Utilities. Can anyone please guide me what should I do?

Thanks in Advance.

Categories:
  • Jozy Profile Picture
    Jozy 385 on at
    RE: UPGRADE DYNAMICS GP2015 RTM TO 2016 R2

    Derek Albaugh,

    Thank you for your prompt response you just solved my problem..:)

    Thanks Again.

  • Verified answer
    RE: UPGRADE DYNAMICS GP2015 RTM TO 2016 R2

    In SQL Server Mgmt Studio, if you right-click on the table, then choose 'Script Table As' > 'CREATE To' > 'New Query Editor WIndow', which will write the table script in the query window, then you'll need to either change or remove the top two lines which will usually reference to use the database you took the script from, so we can run it against the company database that needs the table.

  • Jozy Profile Picture
    Jozy 385 on at
    RE: UPGRADE DYNAMICS GP2015 RTM TO 2016 R2

    Hey, Derek Albaugh

    Thank you for your writing, I can see that table in other company database but I am not well aware to sql server can you please guide how can I script out that table in other company.

    Thanks..:)

  • Verified answer
    RE: UPGRADE DYNAMICS GP2015 RTM TO 2016 R2

    It appears that company database is missing the PA00001 table, which is the Customer Vendor Master table, and has existed since at least GP 2010, so if you're coming from GP 2015, it should exist in that company database.

    If you have it in another company database, just script it out and run it in this company database to create it, then launch GP Utilities again to continue the upgrade.

    Thanks

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans