Showing results for 
Search instead for 
Did you mean: 
Community Contributor *

total units sold Summary by Rep report


I use 2019 QB for Mac desktop. When I run reports for the month, quarter, etc. I want to see the total Units sold. On the Sales by Item Summary it shows units sold, but no total at the bottom, see attached, the highlighted in red should the be total units sold.

I also tried Sales Item by Detail and still no total. Under Options on the report there is no total units sold to select. Help, as I'm tried of manually have to add the number to find the total units sold. 

QuickBooks Team

Re: total units sold Summary by Rep report

Let's check to see if this is a data issue, roysco.


You'll want to run the Rebuild Data Utility and Verify Data Utility tool to identify and fix data problems in the program.


To Rebuild Data:

  1. Click File, then select Utilities and Rebuild Data.
  2. On the QuickBooks Information window, select OK. Follow the prompts to save a backup. 
  3. Click OK when you see Rebuild has completed.

To Verify Data:

  1. Click File, then click Utilities and Verify Data.
  2. If you see QuickBooks detected no problem with your data, select OK. You may continue using your company file.
  3. If Verify finds an issue with your data, you will be prompted to Rebuild Now or View Errors. Select Close, then review the QBWin.log file.

You can refer to this article for more information: Resolve data damage on your company file.


If you need anything else, please don't hesitate to get back to me anytime.

Community Contributor *

Re: total units sold, Summary Sales by Item report not showing


I successfully rebuilt and verify data and still no total. Attached report: Sales by Item Summary.

Any other ideas? 

QuickBooks Team

Re: total units sold, Summary Sales by Item report not showing

Hi there, @roysco.


I appreciate you providing some more details about this issue. I'm here to help provide additional details regarding pulling up a Sales Item report in QuickBooks Desktop. 


We haven't received any similar cases reported to us. To better isolate this issue, we can try uninstalling and reinstalling your QuickBooks. Doing this helps resolve program-related issues like this. 

Before doing so, be sure to have your QuickBooks Desktop download file (or your installation CD), and license numbers ready.


To uninstall your QuickBooks:

  1. Close QuickBooks.
  2. While on your desktop, from the Finder menu, select Go.
  3. Choose Applications.
  4. Select the QuickBooks icon and drag/move it to the Trash.

For detailed instructions about this process, please check out this article: Reinstall QuickBooks for Mac using clean install.


However, if the problem continues, I'd suggest reaching out to our Customer Care Team. They have the necessary tools like screen-sharing that can help verify what's causing the issue. You can reach them by following the contact details found in this link: Contact the QuickBooks Desktop Customer Support Team.


This should get you back to business.


Please don't hesitate to reach out to me here should you have any further questions, I want to make sure you're taken care of. Thanks for coming to the Community and take care.

Community Contributor *

Re: total units sold, Summary Sales by Item report not showing

This is crazy. QB support says it is a QB for MAC issue. A simple sum of a column can't be done. Frustrated that I have to manually add units sold in my Sale by Item Summary report. 

QuickBooks Team

Re: total units sold, Summary Sales by Item report not showing

We don't want our customers to feel that way, Roysco.


Rest assured, our engineers are doing their best to get a permanent fix as soon as possible. For now, you'll want to manually add the units sold in the Sales by Item Summary report.


In case you have other questions, don't hesitate to post in the Community.