AnsweredAssumed Answered

Keeping track of inventory that expires

Question asked by solsra on Mar 18, 2009
Latest reply on Mar 19, 2009 by comment_1


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.


For instance:


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!