Bank Transacation Entries 'stuck' in Work Status

(0) Share

Report

Posted on by Community Member

Hello, Can anyone assist with this situation...

3 bank transactions were individually entered and posted on 9/27/2016. For whatever reason, it seems that they have become 'stuck' in 'Work' status.

They appear just fine in the checkbook register and have cleared the bank and hence marked reconciled. One of the staff accountants noticed that the 3 entries were not posted to to General Ledger. The 3 entries are in the dbo.GL10000 table and have journal entries assigned to them (82009, 82010, 82011). If you try to inquiry into these journal numbers via the user interface, you'll receive a message that says 'The journal entry number you've entered doesn't exist. hasn't been posted, or is in history...' When looking at the document status in GL10000, I see that they are still in 'Work' status.

There is no batch to recover since they were individually posted transactions. Is there a way to 'post' these transactions so they'll reflect an 'Open' status an appear in the GL?

Hopefully this was a clear explanation of my situation. Look forward to any help!

Thanks, Nicole

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

Hi Nicole,

Have you tried the following from Microsoft KB.

View the contents of the following tables to verify that all users are logged off: DYNAMICS..ACTIVITY, DYNAMICS..SY00800, DYNAMICS..SY00801, TEMPDB..DEX_LOCK, and TEMPDB..DEX_SESSION. To do this, run the following script.

SELECT * FROM DYNAMICS..ACTIVITY

SELECT * FROM DYNAMICS..SY00800

SELECT * FROM DYNAMICS..SY00801

SELECT * FROM TEMPDB..DEX_LOCK

SELECT * FROM TEMPDB..DEX_SESSION

Note When all users are logged off from Microsoft Dynamics GP, these tables will not have any records in them.

If no results are returned, go to 'Step 4'. Otherwise, clear the stuck records by using any of the following appropriate scripts.

DELETE DYNAMICS..ACTIVITY

DELETE DYNAMICS..SY00800

DELETE DYNAMICS..SY00801

DELETE TEMPDB..DEX_LOCK

DELETE TEMPDB..DEX_SESSION

Run the following script against the company database. Replace XXX with the batch number or the name of the batch that you are trying to post or select in Microsoft Dynamics GP.

UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='XXX'

Note The value of BACHNUMB is the same as the value of the Batch ID window in Microsoft Dynamics GP.

Please take a backup of database and logout everyone before you do the above.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hey Babu, thanks for your response. I did look into this recommendation earlier today, however, the batch that these CMTRX were posted to the GL under is not in the SY00500 table. They were originally entered individually in the Checkbook and posted directly to the GL.

Was this reply helpful? Yes No
Verified answer

Heather Roggeveen 9,146 on at

Like (0)

Report

Hi Nicole

This is the GL posting that has stuck. First off check to see if the transactions are found with that journal number in GL20000. If you can find them there, then the transactions have posted fine. If they are not, they still need to be posted.

If things get interrupted, it can result in the Insert happening, but the subsequent delete from Work not happening.

Simplest way would be to set up a batch in the GP interface and then in SQL, assign that batch number to the transactions.

You may need to then adjust some batch totals in SY00500 but hopefully that will enable you to pick them up to post as normal in the interface.

Cheers

Heather

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hey Heather, thank you so much for your help! Sorry for my delay. I am trying your suggestion right now. I did check and the transactions are not yet in GL20000, so I'm going to try your suggestion of assigning them to a new batch. I

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hey Heather - thanks again! That worked like a charm :). You're right, I ended up updating the number of transactions and the batch total as well and it allowed for us to post via the UI.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

Awesome Nicole - thanks for the update. Glad it is now sorted for you.

Was this reply helpful? Yes No