cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How can I generate a detailed sales report for a specific vendor

I need to generate a detailed sales report monthly for all items sold that we buy from a specific vendor. Quickbooks enterprise

3 Comments
QuickBooks Team

Re: How can I generate a detailed sales report for a specific vendor

That specific report you need is currently unavailable, Jeff S1. But, I can show you a different way to display the same details. 

 

However, this will be applicable for preferred vendors only. First, we'll pull up the Item Listing report to get the vendor's name and items purchased. Here's how:

  1. Click Lists.
  2. Go to List.
  3. Select Item Listing.
  4. Click Customize Report, then go to the Display tab.
  5. Enter preferred vendor in the columns search field, then select it.
  6. Click OK

Then, let's pull up the Sales by Item Detail report so we can view the items sold. Here's how:

  1. Click Lists.
  2. Go to Sales.
  3. Select Sales by Item Detail.
  4. Click Customize Report, then go to the Filters tab.
  5. In the Search filters field, enter preferred vendor.
  6. Click the All vendors drop-down arrow, then select Multiple vendors.
  7. Select all preferred vendors, then click OK.
  8. Click OK.

You may memorize these reports. This way, you'll no longer go through the customization process again.

 

I can see how it would be handy to have all the details you need in one single report. I'll share this to our management team so they can submit this to our product developers for assessment.

 

If you run into any snags, you can always get back to this thread. 

Not applicable

Re: How can I generate a detailed sales report for a specific vendor

This doesn't exactly work. When I do the above steps and run the report it still shows many preferred vendors parts other than the one vendor I've chosen. Thanks for trying though.

 

Jeff

Moderator

Re: How can I generate a detailed sales report for a specific vendor

Hi, Jeff S1.

Allow me to step in and help you further with generating a detailed report for a specific vendor.

 

To generate the report for a specific vendor, you may want to filter the Detail report.

 

Here's how:

 

  1. On the detail report screen, click Modify at the top menu bar.
  2. Click the Filter Data.
  3. On the pop-up window, select a specific vendor.
  4. Hit OK.
  5. Click Save to run the reportz.PNG

     

You may find these article helpful:

 

For additional help, you can also reach out to our QuickBooks Desktop Support. They have additional tools to assist you in getting this resolved.

 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

If you still need help with generating a report in QuickBooks Point of Sale, please let me know. I'll be around to help.

Need to get in touch?

Contact us