How can I find last modified date of a record in a table in ax ?
*This post is locked for comments
Dynamics AX tables use to have modifiedDataTime and modifiedBy field for this purpose
but it is part of configuration
go to the properties windows of you table and find out if it is enabled or not.
if enabled when you browse your table you will find these system field showing it value.
if it is your customized table then by default it is not configured.
please verify you table and update us with your findings
You can only found it if it has been enabled for that specific table. If you look at the properties for a table there is a property, ModifiedDateTime, for that.
/DAn
Hi Maram,
Per table you can activate the property ModifiedDateTime. Then you will get an additional field with the name ModifiedDateTime with the last date the record has been modified. Be careful as it will consume some time and could cause performance issues when the table will be updated very often.
It is also possible to enable database log, but then you will have records in the database log per update and you will have to clean up regularly.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Syed Haris Shah 9
Mea_ 4
Community Member 2
