Let's perform some troubleshooting steps to get the report data you need, Peter Tebart.
You may experience this unexpected behavior if the report is filtered incorrectly or if there's a potential company file data damage. To resolve this, we can clear the report filters by following the steps below:
- Run the report.
- From the Report window, select Modify.
- Select Revert to remove all filters applied on a report.
- Re-run the report then export it to excel.
We can also check for data issues by creating and exporting the report in a test file to verify if this unexpected behavior is file-specific. Here's how:
- From the File menu, select Company Operations.
- Choose Create a New Company.
- Enter the Company Name, then select Create.
- Once a test file is created, run the same report.
If you get the same result, follow Solution 3, if not, perform Solution 2 outlined in this article: Resolve common issues with Point of Sale Reports. If the same thing happens, try repairing the software to fix any damaged components. Just follow the steps and details in this article: Repair QuickBooks Desktop Point of Sale. The steps provided may or may not work since you're using an outdated QuickBooks Point of Sale version.
Feel free to browse this link here if you need help with other tasks in QuickBooks Point of Sale. It'll route you to our general topics with articles.
Keep in touch if you need any more assistance with this, or there's something else I can do for you. I've got your back. You have a good one.
