select a.inv_mast_uid,d.item_id, d.item_desc, a.product_group_id,b.date_last_modified, e.product_group_desc, a.location_id,b.bin, a.qty_on_hand as TotalQtyOnHand, b.quantity as BinQuantityOnHand from inv_loc as a inner join inv_bin as b on a.location_id=b.location_id and a.inv_mast_uid=b.inv_mast_uid inner join (select a.location_id, a.inv_mast_uid,b.item_id , count(*) as rowcount2 from inv_bin as a inner join inv_mast as b on a.inv_mast_uid=b.inv_mast_uid where a.quantity<>0 group by a.location_id, a.inv_mast_uid, b.item_id having count(*)>1) as c on a.location_id=c.location_id and a.inv_mast_uid=c.inv_mast_uid inner join inv_mast as d on a.inv_mast_uid=d.inv_mast_uid left join product_group as e on a.product_group_id=e.product_group_id where b.quantity<>0 |
Knowledgebase Home > Epicor Prophet 21 >