365
Good evening,
I know that the field SOPTYPE = 1 is for Quotes in SOP10100 but if delete this the batch still appear because have transaction in the table sy00500 table and I don't know how match quotes to delete in boths tables.
Thanks,
Mr. García
*This post is locked for comments
Thanks for your help,
But the problem is that I have 50 batchs with aprox. 3 quotes per batch and I need match and delete all this 50 batchs in the SOP10100 and SY00500 tables.
Thanks again,
Hi Garcia,
Are you saying you have deleted the quote but still the batch exist. If you just delete the transaction quote alone then the batch might exist with no transactions. If you wanted to delete the batch select the batch and delete. If the batch says marked for posting the run the following.
SELECT * FROM DYNAMICS..ACTIVITY
SELECT * FROM DYNAMICS..SY00800
SELECT * FROM DYNAMICS..SY00801
SELECT * FROM TEMPDB..DEX_LOCK
SELECT * FROM TEMPDB..DEX_SESSION
If you get answers / results to any of the above, make sure everyone is in fact logged out of GP and then run the following scripts to clear the tables.
DELETE DYNAMICS..ACTIVITY
DELETE DYNAMICS..SY00800
DELETE DYNAMICS..SY00801
DELETE TEMPDB..DEX_LOCK
DELETE TEMPDB..DEX_SESSION
Then run the following against the company database:
UPDATE SY00500 SET MKDTOPST=0, BCHSTTUS=0 where BACHNUMB=’XXX’
(Where ‘XXX’ is the batch ID of the batch that is stuck in posting / Reeiving / Busy / Marked etc.)
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 (