Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GP 2013 HR and PR Suite DU Upgrade Issues

Posted on by Microsoft Employee

Have an GP 10 version that was upgraded to GP 2013 before the four dictionaries associated with the HR/PR Suite - 1911, 4933, 4955, and 4522 had the hotfix applied. Those modules were not installed on the GP 2013 upgrade which would have failed but the client now wants to add them back and running into the DU upgrade failure. Would anybody know the tables, or quick scripts to drop for those four products to get it to reload empty tables?

*This post is locked for comments

  • RE: GP 2013 HR and PR Suite DU Upgrade Issues

    You can use the following scripts which will start over for these modules:

    USE DYNAMICS

    drop table APR000020

    delete DYNAMICS..DB_Upgrade where PRODID = 1911

    delete DYNAMICS..DB_Upgrade where PRODID = 4522

    delete DYNAMICS..DB_Upgrade where PRODID = 4933

    delete DYNAMICS..DB_Upgrade where PRODID = 4955

    /*Run the following on the company databases*/

    DROP TABLE APR_PIP40100

    DROP TABLE PTO00100

    DROP TABLE CLM40600

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

Product updates

Dynamics 365 release plans