Data cleansing
It’s a common belief that companies have clean data that they are going to use with the implementation of their new ERP. But before you actually go ahead and complete your transfer to the new ERP solution, you might want to ask yourself the following questions.
Do you currently have a blank or incomplete field for your products or generic items?
Do you have old or obsolete product codes in your systems that are no longer in use?
Did you ever enter a price quotation and maybe forgot to delete it?
Do you have data that is very crucial in Excel but not in your legacy system?
Do you have duplicates of multiple accounts of the same customer or supplier?
If you have YES as an answer to any one of these questions then this means that though you are optimistic about your conversion to the new ERP system, your data needs to be cleansed before you complete your transfer to the new ERP solution.
Since the data quality company do have this high on their priority list, the team leading this implementation should make the data cleansing an integral part of the entire implementation process. After all, bringing the clean, precise, relevant and up-to-date records while minimizing the waste will only help you to minimize downtime at conversion as well as reduce the problems that you might face right after going-live.
Generating clean data
Once the problem areas have been identified, there might still be some time left till the actual go-live date, which means data is going to keep adding to the legacy system. At this point, it is extremely crucial to have data standardization as wrong data entry can cause more complication on the conversion. Each and every team member who is using the legacy system needs to be thoroughly trained with the standards and closely monitored to eliminate any problems for the future. In fact, data standardization should be a continuous policy to where there is a set format for entering data to avoid entry of bad data even after the successful implementation of the new system