Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Does anyone know how to do a simple inventory value report grouped/categorized by Preferred 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:
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.
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
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:
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.
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.
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.
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here