Data validation

With every iteration of data migration, you need to get progressively better. To achieve this, data validation needs to be a well-documented repeatable process and needs to start early on. Do not wait until the deployment stage to engage the business. Here are a few tips to make this process smoother:

Define validation test cases for both the business and IT validation.

  • IT validation: This generally includes verifying record counts, totals, and referential integrity by running tools such as Consistency check (Consistency check is a tool available in Dynamics AX. It validates and fixes referential integrity issues. It can be found in System Administration module, periodic section). You need to acquire different types of validation scripts; it is a good idea to have scripts for validating extracts, if there was an issue in extraction, you can catch it sooner in the process.
  • Business validation: The business owns the data, and it is critical to have the business involved to start data validation early on.
    • Run the reports that the business is going to use. For example, comparing the AR aging reports between the old and the new system, verifying financial statements, and so on.
    • Review the data on screen and use it in the processes for which the data is migrated. For example, running a check-run to verify whether you can pay your vendors and print correct information on payment advices.
    • Usability of data for future transactions and reporting: validate your business processes that use the migrated data. Use migrated data in consequent rounds of CRP.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.15.187.132