100
Hi,
I am looking for a solution to capture any field data changes on a Table/Form.
Eg: If a Customer table has 10 fields and if any of the 10 field data change, I need to capture the logs.
This project of mine is time sensitive, suggestions/solutions ASAP would be greatly helpful.
Thanks
Johnson Patrick
Hi, this does not need to be customized, please follow the method suggested by Akash.
More details:
https://www.youtube.com/watch?v=x4-OASJkc7c
https://www.youtube.com/watch?v=lT90amfkgBo
Hope this helps as well.
Thanks.
ZHU
Hi Johnson,
You can use the change log setup, by adding the fields which you want to track.
Enabling tracking for specific fields is easy - simply select those fields and tracking will be activated. Additionally, you can view the change log data directly in the change log entries table.
I hope this information is helpful for you.
If there some specific fields then you have write your condition to check with Xrec.field <> Rec.Field values and store in your custom table.
You can have an idea by this link - forum.mibuso.com/.../compare-xrec-to-rec
Thanks.
Do you have a sample code/blog which does explains this?
In that case you have work on OnModify Trigger and write your logic there, what field has been modified through a RecRef or FieldRef.
Thanks
Hi,
Thanks for the reply.
Should have been more clear. I need to capture the logs in a separate Custom table. Change log will work but since this is custom functionality, we are trying to capture the logs in a different custom table.
-Jp
Hi,
Thanks for the reply.
Should have been more clear. I need to capture the logs in a separate Custom table.
-Jp
Why do you go with Change Log setup enabled? It will help you track everything what you are looking for.
You can use the ChangeLog Setup
ebs.com.au/.../how-to-setup-and-review-change-logs-in-microsoft-dynamics-365-business-central
#1
André Arnaud de Cal...
294,336
Super User 2025 Season 1
#2
Martin Dráb
233,025
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
