News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Sales order Logs Table

Finance | Project Operations, Human Resources, ...

Suggested answer

Sales order Logs Table

(1) Share

Report

Report

Posted on by BP-09051132-0

60

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.

All responses Img

All responses (3)

Answers Img

Answers (0)

Waed Ayyad 6,332 Super User 2024 Season 2 on at

Like (0)

Report

Sales order Logs Table

Hi,

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

Thanks
Waed Ayyad
Suggested answer

Waed Ayyad 6,332 Super User 2024 Season 2 on at

Like (0)

Report

Sales order Logs Table

Hi,

Did you try to use order events button on Sales order form? Follow the below link it may be helps you:

https://community.dynamics.com/blogs/post/?postid=82a5f68c-d666-4f6d-bde8-75286d21de96

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Sales order Logs Table

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans