I have an user who asked me to release the batch held on posting. We took a backup and ran the SQL update to release as recommended on KB article 850289 -UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB='CMTRX00000612'. After running the SQL update, the batch now shows as Available if you go to Series posting but if you go to the actual batch (Financial>Transactions>Batches) it still shows as Updating.
I ran reconcile on batches and it certainly gave me an error where the batch total for that batch was updated but it did not do anything else. The batch still shows with Updating status.
See below the results on the SQL query for the SY00500 table.
*This post is locked for comments
You are most welcome,
Please never hesitate to share any further inquiries
I will do as you suggest. Thank you very much for your help.
This batch has been apparently posted, leaving a corrupted record in GL10000 with no corresponding journals in GL10001. Therefore, just get the records for both (the new batch, and the old corrupted batch) deleted from SY00500 and GL10000.
As a quality check, If you have any records lefts in ( SY00800, SY00801,TEMPDB..DEX_LOCK, TEMPDB..DEX_SESSION ) for the old corrupted batch, get them deleted.
Additionally, make sure that the journal entries have been posted correctly with the same values originating from bank reconciliation module (since this batch is a CMTRX)
I hope everything is settled and clear by now.
Please never hesitate to close the case by verifying the answer if your inquiry is fulfilled.
Mahmoud, I ran the UPDATE dbo.GL10001 SET BACHNUMB = 'ADJ-BTCH612'WHERE JRNENTRY IN (166503,166504,166505,166506) but no rows got updated.
I checked the table GL20000 and those journal entries are there so I believe we have to remove from the work tables. Right? Should I remove the entries from the work table as well as the batches sitting on SY00500?
I have missed the GL10001, the update should include this table as well
UPDATE dbo.GL10001
SET BACHNUMB = 'XXX'
WHERE JRNENTRY IN (...)
I would like to check these journal entries, which we moved into the new batch, could you find them in the GL20000 ? I am afraid, they have been posted, and remain in the work table.
Let me know how it goes,
OK, we are making some progress but still not there. remember when I said that the journal entries show posted. Well, I got the Journal entries into the new batch using your SQL update, when I try to open the Journal entry from the General Entry window, I got a message saying The journal entry XXX has already been posted
If I look up for the journal entries, I still see the journal entries showing with the new batch number
If I see the batches, I still can see the old batch 612 updating and the one I moved the transactions to says no transactions. Weird! isn't it?
Lets do it as illustrated below;
UPDATE dbo.GL10000
SET BACHNUMB = 'XXX'
WHERE JRNENTRY IN (....)
Now go back and check the General Ledger journal entry window.
Your feedback is highly appreciated,
I appreciate you time and support. I got it just assign the existing JE to a new batch but is not letting me to retrieve the transactions on the General entry window. It shows a message saying "This batch is being posted".
AndrealES
The batch status is retrieved from SY00500, which is why I found it weird that the system is giving you such an error. I believe you need to save your time and create a new batch.
Do not "recreate the journal entries", just assign them to a new batch simply.
I understand what you are are saying, I will recreate the journal entries and delete batch afterwards. However, I updated to set the PSTGSTUS to 1 and I still cannot retrieve the transactions nor select the batch for deleting since I have the message that the batch is being posted.
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156