June Blog Series: A Case For…
Insights From: Doug Payton (Fullscope Technical Consultant)
Microsoft Dynamics AX includes classes that check data consistency in most of the modules, and it provides a job to run all or a subset of each one. This is also sometimes called a "sanity check," which ensures the data for tables are in a valid state (for example: tables with lines each point back to a valid header, etc.) or notes that a situation shouldn't last for long (for example: sales orders on hold). It ensures that data corruption or inconsistencies (by the system or by people) can be caught early before effects are felt downstream.