PO Being Edited by Another User?

(0) Share

Report

Posted on by Community Member

When I enter a PO number in the Edit PO Status window, I get a message indicating the PO is being iedited by another user . . .I have checked woth everyone, but no on has the PO open in any module . . how do I chek to see which user GO thinks is editing the PO?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: PO Being Edited by Another User?

Check this KB -support.microsoft.com/.../859601

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Being Edited by Another User?

Seems like a bit of an arduous process . .

Can't I simply navgiate to a screen somewhere in GP that would tell me which user GP thinks is currently "editing" the PO in question?

I could them just have that use log out . .see if that takes care of the issue?

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: PO Being Edited by Another User?

Within Dynamics GP, you can check the user activity from Tools > Utilities > System > User Activity. Although, it doesn't provide much details except for the User_ID, Company, Date and Time.

In order to check which user is editing the requested PO number, please run the following scripts on you Dynamics DB;

SELECT * FROM DYNAMICS..SY00800 WHERE TRXSOURC = 'Purch. Order Entry'

SELECT * FROM DYNAMICS..SY00801 WHERE RSRCID = '#PONUMBER'

If the user were idle for a long time but still locking the PO number, you can easily delete the session from the Window mentioned above. Otherwise, you can simply contact the user to log out and release the requested purchase order.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

RE: PO Being Edited by Another User?

Mahmoud provides sound advice if you want to determine which user has the record locked. However, sometimes a record gets locked even though no users are in GP.

There are no windows in standard GP that tell you who has a record locked. Another option would be to log in to GP as 'sa' and boot all the users out of the system from the User Activity window. That's still no guarantee that the record will be unlocked, hence, the sure fire resolution is to follow the KB article.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Being Edited by Another User?

Dear Mahmoud,

Thank you for your help I first tried to delete the user from the window mentioned above but it did not work so I opened an SQL query and deleted the activity at

SELECT * FROM DYNAMICS..SY00801 WHERE RSRCID = '#PONUMBER'

Was this reply helpful? Yes No
Suggested answer

MK 480 on at

Like (0)

Report

RE: PO Being Edited by Another User?

SELECT * FROM TEMPDB..DEX_LOCK

Goto the results and find the dexterity number in the “row_id” column.

Get the “session_id” number from the row you find it in.

Run:

DELETE TEMPDB..DEX_LOCK where session_id= 'xxxxx'

Was this reply helpful? Yes No
Steve Bauman 10 on at

Like (0)

Report
RE: PO Being Edited by Another User?

I was able to resolve this in my environment by first locating the user which has the PO open through the following query:

SELECT * FROM DYNAMICS..SY00801 WHERE RSRCID = 'POXXXXXX'

Which then returns the USERID column containing the users ID that has the PO open.

I then made sure the user wasn't logged in and removed the user from the Dynamics User Activity window inside of Dynamics GP.

Then I ran the following queries:

delete from DYNAMICS..SY00800 where USERID = 'my-user-id';
delete from DYNAMICS..SY00801 where USERID = 'my-user-id';

Afterwards, the other user attempting to access the PO was able to do so. I didn't have to get everyone to sign out of GP to resolve this issue.

Was this reply helpful? Yes No