cancel
Showing results for 
Search instead for 
Did you mean: 
mark_g
Level 2

Inventory value by vendor

Does anyone know how to do a simple inventory value report grouped/categorized by Preferred Vendor?  

6 Comments 6
Ryan_M
Moderator

Inventory value by vendor

Hi @mark_g,

 

Let's go through the steps on how you can run an inventory valuation report categorized by preferred vendors. 

 

I'll show you how:

 

  1. Go to the Reports menu.
  2. Highlight Inventory.
  3. Select Inventory Valuation Detail.
  4. Click the Customize Report button.
  5. Under the Display tab, change the Sort by drop-down menu to Pref Vendor
  6. 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_g
Level 2

Inventory value by vendor

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

GlinetteC
Moderator

Inventory value by vendor

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:

 

  1. In the Inventory Valuation Detail page, select Customize Report.
  2. Select the Display tab.
  3. Under the Columns field, search Pref Vendor and Item.
  4. 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.

mark_g
Level 2

Inventory value by vendor

Glinette,

Of course I know you can use Excel to accomplish this.  You can use Excel to do practically anything, but I was looking for something built into Quickbooks.  This is an incredibly common report, so I was certain it was available in QB without exporting the data to Excel or using QBAR.  I was hoping that I was somehow overlooking the report, but now I realize it is not available as an option in Quickbooks.  Strange how Version 20 of a product still lacks such basic reporting functionality.  

JBM444
Level 1

Inventory value by vendor

Wow I agree this is such a basic need I cannot believe it is not part of the process. This is how most people order products from this report.

ArielI
QuickBooks Team

Inventory value by vendor

Hello, @JBM444.

 

Yes, you're right. Since the option you're trying to access isn't available inside QuickBooks Online (QBO), we recommend sending a feature request to our Product Development Team. This way, they can evaluate your suggestion and consider it for future program updates. We'll write down the steps below to get you going:

 

  1. Access your QuickBooks Online company.
  2. On the top right corner, click the Gear icon.
  3. Select Feedback and then enter your comments or product suggestions.
  4. Once ready, click Next to submit feedback.

 

Furthermore, here are some articles to learn more about usage limits and user roles inside the program:

 

 

If you have further questions about inventory valuation, you can comment below, and we'll respond to you as soon as possible.

Need to get in touch?

Contact us