CREATE DEFINER=CURRENT_USER PROCEDURE `inventory_rpt`(IN `start_date_filter` DATE, IN `end_date_filter` DATE, IN `product_id_filter` INT, IN `store_id_filter` INT)
BEGIN
select  ROW_NUMBER() OVER (ORDER BY scm_products.name) AS Sqn, scm_products.name as Product, scm_products.description as `Description`, 
phar_stores.name as Store, concat(format(sum(balance),2),' ',scm_product_measurements.name) as Balance from store_inventories
join scm_products on scm_products.id = store_inventories.product_id
join phar_stores on phar_stores.id =  store_inventories.store_id
join scm_product_measurements on scm_product_measurements.id = scm_products.purchase_measurement
group by product_id, store_id, scm_product_measurements.name
order by scm_products.name;
END
