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

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

 
3 Comments 3
SophiaAnnL
Moderator

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.png18.png19.png

sameeeeruddin
Level 1

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

But I Need How many Qty left on the report.

JonpriL
Moderator

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

Hello @sameeeeruddin,

 

You can pull up a separate report so you can review the remaining quantity of your items. I'll show you how.

  1. Go to Reports.
  2. In the Search address, enter Product/Service List.
  3. Under Qty on Hand, review the remaining quantity of your items.

Lastly, I've got you this helpful article for ideas about how you can customize a report: Customize reports in QuickBooks Online.

 

Keep me updated in the comments if you have any other questions.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us