Post Payables Checks - This batch is being edited by another user...

(0) Share

Report

Posted on by bbarnard

190

When we try to open a check from the Post Payables Checks window we get the error "This batch is being edited by anohter user. Please try later." How do I remove the lock on it? I have tried this solution with no success.

"At the end of the day when no one is in GP, go into SSMS and run
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB.DEX_SESSION
This will clear all temporary work and should clear the session that has a lock on this transaction."

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (1)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

Have you tried the "Clear Batch Activity Utility", it might be helpful. Check it at the following link in Customer Source;

Clear Batch Activity

Was this reply helpful? Yes No
bbarnard 190 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

Where is the clear batch activity? The link is not working in your post.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

Try it out now,

Was this reply helpful? Yes No
bbarnard 190 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

The link worked, but it doesn't see my ODBC connection. I did the check for updates and it looks like it for GP 2010. We are running 2013.

Do you know which table in SQL that it is looking for?

Was this reply helpful? Yes No
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

The problem might be associated with the batch rather than the transaction, therefore, the utility clears not only the tables you mentioned above, but updates the SY00500 to set both fields (MKDTOPST, BCHSTTUS) as zero in order to release the batch.

Was this reply helpful? Yes No
bbarnard 190 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

I guess I will need to open a support case. I found a post earlier about clearing it out in the SY00500 table. There is no data in my table to remove. Here is a screen shot of the error when I try to post the check. I have also included a screen shot of when I try to open it in Payables Batch Entry.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

There was a typo in the script. Try running what is above with everyone out of GP. The double period was missing in the DEX_SESSION line.

Was this reply helpful? Yes No
bbarnard 190 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

I tried it with the extra period in it the first time. I ran it again just to make sure. There is still no change. Thanks for the replys. I am going to open a support case. I will post the resolution if I get one.

Was this reply helpful? Yes No
Verified answer

bbarnard 190 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

I found this article under the open a support case menu. It lists the steps above. I realized that I was looking at the wrong database when editing the batch in SY00500.

mbs2.microsoft.com/.../KBDisplay.aspx

Was this reply helpful? Yes No
Syrus 4,156 on at

Like (0)

Report

RE: Post Payables Checks - This batch is being edited by another user...

Anyone knows if there will be another amicable solution to fix these issues dynamically and on the fly?

In todays age there is no way, to get everyone out of GP or wait for a day and then process this kind solutions.

Was this reply helpful? Yes No