Share
ReportStuck blank batch in GP
Categories:
You’re offline. This is a read only version of the page.
10
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
Hi,
In the first instance you could take a backup and try running checklinks on the "Posting Definition Master". (see below)
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
