Audit history for record (change history)

(0) Share

Report

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)

All responses (1)

Answers (0)

Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

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.

Was this reply helpful? Yes No