If you enter the lot number on every line of the invoice, then you can use GridView to generate a spreadsheet every night with quantity sales by item / lot. ExcelDirect this spreadsheet and load it against another Excel sheet with the quantities on hand for each lot. Highlight those where the quantity is way more than the run rate and return them.

Alternatively, have a separate item number for every lot. Why does that not work?