My customer is having an issue with the way the system is creating Lot Numbers. We are looking to view the lot numbers in chronological order (FIFO) to know which lot should be shipped first.
What they have set up is:
They have a prefix, then it adds a sequential number and even though the Leading Zeros is checked, it doesn’t add them. After that, it adds the date. So if it is the 3rd receipt for that day, the First Lot Number would be B320241212 and the 10th receipt would be B1020241212 which would show first if sorted in chronological order. But in reality, it should show as the 10th receipt, not the first receipt.
What we would like to see is that it starts with the Prefix, adds the date next in the format YYYYMMDD and then add the sequential number.
Has anyone been able to change the order of the items displayed/used in creating the lot number?
