80
We have a batch with no ID and we don't know how that batch was created. We are unable to delete that batch.
Does anyone know how to delete a batch without an ID?
*This post is locked for comments
Beautiful. Worked like a charm!
Another option is first assign batch ID, use edit in SQL and then let the end user verify and delete from application without going through delete statement in SQL. As some company, you can not run delete statement in SQL
Hi,
Batch ID table is in company database.
1) First run following SQL Statment against company Database
select * from SY00500
where bachnumb =''
2) Find Dex_Row_ID from the empty Batch and delete using following statement.
Delete from from SY00500
where dex_Row_ID = your number
or you can delete all blank batches with
Delete from from SY00500
where bachnumb =''
Make sure you have good backup before running any delete statement please.
Thanks
Sandip
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (