Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
Showing results for 
Search instead for 
Did you mean: 
Level 2

Getting an odd error when changing report Sales by Class and Item type

I am using QB Prem 2020 with latest updates.

I ran the report Sales by Class and Item Type. Then I wanted to select various values in Show Columns. But whatever I select I get a popup (see attachment) that row and column headings must be different. I cannot do anything else anymore, but exit the report. Any other changes I try trigger this popup.

On this report I wanted to see how the report looks like when selecting item type or item details.

1 Comment

Getting an odd error when changing report Sales by Class and Item type

It's good to see you here today, @gerdgoebel,


I've tried to replicate the steps you've tried in your company file and did not get the error message. For now, try to run the Verify/Rebuild Utility. This built-in tool automatically fixes minor company file data issues like the one you see when running reports.


Here are the steps to do it:


  1. Go to the File menu then pick Utilities from the list.
  2. Select the Verify Data. tool then wait until the diagnosis is done.
  3. If there are issues, proceed to rebuilding the company file.
  4. Tap File menu then hover over Utilities.
  5. Pick Rebuild Data then click OK.
  6. Follow the onscreen steps to save a backup.

For your reference, see the following link to learn more about this tool: Resolving Potential Data Issues


Let me know the result after trying out the steps. I want to make sure your concern is resolved and I'm here to provide further assistance whenever you need it. Have a great rest of the week!

Need to get in touch?

Contact us