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
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
Thanks!
A big yes.
Cheers!
Sanjay
Would everyone need to exit out in the same fashion?
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,
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.
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).
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
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.
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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156