Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

The Selected Purchase Request is being modified by another user

Posted on by

My users are getting the "the Selected Purchase Request is being modified by another user" error every now and then.  If they close out of the system and wait a while, they are able to logon and finish editing the requisition.  I found troubleshooting instructions in the REquisition Management Administrator's guide that the indicate that the domain account specified for the application pool must be set up as a Business Portal user.  I thought I did that a while back but I'm still getting this error.  Does the user also have to member of a sharepoint group?  If so, what group?  What permissions?  A user of the site collection? 

 Thanks!

*This post is locked for comments

  • Matt Olson Profile Picture
    Matt Olson 85 on at
    Re: Re: Re: The Selected Purchase Request is being modified by another user

    So far this trigger appears to have solved the issue.  Please note in our case that only one person is designated as the requisition purchaser at any given time so this works fine for us.  However if you have multiple people pushing over requisitions at one time to GP then you could have issues where duplicate PO #'s are generated for a requisition that has already been pushed over.  I haven't tested this per se to see if that is actually what happens, but it may be what occurs...

    CREATE TRIGGER MaintainClearMultiUserManagerTable ON MultiUserManager 
    AFTER INSERT 
    AS 
    delete MultiUserManager where SessionID in (select SessionID from inserted)

     Also, this is totally unsupported and may break other things, but so far for us it seems to be working.  We've tested with entering, approving, rejecting, and pushing requisitions up the approval tree without issue.

  • Matt Olson Profile Picture
    Matt Olson 85 on at
    Re: Re: Re: The Selected Purchase Request is being modified by another user

    This is a severe design flaw with the way business portal and requisition management works.  I have no idea why it doesn't detect who it is that is locked in the table and then clear it out if it is the same user that is accessing the requisition as the person who has it locked based on the MultiUserManager table.

    This data does get cleared out I think after 20 minutes, however that isn't a very acceptable proposition to 99% of companys to tell their users to wait 20 minutes and try again.  I'm investigating putting on a trigger to the MultiUserManager table to just keep it cleared out as it causes more problems then it solves.

     I have entered a feedback request to get this fixed.  Please go vote on it here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/534256/fix-issues-with-multiusermanager-table-in-requisition-management

  • Re: Re: The Selected Purchase Request is being modified by another user

    It's on server 2003.  I do think the multiusermanage table is not getting cleared.  That's the problem.  Does anyone know of a permanent fix for this problem?  Clearing the table is not something I want to keep doing on a regular basis.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: The Selected Purchase Request is being modified by another user

    What OS are you using on the server? If you are using 2000, then the application pool owner must be added manually to BP.

    Have you checked the 'multiusermanager' table in your DYNAMICS database?

    Sometimes users are not cleared from this table. Run a query against it and watch it being cleared every half hour or so. Some user may not be clearing. You can then run a delete query against the table (delete multiuser etc. where userid = '?????'.

    Other than that?

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

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