You need to track Lots then.

You could call Terry at Island Micro Systems (250-286-0624). They have a pdt called SerialTracker. In the past Terry has suggested that it could be used to track Lots. But, not to put words into Terry's mouth, there may be some customization required. You should also confirm that they can track the Expiry date on a Lot.