If there are multiple supplier and supplier item records that are active for an inventory item, this query/report will list multiple lines for every active record in the item-vendor table. To eliminate these duplicate lines, marked those supplier as inactive.