Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

Posted on by Microsoft Employee

We recently upgraded to client from GP 2013 to GP 2013 R2.  When going into the navigation lists for purchasing I noticed under the two updated/added modules of purchase order transactions and purchase requisition transactions that the "not submitted" and "pending approval" lists are listed multiple times (six in total) for each. The first purchase orders pending approval list does not contain the new workflow ribbon for approval actions. The second purchase orders pending approval list does and the four below it do as well.

Is this a known issue? Does anybody know how to remove these?

*This post is locked for comments

  • Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    We would need to know what list(s) you are seeing the duplicates on in order to send the appropriate script(s) to remove the duplicates.  Your screenshot seems to show Purchase Requisitions, but the issue could happen in any Nav List where Workflow lists exist.

  • manolo Profile Picture
    manolo 97 on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    what list Lucas, you mean Dynamics users?

  • Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    Manolo,

    Applying the fixes included in the latest patch for GP 2013 is going to be the preferred method, but I understand if you can't do that just now.  You'll want to open a support case, reference this article and provide the lists where you are seeing duplicates and we can send out the script(s).

  • manolo Profile Picture
    manolo 97 on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    Lucas you had mention that you have a script to remove the duplicate Views under the Navigation Lists from the tables. I would be interested in acquiring that script. We run 12 databases from a sql 2012 DB server and 3 RDP application servers, total of 215 users. We are not planning to install any service pack at the moment. We are running 12.00.1745 version.

    At this point in time the login for each user is extremely slow and I believe because of it.duplicate-views-in-navegation-screen.PNGheres is a print screen of my nav list.

    Hope you can help!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    Lucas,

    Thanks for the info!  We manually deleted them which wasn't fun, but effective. :)

  • Verified answer
    Lucas Miller Profile Picture
    Lucas Miller on at
    RE: Purchasing Navigation Lists (Not Submitted and Pending Approval) listed multiple times after GP 2013 R2 upgrade

    Hello Baratung,

    What you are describing is a known issue with the Dynamics GP 2013 R2 upgrade.  It inadvertently duplicated the Navigation Lists for the new Workflow 2.0 functionality once for every company that was upgraded rather than once for all companies.

    This has been fixed in the year-end patch for Dynamics GP 2013, so when you apply that it will clean up the duplicate values in the handful of tables they exist in.

    If you're not planning an upgrade to the year-end you can initiate a support case for your issue and we can provide you a script to manually remove these duplicates.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans