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:
- Click Reports on the left panel.
- Type Purchases by Vendor Detail or Open Purchase Order Detail on the search box.
- Click the Customize button on the upper right-hand corner.
- Maximize the Rows/Columns section, and then click the Change columns link.
- Check the boxes for QTY and Product/Service.
- Maximize the Filter section.
- Check the box for Transaction Type, and then select Bill and Purchase Order.
- Set the date range of the report.
- Click Run report.
- 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.