SALES REPORT BY VENDOR

@Brita2  You are asking both for 'a report for items sales purchased *from* a specific vendor' and 'a report of item sales purchased *by* a certain vendor'.

Because of this, your desired report is unclear.

That said, it probably amounts to the same answer. If you click 'Customize' in the top left of most given reports, you can apply filters. One of them is 'Name', and will restrict the report to only items that are associated with the Name you select. In this case, the Vendor Name you select.

I am looking for a report of item sales purchased from a certain vendor.

@Brita2  I feel like we're still not on the same page.

Item Sales are typically representative of things that Customers have bought from you.

Vendors, on the other hand, are those your company pays money to.

Either way, what I said before should still work well enough. Whether you're restricting your report to a particular Vendor or a particular Customer, the Name filter will do that.

As to the exact report, there are several under Sales, if you're actually meaning Customer instead of Vendor. If none of the default reports work, you can always use the Custom Detail Report and play with the filters to make just about any report you need.

Sorry, but that's all I have based on your descriptions so far.

I'm here to share more details about the report you need in QuickBooks Desktop (QBDT), @Brita2.

In addition to what FishingForAnswers said, there are no sales reports for vendors. If you want to see the company's total purchases for each item and service, you can run the Purchase by Item Detail report.

1. Go to Reports and select Report Center.
2. In the search field, type and search Purchase by Item Detail.
3. Double-click the report name to open it.
4. Click the Customize Report button to filter it out further.
5. Make the necessary modifications.

On the other hand, if you're referring to the sales by the items, you can run the Sales by Item Summary report to see how many items are sold. You can then export these reports to Excel and cross-verify and combine the necessary details.

Additionally, you can memorize your reports to save your current changes for future use.

Please return to this thread if you have other concerns with the reports in QBDT. We're here to help you in any way we can.

I am needing a very standard item sales report for items that were purchased from a certain vendor, not what we purchased.  I have run similar reports when using QB POS and other sales software.  I am not sure why QBDT cannot run the same report.  Standard sales reports should include items sales based on preferred vendor, which i might add is a selection, but can't be used.

Generating a Sales Report by Vendor helps businesses track and analyze their purchasing activities from various vendors. This capability is essential for maintaining accurate records, managing expenses. I'll provide more insights about the availability of this report in QuickBooks Desktop (QBDT), Brita2. 

QuickBooks relies on the source and targets in the reports. Preferred Vendors are linked to items, so they will not appear on transaction-type reports like Sales. They will be visible on item-related reports. As a workaround, you can customize an Inventory Valuation Detail report since the Sales by Vendor report is currently unavailable.

Here's how:

1. Go to the Reports menu.
2. Select Inventory.
3. Choose Inventory Valuation Detail.
   
   
   
4. Click the Customize Report button.
5. In the Display tab, place a checkmark before the Item and Pref Vendor columns.
6. Go to the Filters tab, then select Preferred Vendor.
7. Once done, hit  OK.  
   
   
   

Another report you can run is the Sales by Item Detail report. However, you'll need to customize it to show a column for Preferred Vendor. Please refer to the steps below:

1. Go to Lists, then Item List. Double-click on the item name. 
   
   
   
   
2. Tap the Custom Fields button. Then, select Define Fields.
   
   
   
   
3. Under Label, type in Preferred Vendor and put a checkmark in the Use column.
4. Hit OK. 
   
   
   
   
5. In the Preferred Vendor field you created, enter the vendor's name. Hit OK.
   
   
   
   
6. Go to Reports and choose Sales.
7. Click Sales by Item Detail. Then, select the Customize Report button.
8. In the Display tab, go to COLUMNS. Find the Preferred Vendor and place a checkmark. Tap OK. 
   
   
   
   
9. Go to your Invoices, pick an invoice so we can customize them to show the Preferred Vendor column.
10. Click Manage Templates, then Cancel.
    
    
    
    
11. Hit Additional Customization. Tap the Columns tab and put a checkmark on the Screen and Print columns.
    
    
    
    
    
    
12. You'll need to manually type in the vendor's name in the Preferred Vendor field on the invoice. Click Save & Close.
    
    
    
    

    You can now run a Sales by Item Detail report showing a column for Preferred Vendors. Here's how:

     

    1. Go to Reports and choose Sales.
    2. Click Sales by Item Detail. Then, select the Customize Report button.
    3. In the Display tab, go to COLUMNS. Find the Preferred Vendor and place a checkmark. Tap OK. 
    
    
    
    

If you have other questions, please let me know by adding a reply below.

We are looking for a report that shows inventory items sold to customers from specific vendor.

The ability to pull up a report to show inventory items sold to your customers from a specific vendor isn't available in QuickBooks Desktop (QBDT), @Brita2. I've got a workaround to help you.

I recommend sending your feedback so our developers can consider adding this option. To do so, please follow the steps below:

1. Open your QBDT account.
2. Go to the Help menu.
3. Select Send Feedback Online then choose Product Suggestion.
4. Enter your suggestion.
5. Click Send Feedback.

In the meantime, I recommend checking my colleagues' previous responses. Doing so will help you achieve what you need by customizing the suggested reports.

Here's the list of reports you can check:

• Purchase by Item Detail 
• Sales by Item Summary
• Inventory Valuation Detail 
• Sales by Item Detail 

Additionally, you'll want to create a memorized report to save your current customization. 

Here's how: 

1. Select Memorize from the Reports window.
2. On the window, enter the name you want to assign the report.
3. You can select the Save in Memorized Report Group checkbox to save the report on a specific report group. It is optional.
4. It is also optional to choose Share this report template with others. When you select this checkbox, your report template will be accessible to other QuickBooks users when they go to the Contributed tab in the Report Center.
5. Once done, click OK.

I'm always available to help if you require additional assistance managing your reports in QBDT. It's great to have you here in the Community.