15
We have a batch that appears in the Batch Entry Screen but is not in any of the recovery tables not even in the Batch Master. Where can I delete this batch? It is a batch that has a status of printing.
Thank you
*This post is locked for comments
It would be best to get it available in GP. This way you could print an edit list. If it is truly empty just delete it from the batch entry screen.
Unfortunately I was in the wrong database. I did finally find the batch in question in the SY00500 table. It has a batch status of 5. I will change it to 0 and then go in GP and do print the edit list. If it is empty do I just delete the record from the SY00500 table or from other tables as well.
Do you see it in the GL10001 TABLE?
If not do an INTERNET SEARCH ON SEARCHING text all tables in SQL.
Run that script and search for the name of that batch. Once you know the tables, delete the records. Perform a backup first.
OK. I am in the Financial Batch Entry Screen. The batch in question has the origin of General Entry and a status of Printing. This batch has been there for months and I am just trying to delete it.
That depends on what kind of batch it is.
If there in no record in the SY00500 table then the abandoned data will be in the open transaction tables.
Recivables, Payables, GL, SOP PO, Inventory, etc. each have there own tranasction tables.
Running check links on the might resolve the issue.
What 'Batch Entry Screen' are you looking at?
With everyone out of GP you can run these commands. The GL work tables are GL10000 and GL10001.
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_SESSION
DELETE TEMPDB..DEX_LOCK
The batch is in the Financial Module. Would it be in one of the temp tables? Or what work Tables?
Any help is much appreciated.
In what module do you seen this batch? The SY00500 table where it will be but there may be remnants of it in the work table of module in which you are working.
Unfortunately this batch is not in the SY00500 table. Where else can it be so that I can delete this batch.
You will find the record sitting in the SY00500 table. Running check links may correct this but make sure you perform a backup first.
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (