Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Transacation Entr...
Microsoft Dynamics GP (Archived)

Bank Transacation Entries 'stuck' in Work Status

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Bank Transacation Entries 'stuck' in Work Status

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bank Transacation Entries 'stuck' in Work Status

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bank Transacation Entries 'stuck' in Work Status

    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

  • Verified answer
    Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    RE: Bank Transacation Entries 'stuck' in Work Status

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Bank Transacation Entries 'stuck' in Work Status

    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.

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... on at
    RE: Bank Transacation Entries 'stuck' in Work Status

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans