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

Sales order Logs Table

(1) ShareShare
ReportReport
Posted on by
Hello, 365D F&O Developers! Can anyone tell me which table is used to save the logs of sales orders? I want to create a report related to the past history of sales order data with the present data of a specific sales order.
I have the same question (0)
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    Hi,
    Usually the transaction records and historical data of sales orders are not stored in a single table, but are scattered across multiple related tables. You can configure logging for a table or field, and a record of each change to the table or field is stored in the database log table sysdatabaselog in the environment database. Configure database logging - Finance & Operations | Dynamics 365 | Microsoft Learn
    Best Regards,
    Hana

     
  • Suggested answer
    Waed Ayyad Profile Picture
    9,037 Super User 2025 Season 2 on at
    Hi,

    Did you try to use order events button on Sales order form? Follow the below link it may be helps you:
     
     
    Thanks,
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • Waed Ayyad Profile Picture
    9,037 Super User 2025 Season 2 on at
    Hi,

    Is your issue resolved? If yes, mark the answers that helped you as verified.

    Thanks
    Waed Ayyad

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 704 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 408 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans