Still don't get it.....
What about assigning a digit to the right of the initial serial number? Like
7889-1-2-3 7889 is the raw material,
1 - is the outside service
2 - the manufacturing process
3 - the final product.
easy to trace back and no more duplicates
Kelloggs