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

Title

Keeping track of inventory that expires

Post

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! 

Outcomes