Dynamics GP – Batch stuck in printing status

Dynamics GP – Batch stuck in printing status

We had the user call in and report the batch was stuck in printing status for long time. The batch had about 108 transactions.  Waiting for any 30 minutes also did not seem to release the batch.  Yet another sticky  situation and the user wanted the batch posted ASAP.

Steps adopted to move on:

Declare @batchnumb varchar(21)
set @batchnumb = 'batch_which_was_stuck'
use [COMPANY DATABASE]
go
delete dynamics..sy00800 where BACHNUMB = @batchnumb
update sy00500 set mkdtopst = 0, bchsttus = 0  
	where bachnumb = @batchnumb

THIS CODE AND INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR  PURPOSE

 

The batch became available.  Printed and reviewed the edit list.  The batch was successfully posted.

Cheers!
Sanjay