Dots, Dashes, Spaces – The art of the Part Number
Ahhh…part numbers such little inconsequential things – such a pain to get right. A colleague of mine is working in an organisation which is about to implement a new supply chain IT system – they have the joy of being part of a merger which is pitching several diverse business units together – they’ve taken the view to centralise their Supply Chain and my friend is part of the process of deciding how their new system will operate.
He’s got a real headache at the moment each of the businesses being merged runs it’s own IT solution and they all have different rules with regards to Part Numbers – He’s in charge of migrating inventory data and defining policies - he’s found Part Numbers like the following (these are all based on a theme)
123XYAZ Qty 4 Packets
123XYAZ.42
123XYAZ 42
123XYAZ*not to be issued*
123 XY AZ-42
Etc….
Guess what – there all the same item – and most numbers had stock associated with them! – the parent organisations had lax control over who entered part numbers within the IT system and as you’d expect over time – all hell broke loose!
So what’s the answer? – Well they’ve taken the right step in defining a policy on data entry – they’ve also agreed to limit who can create part numbers and put a formal process behind it – but ultimately there in for some fun discussions and a lot of work in rationalising these (there’s several hundred thousand part numbers in the combined systems) – although actual unique parts will be much lower than this….so what’s the moral in this tale?…..on the one hand it could be to formalise the process and don’t let this happen in the first place…on the other – the lesson in this is don’t get involved in supply chain mergers!