40
I have a batch within the General Ledger that I can not post or delete. I'm looking to delete the entire batch and I it won't come up in the Batch Recovery window either. Pull up the Batch screen, the status of the Batch says "Printing" and if I try and select the Batch to delete it says "This batch is being posted."
Anyone have any thoughts on how to get rid of this as I've already re-posted this Batch under a different name.
*This post is locked for comments
The following steps are from a knowledgebase article.
1. Make sure you have a current working backup of your Company database.
2. Go to Query Analyzer located on your Microsoft SQL Server.
3. Select the Company database from the drop down box in your tool bar.
4. Using Query Analyzer, access the Company database and run the following statement:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'
(where XXX = the Batch Number or name of the batch you are trying to post. BACHNUMB is the same as the Batch ID window in Great Plains.)
5. Using Query Analyzer, run the following statement against the DYNAMICS database:
DELETE SY00800 where BACHNUMB='XXX'
(where XXX = the Batch Number or name of the batch you are trying to post).
6. Verify the accuracy of the transactions.
7. Verify that you can edit and post the batches.
Was this batch created under your user id? If not, that user id must be logged in so the batch can update and basically continue posting until it moves to batch recovery.
If batches get "hung up" in process, the first move is always to log in as the original user that attempted the posting.
Reply here with your update, I'll do my best to help.
DFD
#1
André Arnaud de Cal...
292,468
Super User 2025 Season 1
#2
Martin Dráb
231,289
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
