Read before: How to measure vendor master data quality
Simple validation of the supplier master data (see Table 1) is an excellent starting point for checking the data quality.
Data validation checks the completeness of data and highlights elements with incorrect details – missed characters, wrong country, incorrect checksums etc – directions for data cleansing actions and estimation of time and resource required for completing them.
Validation is performed against specific standards (e.g. supplier country to ISO 3166-1) which specify how to check the completeness of data.
Datanovel offers a ‘magic button’ – a self-serve Excel tool that takes your vendor file and validates the data, counting a percentage of lines with complete and validatable information.
- Quick supplier master data health check tool. The tool and quick training are free of charge.
The tool validates critical data points in supplier master data. The input is a conventional supplier data extract (CSV or XLS) from an ERP, P2P or S2P system. This report can be either standard or modified – the tool automatically detects the position of required columns.
However, validation will not indicate every issue (such as unnecessary duplicates, hidden supplier families, recent supplier liquidations and acquisitions as well as other matters). Therefore, whenever the tool shows an overall readiness rate below 95 per cent, it is recommended that a complete health assessment of the vendor file is conducted by verifying all essential information with official databases. Please enquire us for:
Read next: