Batch stuck with status Updating

(0) Share

Report

Posted on by AndreaIES

1,005

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.

Screen-Shot-2014_2D00_08_2D00_15-at-11.48.17-AM.png

Screen-Shot-2014_2D00_08_2D00_15-at-11.48.34-AM.png

Screen-Shot-2014_2D00_08_2D00_15-at-11.48.50-AM.png

*This post is locked for comments

All responses (13)

Answers (1)

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Batch stuck with status Updating

You are most welcome,

Please never hesitate to share any further inquiries
AndreaIES 1,005 on at

Like (0)

Report

RE: Batch stuck with status Updating

I will do as you suggest. Thank you very much for your help.
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Batch stuck with status Updating

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.
AndreaIES 1,005 on at

Like (0)

Report

RE: Batch stuck with status Updating

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?
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Batch stuck with status Updating

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,
AndreaIES 1,005 on at

Like (0)

Report

RE: Batch stuck with status Updating

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?
Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: Batch stuck with status Updating

Lets do it as illustrated below;

Go to Financial > Transactions > Batches

Create a new batch, fill in the batch id "XXX" and choose the origin as "General Entry"

Now run the following update statement on GL10000

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,
AndreaIES 1,005 on at

Like (0)

Report

RE: Batch stuck with status Updating

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".
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Batch stuck with status Updating

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.
AndreaIES 1,005 on at

Like (0)

Report

RE: Batch stuck with status Updating

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.