web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Compare 2 records and ...

Small and medium business | Business Central, N...

Suggested Answer

Compare 2 records and get the field change on onmodify trigger of table

(0) Share

Report

Report

Posted on by riya patel

82

Hello Experts,

We need to create a aduit trail like custom functionality for vendor i.e if anyone changes the vendor record the log should be created for that.

We have requirement to get the field name which has been modified .

How can we achieve that?

any help would be appreciated.

Regards,

Patel Riya

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you looked at the standard change log functionality ?

docs.microsoft.com/.../across-log-changes

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply

Yes,

But i think in that we need to add all the fields one by one foer which we need to log the change .

So can i do this with al code ?

Regards,

Patel Riya

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can chose to log all fields on the table instead of logging only selected fields.

Ofcouse you can do both logging and config of the changelog from code.

But i do not have any codesamples for that. I have always done it through the user interface.

Was this reply helpful? Yes No
riya patel 82 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply,

Yes i need to do that from code but can't find the way i have used recordref but i do not know how we can make recordref to refer to the xrec values. can you help with that?

here is the code

Regards,

Patel Riya

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,344 Super User 2026 Season 1

#2

YUN ZHU 1,742 Super User 2026 Season 1

#3

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans