QuickBooks report that shows average costs calculations

Open the Inventory Valuation Summary in QB – find the item – double click on it
This will bring you to the Inventory Valuation Detail report – click on Modify Report – click on Advanced – click on the In Use button – click Ok – change the date range to ALL