We manufacture a packaged food product. We need to manage inventory of raw materials (recording lot numbers, received dates, & invoices). when the ingredients are used for batch production. Each ingredient lot number needs to be assigned to that batch and each batch needs to be given a unique number that is recorded on each case box (preferably in bar code label form). When a shipment is compiled, the unique numbers assigned to each product need to be assigned to the invoice.