Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Batch: " T...
Microsoft Dynamics GP (Archived)

Sales Batch: " This batch is being edited by another user " Error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hello

I've got a Sales Batch that gives  " This batch is being edited by another user "  error when tried to post.

I can see the same batch in Master Posting Window with its Status 'Busy'. and I cant click on it as it pops up an error message saying you cant change statues because someone else is editing it. but in reality no one is.

I can see the batch in SY00800 table but the user is not actually in the batch even though it shows a Username against it.

When I look in SY00500, I can see the same batch but Status is Already '0'

Now I know that clearing all locking tables will resolve the issue and will release the batch, but i believe this should be done after hours.

My Question is,

Is there anything I can do to release this batch other than waiting till everyone logs off the system?

Can I delete the line in SY00800 ? will that affect anything or resolve the issue?

Thanks

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    The suggestion to have the user that created the batch, logon, go into the batch and exit gracefully - that worked for me. Thanks.

  • Jim Schindler Profile Picture
    Jim Schindler 5 on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    Since you are confident that the user is not actively working with the batch in any way. You can delete the records. See KB article reference below.

    support.microsoft.com/.../850289

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    Hi,

    I received this SQL query from a colleague. I wish I could remember who it was so I could give them credit. It will tell you who has the record locked:

    SELECT 'Sales Documents' AS LockType

    , DexSession.sqlsvr_spid

    , ISNULL(sysproc.loginame, 'Disconnected') AS LoginName

    , SOP10100.SOPNUMBE AS SOPNumber

    , CASE SOP10100.SOPTYPE

    WHEN 1

    THEN 'Quote'

    WHEN 2

    THEN 'Order'

    WHEN 3

    THEN 'Invoice'

    WHEN 4

    THEN 'Return'

    WHEN 5

    THEN 'Back Order'

    WHEN 6

    THEN 'Fulfillment Order'

    ELSE 'Unknown'

    END AS SOPType

    , SOP10100.CUSTNMBR AS CustNumber

    FROM tempdb..DEX_LOCK DexLock

    INNER JOIN tempdb..DEX_SESSION DexSession ON DexLock.session_id = DexSession.session_id

    INNER JOIN SOP10100 ON DexLock.row_id = SOP10100.DEX_ROW_ID

    LEFT OUTER JOIN master..sysprocesses sysproc ON DexSession.sqlsvr_spid = sysproc.spid

    WHERE DexLock.table_path_name = RTRIM(DB_NAME()) + '.dbo.SOP10100'

    Kind regards,

    Leslie

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    In addition to the tables above, look for the Batch/User's record in SY00801(Resource Activity). If it is indeed a stuck record, then delete it from that table as well. This way, you won't have to wait for all users to log out of the system. Hope this helps.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    Hi,

    Thanks for sharing that...

    Rosemary

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    Hi,

    I am not sure if removing the line will resolve this, but what I have seen is if the specific user  who created the batch, logs on goes into the batch and exits properly the batch becomes available.

    Regards,

    Rosemary

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Batch: " This batch is being edited by another user " Error

    Sinnerv,

    I had a similar problem a few weeks ago and I cleared the record In SY00800 when users were still logged in.This resolved the Issue for me.

    Ponguso.

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