Keeping track of inventory that expires
I'm working to create an inventory database for perishable goods.
My biggest problem is that I need the item number to stay the same, but maybe with a -number to specify which batch was shipped.
Item number 254 'Milk'
254-01 would be Milk that expires in march
254-02 would be milk that expires in april
Does that make sense? Is it possible or is there a better way to manage this?
Also helpful would be for Filemaker to auto select the oldest product before the newer product when creating invoices.
Thanks in advance!