Data consistency check – a powerful tool in D365FO
The data consistency tool is available in AX2009, AX2012, and D365FO. The tool can check and correct transactions in related tables if there is a mismatch between them. It deletes the data if there is a mismatch to create consistency. This becomes useful when stuck data is causing an error when executing different processes. Another benefit of the clean-up in transaction data is that it can increase performance for your environment.
The data consistency check is found under the system administration module in D365FO.
It is possible to choose either to “fix error” or “check” transactions and for which module the task should be performed. To increase the performance of the job, it is possible to add a from date to the job.
To execute the job, press the three dots and “Execute.” Or set up the batch job under the “Run in the background” tab and press “OK” to run it.
The result above comes from a “Check” and show different errors/ inconsistencies.
When running the consistency check, you are working with a lot of data. Therefore it is recommended to run it as a batch job.
When the “Fix error” job has run, the result looks like this:?
领英推荐
Not all errors will be corrected when running the “Fix error” job. There can be multiple reasons for this that are very case-specific. Use the table browser function to dig deeper into these transactions/ errors. To access the table browser in AX, press F1 + T, and in D365FO, you shall type in the table name and company in the given link to access the table browser. Afterward, the link shall be open in your web browser.
[Link to environment]/?mi=SysTableBrowser&tableName=[Tablename]&cmp=[Company]
This is an example of how the link can look:
https://dkdemo.sandbox.operations.dynamics.com/?mi=SysTableBrowser&tableName=PurchTableListPage&cmp=usmf
An important note for the tools is that some records may not be possible to edit because of their status. Like for instance in this case here:
Before the tool can be used in the above example the load stauts has to be "In process" it will not work if the load status is "Shipped".
To learn more about data consistency, reach out and get help.?