Using Inventory Aging Add-on you can manage your inventory in much better way.

You can get an overview of the current age composition of selected items in the inventory. Aging reports show the number of units of the selected item that were added to or removed from inventory and at which point in time (Items can be added to or removed from inventory as a result of purchases, sales and receipts and issues). User can view age compositions by QTY, Serial Numbers, Batch there is a separate reported for each type.