Microsoft Dynamics GP (Archived)

GL batch stuck with "printing" status

Like (0) Share

Report

Posted on 27 Jan 2014 00:51:40 by Carla Fowler

485

Hello,

We have 2 general ledger batches that a user was attempting to print. They are both now stuck, with the status of "printing". They are not appearing in batch recovery and we cannot access them in any way to delete or modify.

Thanks in advance for any suggestions.

Carla

*This post is locked for comments

All responses (4)

Answers (1)

Community Member on 11 Oct 2017 at 19:52:19

Like (0)

Report

RE: GL batch stuck with "printing" status

Hello - We are experiencing the same situation with a batch ID that cannot be edited printed or deleted. The T-SQL from your link keeps giving errors in the studio related to syntax. We are on SQL 2012 using GP 2013, so that might be the issue. Would you be able to assist with the syntax?
Suggested answer

Community Member on 24 Feb 2016 at 18:03:06

Like (0)

Report

RE: GL batch stuck with "printing" status

Hi Naga,

Using the script from the first link, I had to move the use [company database] before the variable declaration in order to make it work.

Using SQL Server 2008 R8

Cheers
Verified answer

Carla Fowler 485 on 27 Jan 2014 at 14:24:32

Like (0)

Report

RE: GL batch stuck with "printing" status

Thanks Naga. First solution worked beautifully.
Suggested answer

Naga Kiran on 27 Jan 2014 at 03:45:10

Like (0)

Report

RE: GL batch stuck with "printing" status

Hi Carla,

Below are the useful links that will help in resolving this issue:

www.sanjaykumar.us/.../dynamics-gp-batch-stuck-printing-status

blogs.msdn.com/.../releasing-stuck-batches-and-transactions-without-exiting-all-users.aspx

Hope this helps.