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.

We can pull up an Inventory Valuation Detail report in QuickBooks Desktop (QBDT), @Brita2. Let me guide you through the detailed steps.

We can customize a report to show inventory items sold to your customers from a specific vendor. 

Here's how:

1. Open your QBDT account.
2. Go to the Reports tab, then select Inventory.
3. Click the Inventory Valuation Detail.
   
   
4. Click Customize Report and select the necessary details under Columns.
   
   
5. Once done, click OK. 

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

Here's how: 

1. From the reports window, select Memorize.
2. On the Memorize Report window, type in the name you want to assign the report. Note that you need to enter a new name when you are saving a new memorized report. If you want to overwrite a previously saved report, use a name similar to it.
3. (Optional) Select the Save in Memorized Report Group checkbox if you want to save the report on a specific report group (Accountant, Banking, etc...)
4. (Optional) Select 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. Select 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.