Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Unchecking Vendor in P...

Unchecking Vendor in Purchase Request Resolution Locks up GP for 10-50 minutes.

(0) Share

Report

Posted on by Community Member

As seen in the image below. When this box gets unchecked it locks up GP for 10-50 minutes. This is in either GP 2013 R2 or GP 2016 R2.

8546.image001.png

When running a SQL trace it runs this query hundreds or thousands of times against different (Highlighted) users as well as some other queries:

exec DBNAME.dbo.zDP_MRP1010N_2 25,'Assembly','','01682',67394,NULL,NULL,NULL,NULL,NULL,NULL  59  DBNAME      sa

As far as we can tell these procedures are all SELECT commands with no actual database changes. If the user clicks the vendor and hits delete it is processed instantly. The issue we are having is when users scroll down the bar next to the check boxes they sometimes accidentally uncheck something and then have to sit there and wait until it finishes... doing nothing.

Any input in this would be appreciated.

Thank you,

Clark

*This post is locked for comments

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

RE: Unchecking Vendor in Purchase Request Resolution Locks up GP for 10-50 minutes.

I guess it is (another) bug in GP's code... We were quoted by our consultant to have it fixed by a 3rd party developer or we could disable the checkboxes. We are going to push for Microsoft to actually fix their broken software for a change...