Could this be the most common support query we get! …near enough…Usually down to a network interruption and seen most often in Terminal Server enviornments.
The solution is straighforward.
Get all users to exit GP. Note down the Batch ID that is causing the problem.
Open MSSQL and run the following scripts:
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
Then run the following against the company database:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)
Hi All,
I am really suffering of receivables batch posting stuck. I am running Dynamics 10 under Citrix Env. Most of our batches get stuck at the month end. I tried all possible solution with no luck. I will appreciate if some body can give me a tip how to resolve this issue.
By: Diknash on April 14, 2010
at 17:01
Hi Diknash, email me at is@genesys.ie. I’ll respond and we’ll see what can be done.
Ian.
By: istewart on April 14, 2010
at 19:43
[...] http://dynamicsgp.wordpress.com/2009/06/03/batch-stuck-in-posting-receiving-busy-etc-etc/ [...]
By: Microsoft Dynamics GP Error- Batch is Marked for Posting By Another User | Dynamics GP Help on June 22, 2011
at 21:25
I’m from syvantis technologies and needed to actually do some work with a financial batch that is stuck…ironically you have the solution…you are a talented man
By: Sara Baker on February 24, 2012
at 04:10
Hi Sara. Glad you got it sorted. Ian.
By: istewart on April 11, 2012
at 13:33