Announcements
I need to track the changes done by all the users in all master file data & field
*This post is locked for comments
Hi,
You can use the database log functionality for that purpose.
Details of this functionality and how it is setup can be found on my blog and of course on the MS docs site.
Please check out those sites and let us know if this answers your questions.
Many thanks and best regards,
Ludwig
Hi Sriram,
While Dr. Ludwig response will help you track the changes that users will make, what are you trying to do with those changes? Database log you have to review/search and it stored in encrypted form in SQL. You also tagged reporting & BI, are you trying to get the incremental changes to master data? If yes, instead of setting up database log, look how you can utilize data entities to extract incremental changes.
Thanks,
Satish Panwar
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.
Be very careful about what is relatively 'static' master data and what is relatively 'dynamic'. For example things like costs and prices.
You have to consider whether you want to track a data load for example that affects all items or whether tasks like month end close or mrp updates fields an of not then how will you avoid logging those also.
I recommend you first read the help https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/configure-and-manage-database-logging
That help mentions that when you activate the database log for a certain table, all set-based operations are converted to row-based operations, . For example, if you are logging inserts for a table, each insert is performed as a row-based insert. So activating the database log on a table will cause all code that uses the skip* methods to behave differently, that is to say, the call to these methods will be ignored. That may not give the expected results. So take care and don't do anything without testing.
There are options at sql level.
I suggest read this post also https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/240983/turning-on-created-by-created-date-and-time-modified-by-modified-date-and-time-in-table-properties and https://ibisinc.com/blog/how-to-turn-on-the-modified-by-and-created-by-fields-on-a-table/
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
