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

Can I get the report for total quantity of products in bills from a vendor or purchase order to the vendor?

 
1 Comment
Highlighted
QuickBooks Team

Can I get the report for total quantity of products in bills from a vendor or purchase order to the vendor?

Yes, you can get a report like that, jae1.

 

There are two reports that will show you the total quantity of products. The first one is the Purchases by Vendor Detail, and the second is the Open Purchase Order Detail. Simply customize these reports to show the QTY column to get the data you need.

 

Here's how:

  1. Click Reports on the left panel.
  2. Type Purchases by Vendor Detail or Open Purchase Order Detail on the search box.
  3. Click the Customize button on the upper right-hand corner.
  4. Maximize the Rows/Columns section, and then click the Change columns link.
  5. Check the boxes for QTY and Product/Service.
  6. Maximize the Filter section.
  7. Check the box for Transaction Type, and then select Bill and Purchase Order.
  8. Set the date range of the report.
  9. Click Run report.
  10. Do the same steps to generate the two reports.

When you're done with these steps, you'll see a QTY column that shows how many products were used on the transactions.

 

I've added screenshots for you.

 

You can always get back to me if you need more help with QuickBooks. Thanks for dropping by.

 

17.png 18.png 19.png

Need to get in touch?

Contact us