Does anyone know how to generate such a report?
Drill down on a Sales Invoice Totals by Item report for an item, sort by the contact field, and export. You would have to do this for each inventory item. But a complete report breaking out all the things you listed could also be unwieldy and extremely long.