web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Audit history for reco...
Microsoft Dynamics AX (Archived)

Audit history for record (change history)

(0) ShareShare
ReportReport
Posted on by Community Member

Hi All,

I work with the Dynamics CRM systems, but sometimes I have tasks regarding the AX systems too.

Now I am working with a task regarding the difference in the data between AX & CRM systems (they are connected by DYS connector).

And I have the following question: Does the AX system have a audit history of records? As in the CRM system. This is info about previous changes in field values. Also when and who did the changes.

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    I am not sure what is in CRM, but for AX you could use 3 tools.

    Database logging:

    This is a setting in AX, with which you could capture specific fields or tables for insert/update/delete operations, and it is stored in the SysDatabaseLog table. It is very resource-intensive to use this, so not recommended for transactions, but only parameters and critical master data like bank accounts.

    SQL Server Change tracking:

    This is now supported in more recent AX versions, and uses the tools available by SQL for monitoring what fields have been altered.

    ValidTimeStateKey:

    This is an AX way of handling data, where you define a date range that when is the record valid, and previous versions of the records would be kept with a ValidTo date in the past, so you could see how the record looked like at a given date and time. This is also very resource-intensive again and in R3 Microsoft has redesigned many of their standard tables using this feature.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans