Diary of an ERP Project Manager: ERP Master Data
We sat down today with our master data teammates, and started trying to push forward on that front, since everybody says that “ERP data cleansing” will ultimately make or break the quality of the ERP implementation. As I am beginning to understand, like everything else, this will be a more complicated task than I thought. My preconception was that we would write a quick translation program that would take the old legacy data, lookup the old, and populate the new ERP Master Data. Cross that off the “to-do” list, game over, give me a more difficult problem.
Like A Cell Going Through Mitosis
The fact is, I don’t know how much trouble we will really have; we didn’t get past the new ERP master data material number naming convention today. Once again our working team separated like a cell going through mitosis. The technocrats among the group, along with the consultants, were adamant that material numbers should be reasonably random, like telephone numbers, assigned by the system in sequential order. The business people, who will use the system every day to provide answers to customers and co-workers, expect that we should use “smart numbers”, meaning that just by looking at them, you can infer some things about the material being referenced. The most ambitious proposal called for the first two digits to reflect material type, the second two digits to represent product family, the fifth digit to define the business unit, the sixth digit the chemical composition, and the last digits to define the construction. Even I can see that approach is “too smart” and inherently problematic, but I also empathize with the business team. Random material numbering in an ERP system seems like a step backward in efficiency. We’ve scheduled another meeting for early next week.
Random material numbering in an ERP system seems like a step backward in efficiency. Tweet This
We lost another consultant this week. It turns out our sales and distribution consultant, Kevin, was a subcontractor, and he found a full time position with benefits at another ERP implementation firm. That is a little disturbing, because we interviewed a lot of consultants before we settled on Kevin, and everyone had confidence in him. I didn’t realize that any of our consulting team was subcontracted. When I asked Marla if we had anybody else in a similar position, it turns out that about half the team is subcontracted. I think that’s an issue, but Marla said we didn’t really have any choice. Apparently, the promise that we could hand pick our team as part of the consulting agreement was more of a sales pitch than it was a practical reality. We at least got Daneesh replaced this week, so we’ll have to start looking again for Kevin’s replacement.
I think material ERP master data is going to be hard.
Featured white papers
The definitive guide to ERP consultants
Seven principles of selecting and working with ERP consultantsDownload
ERP Software Pricing Guide
Get your comprehensive guide to the cost of ERP softwareDownload
60-Step ERP Selection Checklist
Get the comprehensive checklist for your ERP selection projectDownload
Handling your ERP data migration and transfers
The types of ERP data transfer and which you should choose for your data migration
A case study on finding the right ERP consultant
A fictional case study on the impact of hiring the right ERP consultant
How ERP can help you achieve GDPR compliance
How can we use ERP systems to achieve GDPR compliance?