Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Post Payables Checks -...
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Post Payables Checks - This batch is being edited by another user...

    I've come up with a pretty precise way to remove a single (or multiple) users from these tables without having to kick everyone out of the system. Basically you can query the sp_who2 results to find the sqlsvr_spid, and then use that to remove records from the DEX_SESSION table. Check it out:

    IF NOT OBJECT_ID('tempdb..#sp_who2') IS NULL
	DROP TABLE #sp_who2
CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),
      Login  VARCHAR(255),HostName  VARCHAR(255), 
      BlkBy  VARCHAR(255),DBName  VARCHAR(255), 
      Command VARCHAR(255),CPUTime INT, 
      DiskIO INT,LastBatch VARCHAR(255), 
      ProgramName VARCHAR(255),SPID2 INT, 
      REQUESTID INT) 
INSERT INTO #sp_who2 EXEC sp_who2
SELECT      * 
FROM        #sp_who2
-- Add any filtering of the results here :
WHERE       DBName <> 'master'
-- Add any sorting of the results here :
ORDER BY    DBName ASC

DELETE
FROM TEMPDB..DEX_SESSION
WHERE sqlsvr_spid IN (
select SPID
from #sp_who2
WHERE Login IN ('tweedledee','tweedledum') )


    All the other tables besides DEX_Lock can be cleaned out using UserID

  • Suggested answer
    celh01 Profile Picture
    celh01 345 on at
    RE: Post Payables Checks - This batch is being edited by another user...

    Good Day, A batch is held in the cheque printing,  "This batch is being edited by another user. Please try later." in Microsoft Dynamics GP 2013, and I find fix  MicrosoftEasyFix50435.msito run and fix the issue. i don't know how to run this fix. Could you please help me? Thank you for your guidance and support and have a great day.

  • Syrus Profile Picture
    Syrus 4,156 on at
    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.

  • Verified answer
    bbarnard Profile Picture
    bbarnard 190 on at
    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

  • bbarnard Profile Picture
    bbarnard 190 on at
    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.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    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.

  • bbarnard Profile Picture
    bbarnard 190 on at
    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.

    4061.Capture.PNG

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    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.

  • bbarnard Profile Picture
    bbarnard 190 on at
    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?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Post Payables Checks - This batch is being edited by another user...

    Try it out now,

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans