4,150
there used to be an automated solution for this (there likely still is) but I cant think of the correct search phrase to get it to pop up on customer source.
my users have managed to create a batch with no name.
so you cannot select it to delete it
can someone help me with what to search on customer source or better yet post the script that will clear this batch out?
thanks!
Ian
*This post is locked for comments
If you run Check Links on the transaction tables it will create the Batch ID for you, as you've found. After the batch is created you can open it up and see if it holds any transactions. After Check Links recreates it, you should be able to delete it right from the user interface. What problems are you experiencing after Check Links recreates it?
Leslie
The logic or GL clean-up works here too, but you'll need to look for custnmbr='' in the customer tables (starting with RM00101). You'll need to check each in the table group to keep the blank customer from being recreated when you run check links.
When everyone is logged out of GP, try this in SQL:
select * from gl10000 where bachnumb=''
If it returns rows, you have found the blank batch. You'll need to delete it.
Hint: Once you have cleaned up the blank batch, you should also check for Gl10001 having stranded entries with the following:
select * from gl10001 where jrnentry not in (select jrnentry from gl10000)
You'll want to delete this abandoned rows as well.
(These are unusual errors ... I often see it with Integration Manager problems or abandoned GP sessions.)
You'll need to clean up the blank batch in SY00500 after you've done this.
Once GL10000, GL10001, and SY00500 are cleaned up, you are ready to reconcile batches/check links again.
Use all the proper precautions (users out of GP, SQL Backups, comfortable with the scripts, test company, etc.) before deleting data through SQL.
Peggy,
I don't work with financial batches much but have you checked to see if any associated records exist in the GL10000 – Transaction Work/Unposted (header) or GL10001 – Transaction Work/Unposted (line detail) tables?
Our database has a blank customer record that seems to be recreated every time we run checklinks due to voided records in the SOP tables.
Regards,
Kirk
Deborah,
I tried deleting it from the sy00500 table but as soon as I run check links it is added back. Any suggestions?
Thanks for your contribution
Hi Ian,
I have gone into SQL Server - do a select * from SY00500 on the company database and find the dex_row_id for the batch with no name, then delete SY00500 where dex_row_id = 'xxx'.
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
Share
Report
All responses (
Answers (