Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for sharing a screenshot, @sms2friends.
I'll be glad to share some workaround to get the total amount and quantity per invoice. Since there isn't a report that can generate a total per invoice, you'll need to export the report to Excel to add the total. Let me guide you how.
- Go to Reports at the top.
- Choose Custom Reports, and then Transaction Detail.
- Select the Customize Report button at the top.
- Under Columns, mark QTY and Amount. Then, unmark the other columns that you don't want in the report.
- Change the Total by to Customer.
- Tap the Filters tab, and then scroll towards the Transaction Type. Look for Invoice in the drop-down.
- Click OK.
- Hover towards the Excel drop-down at the top and then select Create New Worksheet.
- Tap Export when prompted.
An Excel Spreadsheet will open, from there you can manually insert a row and enter the totals for QTY and Amount. I've added some screenshots for you.
Learn more about exporting reports in this article: Export reports as Excel workbooks in QuickBooks Desktop
On the other hand, you can look for a third-party app that can handle this type of report. Just visit our website for details: https://desktop.apps.com/home.
Additionally, I'm attaching this link here in case you need help with other reports-related tasks: Understand reports.
That'll do it. Please know that you're always welcome to reply anytime. If you have other questions or concerns with customer reports. Take care and have a good one.