Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Two weeks ago, we noticed that we are starting to get duplicate lines for the same item # in the Items "Summary with Activity" report in QB Desktop Point of Sale 19.0 when exporting to Excel. See below for example. (I added boxes and highlight.) We've not changed anything, so this is out of the blue and making it a pain to reconcile some of my internal reports. I'll check for any POS updates, but looking at the description of the latest updates, it doesn't look like this is addressed. Any idea how to correct this issue?
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:
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:
To launch the tool:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here