I looking to know how many of each 'flavor' I have left in inventory and the expiration dates of the inventory
All items received are time stamped and I capture the expiration date (ie. qty 300 exp_date 7/04/14, qty 200 exp_date 7/14/14)
All orders processed are time stamped (qty 200 6/27/14), so I could sum up the orders processed in a given day/week or whatever.
How would I begin to set up a solution (temp table, query, or something else) that would identify and display that I have qty 100 w/ exp_date of 7/04 and qty 200 w/ exp_date of 7/14 from the above example for display real time.
Any ideas on how to accomplish this?