Duplicate lines in QBPOS 19.0 Items "Summary with Activity" report

Thanks for dropping by the Community, DFM-TM.

I appreciate you for taking the initial steps in trying to resolve the issue. Also, the screenshot you shared gives us a visual reference to what’s happening to the report.

When you encounter unexpected behavior or errors in QuickBooks Desktop Point of Sale, it’s a good idea to run the Verify Data Utility. This tool will also help find damaged transactions, lists, or SQL table structures in your company file.

Before performing this task, please note the following reminders:

• Do not cancel the utility while it runs.
• Running verify data depends on your company file size and the speed of the system. Small files take a few minutes, large files may take hours.
• Your computer and Point of Sale may appear unresponsive while running the utility. You need to move the mouse pointer to ensure it is still running.
• You need to regularly back up your file.
• While you can run the utility in single or multi-user mode, it is recommended that you run it in single-user mode.
• Run the Cleanup Company Data utility (select the option to compress and run the utility).

To start, make sure to make the Debug mode accessible to run the Verify Data Utility. I’ll help make sure you can do this smoothly.

Here’s how:

1. From the Point of Sale Help menu, select About QuickBooks Point of Sale.
2. This will open the Point of Sale information window.
3. On your keyboard, simultaneously press Ctrl+Alt+D+B.
4. Choose OK to close the information window.

To launch the tool:

1. In the Help menu, choose Debug and Verify Data.
2. Once done, check the validation window to verify any issues.
   *If no errors are found and validation is successful, close the message window.
   *If the issue persists, continue with normal troubleshooting.
   *If an error message is returned, use the Clean Up Company Data utility.

For future reference, here’s an article that will help you resolve the following: Error: POS got stuck when using QuickBooks Point of Sale. It will guide you on how to perform the troubleshooting steps for each POS setup.

Additionally, this link contains articles to get you acclimated to each feature and process in the program: Self-help resources: Choose the topic and click on it to view the full details.

Feel free to drop a comment below if you need help with running reports. I’ll get back to make sure to assist further. Have a good one.

I've made sure we're on the latest update and I ran the Verify Data Utility.  Unfortunately, we still get the duplicate lines.  Also, while trying to figure this out, I noticed that the duplicate lines are in the QBPOS report, not just when opening in Excel, so the duplication is within QBPOS and is not an exporting issue.  Any additional suggestions?

Good day, @DFM-TM.

Thank you for following the suggested troubleshooting steps that were shared by my colleague Rasa-LilaM.

Since you're experiencing the same behavior, I'd recommend reaching out to our Point of Sale Customer Support Team. They have the tools that can help diagnose why you're getting duplicate lines when running a report. 

You can chat with them using this link: https://public-consumer-chat.app.intuit.com/app/ccs/consumer?experienceId=sbsegUsDtCorePos&_ga=2.143...

If you want to call them, you can check out our contact number here: Contact Payments or Point of Sale Support

Let me also share the list of compatible hardware that greatly worked with QuickBooks Point of Sale, you can find them on this article: Hardware to use with QuickBooks Point of Sale.

Should you have any follow-up questions or concerns, don't hesitate to post again here in the Community or leave a comment on this thread. Take care and have a good one.