Connect with and learn from others in the QuickBooks Community.
I am trying to find a report (or customize a report), to show the total quantities of items purchased by Customer.
For instance, we have 10 items (item list ) that we sell to customers. I'd like to see a report that shows the Customer
and the item total quantity purchased of each item.
Customer Item U/M Quantity
#1 Pencils Ea 700
#2 Tablets Ea 600
#3 etc. etc etc
Go to Solution.
Hi there, @FMW.
I'd be glad to help create a custom report to show the total quantities and the item purchased by the customer.
Also, you can add some filters on the report to show the accounts and items you want to see in it. You can do this by selecting the Customize Report button.
I've added this article that can guide you in exporting reports into Excel if you want to remove some columns on it.
Don't hesitate to click the Reply button if you have other concerns. I'm here to lend a hand.
View solution in original post