You can run Gross margin by inventory item report, @NSbookkeeper.

This report lists inventory items and highlights sales, cost of goods, and gross margin per inventory item.

1. Go to the Reports menu.
2. Click Industry Specific and choose Retail.
3. Run the Gross Margin by Inventory Item.

You can double-click a particular item to view its detailed sales history.

Here's more information on how to create, access and modify memorized reports. 

I'm always here if you need help in generating the report that you need. Have a wonderful day!