web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP2015 I need delete a...
Microsoft Dynamics GP (Archived)

GP2015 I need delete all quotes in sales transactions from SOP10100 and sy00500 table

(0) ShareShare
ReportReport
Posted on by mgarcia 379

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

I have the same question (0)
  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    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.)

  • mgarcia Profile Picture
    mgarcia 379 on at

    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,

  • Suggested answer
    babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at
    Garcia for this purpose I will recommend to run macro which will be faster as well as it will do it correctly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans