another blog

Icon

About Microsoft Dynamics GP :-)

General Entry Batch Posting Issue.

For one of our client there were getting issues on posting general entry batches.One checking the transaction status some of them were in Receiving state.

Image

This is how we solved the issue.

For this issue we will check in batch headers table SY00500,

For current condition it saying batch is in receiving status which is 3.

0 – Available – BATCH_AVAILABLE
1 – Marked to Post – BATCH_POSTING
2 – Marked to Delete – BATCH_DELETING
3 – Marked to Receive – BATCH_RECEIVING
4 – BATCH_DONE_POSTING
5 – BATCH_PRINTING
6 – BATCH_UPDATING
7 – BATCH_POSTING_INCOMPLETE
8 – BATCH_PRINTING_INCOMPLETE
9 – BATCH_UPDATING_INCOMPLETE
10- BATCH_RECURRING_INCOMPLETE
11 – BATCH_POSTED_WITH_ERROR

Check in sy00500 table with BCHSTTUS=3 and BCHSOURC=’GL_Normal’,  find out the users having issue, Ask them to properly logout of the GP.

  • select BCHSTTUS,USERID,* from sy00500 where BCHSTTUS=3 and BCHSOURC=’GL_Normal’

Check troubled users in these two tables, since users are logout of GP there should be no records on it. But if you still found users in table then delete them.

select * from DYNAMICS..SY00800 where USERID in(‘XXXX’,’ XXXX ‘,’ XXXX ‘,’ XXXX ‘)

select * from DYNAMICS..SY00801 where USERID in(‘ XXXX ‘,’ XXXX ‘,’ XXXX ‘,’ XXXX ‘)

  • delete from DYNAMICS..SY00800 where USERID=’ XXXX ‘
  • or if more than one users then delete from DYNAMICS..SY00800 where USERID in (‘ XXXX ‘,’ XXXX ‘,’ XXXX ‘,’ XXXX ‘)

Now update the batch status.

  • update  sy00500 set  BCHSTTUS=0 where  BCHSTTUS=3 and BCHSOURC=’GL_Normal’  and  userid in (‘ XXXX ‘,’ XXXX ‘,’ XXXX ‘,’ XXXX ‘)

Verification:

now your query “select BCHSTTUS,USERID,* from sy00500 where BCHSTTUS=3 and BCHSOURC=’GL_Normal’” should not return anything.

Advertisements

Filed under: Dynamics GP, dynamics-gp, Posting Issues,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: