Thank you everyone for your suggestions and advice! It gives me several options to think about. Cathy, I don’t think you could have said it any better. Having clear procedures in place is essential!
My only challenge with the process, is figuring out all the other complex systems that were used when others faced this problem. There was never a consistent procedure, so I have found letters and additional numbers added to existing lot numbers. For example, 126.96.36.199 or 75.31.2.A. How do I establish system without making it even more complicated?
Again, thank you!