There should be a Report in ZOHO Books, which will provide a detail information about the Goods Holding Period and shows a whole movement of an Item ( the date when the product entered in the warehouse to the date, product got sale ).