Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cannot delete empty batches, "being edited by another user"

Posted on by 375

I have a handful of empty batches, all the same user, that have zero transactions, yet cannot be deleted due to the error message, "Being edited by another user." Any way to delete these?

*This post is locked for comments

  • TGcville@gmail.com Profile Picture
    TGcville@gmail.com 375 on at
    RE: Cannot delete empty batches, "being edited by another user"

    Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot delete empty batches, "being edited by another user"

    A big yes.

    Cheers!

    Sanjay

  • TGcville@gmail.com Profile Picture
    TGcville@gmail.com 375 on at
    RE: Cannot delete empty batches, "being edited by another user"

    Would everyone need to exit out in the same fashion?

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Cannot delete empty batches, "being edited by another user"

    TGcville,

    You are always welcome to ask any question, that's what the community is for ...  and I would be absolutely glad to help.

    The point I was trying to make precisely is that there is a "Microsoft - Fix it for me"  on the support article that would help you get it solved without even having to go through all this SQL codes.

    Most welcome again,

  • TGcville@gmail.com Profile Picture
    TGcville@gmail.com 375 on at
    RE: Cannot delete empty batches, "being edited by another user"

    Someone's FAQs leave more unanswered questions than one began with, especially when answers are in code, and code is a foreign language to you. I did a bit of googling and read the Microsoft pages, as well as a few threads on here, all responses I didn't understand, apologies for not checking the FAQ page here.

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Cannot delete empty batches, "being edited by another user"

    Thanks for pointing this out Mahmoud. There's a Microsoft Fix It! that is a part of the KB article Mahmoud has directed you to and this Fix It! should take care of the problem without the need of running SQL scripts (technically, it does the same in the background).

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Cannot delete empty batches, "being edited by another user"

    Nothing more valuable to add for Mr. Mariano's comments except that this must be on the top ten list of the most FAQ in Dynamics GP.

    Just to include the documentation of this error on Microsoft Support Knowledge base, Article ID: 850289

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    RE: Cannot delete empty batches, "being edited by another user"

    So long you have Microsoft SQL Server Management Studio (there's no such thing as MS SQL Exchange. There's SQL Server and then there's Exchange Server) running on a machine and can access (as in having permission) your SQL Server, you should be able to do this.

    I strongly suggest you contact your partner or get a hold of your DBA to run the above script.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot delete empty batches, "being edited by another user"

    You will need to run this scripts at SQL Server query analyzer.  You will need appropriate access and permission to execute this script.  Would recommend if you have never done this before, contact your DBA.

    Cheers!

    Sanjay

  • TGcville@gmail.com Profile Picture
    TGcville@gmail.com 375 on at
    RE: Cannot delete empty batches, "being edited by another user"

    From my reading, this would probably fix my issue, however I have no clue as to where to begin? I am an end user, not a Partner. Would this be done on the server through MS SQL exchange?

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans