Data Consistency Check Framework in Dynamics AX 2009

The consistency check framework consists of classes with names ending in "ConsistencyCheck."

The consistency check in Dynamics AX validates only the predefined list of tables for each module. This ConsistencyCheck framework is heart of Dynamics AX. Unfortunately there is no much documentation available online on these topics. The intention is to provide some basic details about these classes.

SysConsistencyCheck Class is the base class which is extended by several classes in different modules. All the classes which are extending it override the run method. In which they specify the relevant table names related to the modules, they are checked by the kernelCheckTable or kernelCheckRecords methods. For more information on theSysConsistencyCheck class and its methods refer online documentation at the following link athttp://msdn.microsoft.com/en-us/library/aa674688(v=ax.50).aspx

To run the Consistency check go to Basic > Periodic > Consistency check

SysConsistencyCheckJob Class which helps in running and scheduling the Consistency check batch jobs.

The following are ConsistencyCheck classes from Dynamics AX 2009 which gives information about the class hierarchy and the configurations to which they belong.

	Class Names	Parent Class	Configuration Key
	SysConsistencyCheck
	SysConsistencyCheckJob
	SysSecurityConsistencyCheck
	BankConsistencyCheck		Bank
	CustConsistencyCheck
	CustConsistencyCheck_BOE	CustConsistencyCheck	CustBillOfExchange
	CustConsistencyCheck_LinkTable	CustConsistencyCheck	LogisticsBasic
	docuConsistencyCheck
	HRConsistencyCheck
	EmplConsistencyCheck	HRConsistencyCheck
	CommissionConsistencyCheck	HRConsistencyCheck	Commission
	InventConsistencyCheck		LogisticsBasic
	InventConsistencyCheck_Forecast	InventConsistencyCheck_Table
	InventConsistencyCheck_Journal	InventConsistencyCheck	LogisticsBasic
	InventConsistencyCheck_Onhand	InventConsistencyCheck_Table	LogisticsBasic
	InventConsistencyCheck_Setup	InventConsistencyCheck	LogisticsBasic
	InventConsistencyCheck_Table	InventConsistencyCheck	LogisticsBasic
	InventConsistencyCheck_Trans	InventConsistencyCheck_Table
	SalesConsistencyCheck	SysConsistencyCheck	LogisticsBasic
	VendConsistencyCheck_LinkTable	VendConsistencyCheck	LogisticsBasic
	ReqConsistencyCheck	SysConsistencyCheck	Req
	JmgConsistencyCheck		Jmg
	JmgConsistencyCheck_data	JmgConsistencyCheck	Jmg
	JmgConsistencyCheck_job	JmgConsistencyCheck	JmgJob
	JmgConsistencyCheck_pay	JmgConsistencyCheck	Jmg
	JmgConsistencyCheck_setup	JmgConsistencyCheck	Jmg
	LedgerConsistencyCheck		LedgerBasic
	LedgerBudgetConsistencyCheck	LedgerConsistencyCheck	LedgerBasicBudget
	LedgerConsistencyCheck_Trans	LedgerConsistencyCheck	LedgerBasic
	TaxConsistencyCheck	LedgerConsistencyCheck	LedgerBasic
	CurrencyConsistencyCheck	LedgerConsistencyCheck	Currency
	PrintMgmtConsistencyCheck
	BOMconsistencyCheck		BOM
	BOMConsistencyCheck_Setup	BOMconsistencyCheck	BOM
	BOMconsistencyCheck_Table	BOMconsistencyCheck	BOM
	ProdConsistencyCheck
	ProdConsistencyCheck_Journal	ProdConsistencyCheck	Prod
	ProdConsistencyCheck_Table	ProdConsistencyCheck	Prod
	ProdConsistencyCheck_Setup	ProdConsistencyCheck	Prod
	PurchConsistencyCheck		Prod
	RouteConsistencyCheck		ProdRouting
	RouteConsistencyCheck_Setup	RouteConsistencyCheck	ProdRouting
	RouteConsistencyCheck_Table	RouteConsistencyCheck	ProdRouting
	ProjConsistencyCheck		ProjBasic
	ProjConsistencyCheck_Forecast	ProjConsistencyCheck	ProjBasic
	ProjConsistencyCheck_Invoice	ProjConsistencyCheck	ProjBasic
	ProjConsistencyCheck_Journal	ProjConsistencyCheck	ProjBasic
	ProjConsistencyCheck_Setup	ProjConsistencyCheck	ProjBasic
	ProjConsistencyCheck_Table	ProjConsistencyCheck	ProjBasic
	ProjConsistencyCheck_Trans	ProjConsistencyCheck	ProjBasic
	VendConsistencyCheck
	VendConsistencyCheck_PN	VendConsistencyCheck	VendPromissoryNote
	WMSConsistencyCheck		WMSBasic
	WMSConsistencyCheck_BOL	WMSConsistencyCheck	SalesShipments
	WMSConsistencyCheck_Journal	WMSConsistencyCheck	WMSAdvanced
	WMSConsistencyCheck_Location	WMSConsistencyCheck	WMSBasic
	WMSConsistencyCheck_Pallet	WMSConsistencyCheck	WMSPallet
	WMSConsistencyCheck_PickingRoute	WMSConsistencyCheck	WMSAdvanced
	WMSConsistencyCheck_Setup	WMSConsistencyCheck	WMSBasic
	WMSConsistencyCheck_Shipment	WMSConsistencyCheck	WMSAdvanced
	WMSConsistencyCheck_Transport	WMSConsistencyCheck	WMSPallet
	WMSConsistencyCheck_WMSOrder	WMSConsistencyCheck	WMSAdvanced
	WrkCtrConsistencyCheck		WrkCtr

These are the ConsistencyCheck frame work classes for different modules in Dynamics AX 2009 being covered in the above list.

To know more information on the configurations to which they belong visit this link here.

Minor fix in the below class

LedgerConsistencyCheck class is responsible for validating the General ledger module.

LedgerConsistencyCheck class checks these following tables in the run() method.

List of Tables

1. LedgerTable
2. LedgerJournalTable
3. LedgerTableAlternative
4. LedgerTableAlternativeTrans
5. LedgerParameters
6. AssetLedgerAccounts (Missing)

Add the AssetLedgerAccounts table to the LedgerConsistencyCheck class at end of its run() method as shown in the below image. The accounts for Fixed Assets in chart of Accounts hold references to the data in 'fixed assets in posting profiles'. By including the above table in the class will help to check and improve the data consistency.

The LedgerConsistencyCheck class should look like the above image in AX 2009.

Note : This above fix is not required in Dynamics AX 2012.