Data Quality: Essential for Successful ERP Projects

Initial ERP system implementation efforts require the transfer and conversion of old system data over to the new ERP format. The problems of poor quality data in legacy systems is often underestimated.

Effective use of an ERP system for production scheduling, material requirements planning (MRP) and shop floor control requires accurate item master, bills of material and routings. Without accurate bills of material and routings, the MRP systems fail.

Inaccurate Bills of Material Consequences

If your bills of material are missing items, have the wrong items or incorrect quantities per parent you will:

Have inaccurate costing, cost of goods sold and incorrect inventory valuations
Publish incorrect Financial Statements
Violate procedures of ISO 9000, Internal Controls and Sarbanes Oxley
Have inaccurate pick lists for production orders
Have inaccurate inventory as the wrong items are backflushed
Have items used in production are not depleted from inventory - leading to unforeseen stockouts
Develop quality issues from producing assemblies with incorrect parts leading to product recalls
Find that Bad Data reduces the entire organization's trust in the ERP system
Generate Scrap and Rework
Increase non value added activities in Engineering Department to issue Engineering Changes to correct bills of material
Order parts at incorrect prices or from the wrong vendor
Errors in both Supplier and Customer transactions
Trigger the expense of additional physical inventory counts

Seradex Data Cleansing Tools

Seradex has worked on hundreds of ERP projects and encountered myriad data conversion and quality problems. To minimize the effort involved in cleaning up data Seradex has developed many useful utilities to use in ERP implementation projects. Through data profiling techniques, we can help you understand the strengths and weaknesses of each data source and devise a plan to address and correct problems with the information before populating the ERP system.

These Include:

Address Cleanup - purge duplicates, search and replace, consistent case formats, fill in missing data
Item Master Cleanup - spelling, short forms, dictionary, search and replace, consistent case format
Auto Part Number Generator to follow established standards
Data Integrity Checker to analyzes the entire data set to reveal critical data conditions, such as completeness, duplication, consistency and validate data before it enters an ERP system


Seradex provides a solid foundation for data standardization and cleansing. The Seradex data cleansing improves data at the source to assure its maximum value in the ERP system.