Can't Delete Batch

(0) Share

Report

Posted on by CPD

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

All responses (2)

Answers (0)

callen 4,595 on at

Like (0)

Report

Re: Can't Delete Batch

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.
David Dery 10 on at

Like (0)

Report

Re: Can't Delete Batch

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