web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Stuck blank batch in GP

(0) ShareShare
ReportReport
Posted on by 10

Stuck blank batch in GP

pastedimage1678361353730v1.png

Categories:
I have the same question (0)
  • Suggested answer
    Gavin Profile Picture
    2,502 on at
    RE: Stuck blank batch in GP

    Hi,

    In the first instance you could take a backup and try running checklinks on the "Posting Definition Master". (see below)

    pastedimage1678388361132v1.png

    If this doesn't remove the blank batch you can delete it from the SY00500 table in the company database in SQL. i.e. run the following after a backup

    SELECT * FROM <CompanyID>.DBO.SY00500 WHERE BACHNUMB=''

    Make a note of the DEX_ROW_ID of your batch then running the following:

    DELETE FROM <CompanyID>.DBO.SY00500 WHERE DEX_ROW_ID = <TheDexRowID>

    Hope this helps.

    Thanks

    Gavin

  • Suggested answer
    DAnny3211 Profile Picture
    11,389 on at
    RE: Stuck blank batch in GP

    hi

    f you have a stuck blank batch in Dynamics GP, there are a few steps you can take to try to resolve the issue:

    Close and reopen Dynamics GP: Sometimes simply closing and reopening the program can clear out any issues with a blank batch.

    Check for active users: Ensure that no one else is currently logged into GP and has the blank batch open. If someone else is logged in, they should close GP and try again.

    Check for processes: Check the Windows Task Manager for any processes related to GP that may be running in the background. End these processes and try again.

    Run a check links: Running a Check Links on the Batch Header and Batch Activity tables can sometimes fix issues with stuck batches.

    Run SQL scripts: If none of the above steps work, you can try running SQL scripts to remove the stuck batch. However, this should only be done by someone with knowledge of SQL and the GP database. It is recommended to take a backup of the database before attempting any SQL changes.

    If none of these steps work, it may be best to contact Microsoft support or a GP consultant for further assistance.

    DAniele

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 813

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 738 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 566 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans