News and Announcements icon

Dynamics 365 CommunityForums Finance forum Sales order Logs Table

Finance forum

Suggested answer

Sales order Logs Table

(1) Share

Report

Report

Posted on by BP-09051132-0

54

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.

Categories:

Administration and Setup

All responses Img

All responses (3)

Answers Img

Answers (0)

Waed Ayyad 3,904 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 3,904 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... 288,584 Super User

#2

Martin Dráb 225,864 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans