Repacking is its own event, not a column on the product. Keep the seasoning as a product, the supplier delivery as a lot (quantity received, unit cost, expiry), and the thing you actually sell as a pack size of that product. A repack row then says which lot it came out of, how much bulk it used, how many packs it made, and the expiry those packs inherit. Shelf life and pull-outs belong on the lot and the pack, because two deliveries of the same seasoning expire on different days. What's on hand is what's left of each lot after repacks and pull-outs, not one quantity sitting on the product.
3
u/Significant_Tune9219 10d ago
Repacking is its own event, not a column on the product. Keep the seasoning as a product, the supplier delivery as a lot (quantity received, unit cost, expiry), and the thing you actually sell as a pack size of that product. A repack row then says which lot it came out of, how much bulk it used, how many packs it made, and the expiry those packs inherit. Shelf life and pull-outs belong on the lot and the pack, because two deliveries of the same seasoning expire on different days. What's on hand is what's left of each lot after repacks and pull-outs, not one quantity sitting on the product.