Showing results for 
Search instead for 
Did you mean: 
Established Member

Inventory / Item

How can I get a report that extracts the item number, calculated average cost, and the total bill of material cost of the item?

1 Comment
QuickBooks Team

Re: Inventory / Item

Thanks for joining the Community, @Lew-Seminole.


I can share some information about the report you'd like to pull up in QuickBooks Desktop (QBDT).


You can run or pull up the Inventory Valuation Detail report. This will give you all the information that you need. Here's how:


1. Go to the Reports menu at the top, then pick Inventory and Inventory Valuation Detail.
2. Click the Customize Report, then go to the Display tab.
3. Select your preferred date on the Report Date Range section, then choose Item Description on the Columns section.

4. You can also add other columns or filter the report if you wish to, then hit OK.


That should get you pointed in the right direction. For additional information, check out this article for future reference: Customize reports in QuickBooks Desktop.


Please let me know how it goes or if you have any follow-up questions. I'll be happy to help. Enjoy your weekend.