Go to the Reports menu.
Highlight Inventory.
Select Inventory Valuation Detail.
Click the Customize Report button.
Under the Display tab, change the Sort by drop-down menu to Pref Vendor.
Hit OK.

Additional details on the process of customizing reports in QuickBooks Desktop is in this article: Customize reports in QuickBooks Desktop. It has several links for related articles on this process, along with the general steps you can take to customize reports.

Don't hesitate to post a comment if you have other concerns. I'll take care of them as soon as I can.

mark_gAuthor

Hi Ryan,

Unfortunately this did not work. No matter what I choose in the Sort By dropdown it still subtotals the inventory by Item Name instead of Vendor. Changing the Sort By will only sort the list under each item, it will not subtotal the entire report by vendor.

Any other ideas??

Mark

lin_jcaj

Level 9

I appreciate the steps you've tried, mark_g. I've got a workaround to achieve your goals today.

The Inventory Valuation report is the only report that will provide you the average cost of an item while this can be grouped by Item. You'll want to export this and fix the groupings through Excel. You can add the Pref Vendor and Item as a column on the report.

To add Pref Vendor and Item as a column:

In the Inventory Valuation Detail page, select Customize Report.
Select the Display tab.
Under the Columns field, search Pref Vendor and Item.
Click on OK.

Once done, you can export it to Excel and fix the groupings from there to get the information you need.

I'd also recommend checking out the customize reports in QuickBooks Desktop for additional guide.

Tag me in a comment below if you have any other concerns on customizing reports in QuickBooks. I'll be right here to help.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded