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

Question Status

Verified
Beratung asked a question on 3 Feb 2015 2:43 PM

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?

Reply
Verified Answer
Lucas Miller responded on 9 Feb 2015 4:51 PM

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.

Reply
Beratung responded on 9 Feb 2015 5:07 PM

Lucas,

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

Reply
manolo responded on 9 Aug 2016 3:59 PM

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. heres is a print screen of my nav list.

Hope you can help!

Reply
Lucas Miller responded on 9 Aug 2016 4:07 PM

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).

Reply
manolo responded on 11 Aug 2016 8:33 AM

what list Lucas, you mean Dynamics users?

Reply
Lucas Miller responded on 11 Aug 2016 9:01 AM

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.

Reply
Verified Answer
Lucas Miller responded on 9 Feb 2015 4:51 PM

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.

Reply