News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Sales invoice batch &q...

Microsoft Dynamics GP (Archived)

Sales invoice batch "this batch has been marked for posting by another user"

(0) Share

Report

Report

Posted on by Debbie Dudley

55

GP closed while posting a sales invoice batch. The batch status is now "marked" and I get the message "This batch has been marked for posting by another user" when I try to open. How do I gain access to this batch?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

soma 24,406 on at

Like (0)

Report

RE: Sales invoice batch "this batch has been marked for posting by another user"

Verify that all users are logged off from GP and run the below query in SQL Management Studio.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

If any records return by this query, run the below query.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

If no records are returned by first query, then run the below query against the company database.

USE 'Company Database Name'

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='Your Batch ID'

Now open GP and try again.

Hope this helps!!!
Suggested answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Sales invoice batch "this batch has been marked for posting by another user"

Check the solution criteria on the support article Article ID: 850289

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans