I have a variety of cosmetic products with varying shelf-life.
Cosmetic Regulations now require traceability of items and I need an Inventory control system to suit.
In your system, would it be possible to enter new purchases with batch no., expiry date and quantity, in chronological order, under that coded item, as separate or sub entries, and kept as such until used?
In other words, under one item you would have all purchases with particulars, sub-totals and in date order.
When invoices are typed, the oldest purchases are subtracted from inventory first, batch by batch, and the batch no. and expiry date is included on that invoice against that item. When that batch is complete, inventory takes the next oldest batch.
I can see a lot of future benefit in this sort of system.
Is it possible?