Can't Delete Batch

• 06-26-2008 2:15 PM

  CPD Joined on 06-26-2008 Posts 2

  Can't Delete Batch Reply Contact 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.

• 06-26-2008 6:24 PM

  In reply to

  David Dery Joined on 06-17-2008 Posts 2

  Re: Can't Delete Batch Reply Contact 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 David F. Dery DeryDynamics.com

  Tags: Dynamics GP, Microsoft Dynamics GP, Dynamics

• 06-26-2008 6:39 PM

  In reply to

  callen Joined on 06-26-2008 Posts 33

  Re: Can't Delete Batch Reply Contact 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.