Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Stefanie Tichacek]

Hey GPUG,

We’ve got a Financial batch stuck in “Updating” status. When we run trial balances, it looks like all of the transactions have posted, yet the batch remains. Tips on how to fix this? Also, what causes this to happen?

Thanks for the help!

——————————
Stefanie Tichacek
Nashville
——————————

[Ryan Galang]

Hi Stefanie,

Can you see if you’re able to reset the status of the batch via Batch Recovery? If yes, print the Edit List next… this may confirm if the transactions have been posted… You can also use the Inquiry windows to verify this.

If they are, then you might just need to delete the batch… (it’s possible that the posting interruption took place after the posting, prior to the “batch cleanup”). Take note though, that a batch can only be deleted when it’s status is “Available”.

If the status does not get reset to Available – using a SQL script would be the next option…

——————————
Ryan Galang
BTP Technologies LLC
Chantilly VA
——————————
——————————————-

[Stefanie Tichacek]

Hi ,

Thanks for the input! Unfortunately, nothing is displayed in batch recovery. Any suggestions on a SQL script to run??

——————————
Stefanie Tichacek
Nashville
——————————
——————————————-

[Steve Burney]

Hi
One thing to do first is to access this website and save it, if you have already done so.
GP Tables

Victoria Yudin		remove preview
GP Tables Below are pages with table information for Dynamics GP as well as some additional resources for finding table information. This is not meant to be a listing of all tables or all modules, just the tables and fields we most often use when reporting. View this on Victoria Yudin >

Open the Company/System Tables option to see the BCHSTTUS options.

Once you are logged in you SQL server and the database you are using, then you can run this statement to get you started.
Select * from SY00500
where bachnumb =’Your batch number’ and see what the settings are for BCHSTTUS setting of this batch.

This will give you an idea of what the current standings are and should help you move forward with clearing this issue.
I hope this helps you and let us know if more assistance is needed.
Steve

?

——————————
Steve Burney
Senior Systems Architect
Nissan Trading Corporation, Americas
Lebanon, TN United States
steve.burney@us.nitco.co

Chairman, Nashville (TN) GPUG Chapter
GPUG Ruby Award 2018
GPUG All Star 2017
Twitter @SteveBurney

GP2016 R2
MRCU14
——————————
——————————————-

[Jo deRuiter]

Hi ?

Deleting/removing the batch name from the SY00500 is one of the last things done in the GP Code Processing during batch posting.

Since you are posting batches and it seems to work, but the batch name is not being deleted, then it seems like what may be happening is that the posting is “not finishing” for some reason.

If you run the script:
SELECT * FROM GL10000 WHERE BACHNUMB = ‘YOUR BATCH NUMBER‘

This is to look for amounts in the Financial Batches only.

If nothing is there then something may be interrupting the batch posting process and this could be a crazy amount of things, including users shutting down before the last bit has happened to an installed third party or customization getting in the way.

Check on this and let us know what you find.

——————————
Jo deRuiter, MCP, DCP
“That GP Red Head”
AISLING DYNAMICS CONSULTING, LLC
WEBSITE: https://aislingdynamics.com/
BLOG: https://community.dynamics.com/gp/b/gplife
770-906-4504 (Cell)

——————————
——————————————-

[Aleiha Hanson]

we’ve had similar things happen…these have worked for us. First, I would run scripts to check if anyone has a stuck SQL batch.

This one is safe to use while users are still logged in:

     SELECT * FROM DYNAMICS..ACTIVITY where USERID not in (select loginame from master..sysprocesses)
     SELECT * FROM DYNAMICS..SY00800 where USERID not in (select USERID from DYNAMICS..ACTIVITY)
     SELECT * FROM DYNAMICS..SY00801 where USERID not in (select USERID from DYNAMICS..ACTIVITY)
     SELECT * FROM tempdb..DEX_LOCK where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)
     SELECT * FROM tempdb..DEX_SESSION where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)

If all looks ok, then run the delete.

     delete DYNAMICS..ACTIVITY where USERID not in (select loginame from master..sysprocesses)
     delete DYNAMICS..SY00800 where USERID not in (select USERID from DYNAMICS..ACTIVITY)
     delete DYNAMICS..SY00801 where USERID not in (select USERID from DYNAMICS..ACTIVITY)
     delete tempdb..DEX_LOCK where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)
     delete tempdb..DEX_SESSION where session_id not in (select SQLSESID from DYNAMICS..ACTIVITY)

Then, I would also run a script to “unlock” the batch you were trying to post.

        >>>unlocking a batch that is stuck as marked by other user but not in batch recovery screen:
        UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’ ?

ALWAYS proceed with caution when running any scripts and ALWAYS create backups when possible before running any update/delete scripts.

——————————
Aleiha Hanson
Royal Basket Trucks, Inc – IT Manager
GPUG Milwaukee WI Chapter Leader
ahanson@royal-basket.com
——————————
——————————————-