Yes, this is possible by looking into inventory table where you can find details of product according to date range. This table helps you know that what was your inward and outward movement of the product and what quantity of product is left in the warehouse.