Friday, May 4, 2018

Dynamics GP - Payables - "Batch is being edited by another user" when trying to post or process a check batch

This generally happens if you lose connection to the server when attempting to process cheques.
This can also happen if you have  corrupted reports dictionary or corrupted check report that causes GP to crash during check processing. If this happens consistently, try using a local report dictionary instead.

If it says a batch is stuck / being edited, and there is no one else in the system


--Use this to see the batch
SELECT * FROM SY00500 WHERE MKDTOPST<>0 AND BCHSTTUS<>0 AND BACHNUMB='XXX'

--Use this to unlock the batch
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

No comments:

Post a Comment