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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Identifying if a sales order was deleted and by whom

(0) ShareShare
ReportReport
Posted on by 10

Hello, Is there a SQL table that maintains recorders of sales orders that have been deleted and by whom?

Thanks

I have the same question (0)
  • Suggested answer
    Joseph Markovich Profile Picture
    3,976 on at

    Hi Gilbert, there's two options:

    1) Turn on the activity tracking in GP. Administration > Setup > Activity Tracking. Change the activity type drop-down to File Tracking. Then check "Deletions to Trx files." Then you'll have to go through the list of users underneath and check the Activate checkbox for each company listed you want to track.

    The report is very basic -- date, username, transaction number showing it was deleted.

    If you add users in the future, this is not automatically turned on by default, so you'll have to remember to turn on this tracking on for users.

    One caveat about this for sales orders: when sales transactions are moved from the work to history tables, this is also considered a delete and will be logged on the report.

    Not ideal.

    2) Look into a third-party auditing solution like Rockton Software's Auditor or FastPath's Audit Trail. These give you options that allow you much more detailed control on the auditing setup. These also work somewhat independently of GP, so if other systems that are interacting with the GP data do something to transactions, these tools can report on that too.

    I hope this helps.

    Joe

  • Joseph Markovich Profile Picture
    3,976 on at

    Actually, one more option I just remembered:

    Write a trigger on the SOP10100 table that will track deletes and save it to a new table in the GP database you've created.

    One caveat with this:

    Any upgrade that modifies the SOP10100 table -- your trigger will be gone and you'll have to recreate it.

    Joe

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,095 Most Valuable Professional on at

    Or use GP Power Tools to create some code to track changes.

    For example:

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 559 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 464 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans