LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
ScotDesort
Level 1

Erroneous Open Order - QBD Premier 2021

On our Open Sales Order report by Customer, we have a sales order with no open balance (that column is blank) that always appears on the report. When we open the order, it does indeed say INVOICED IN FULL. Here is a screenshot of the report:

 

https://clip2net.com/s/4fQTmsc

 

Does anyone know how to get this off of our open order report? I tried editing the order, unchecked the CLSD box, re-checking it, and saving. No effect.

 

Thanks.

 

3 Comments 3
jamespaul
Moderator

Erroneous Open Order - QBD Premier 2021

Hello, ScotDesort.

 

Thanks for the screenshot. Let's do a couple of solutions to help us fix the problem and ensure the correct data is reflected on the Open Sales Order report. 

 

A data integrity issue can cause the erroneous open sales order on the report. We can use the Verify and Rebuild utility to fix the erroneous open sales order and remove it from the report. Here's how to do it:

 

  1. Go to File, then hover on Utilities
  2. Select Verify Data.
  3. Follow the prompts to proceed with the data verification process.
  4. When it's done, go to the Utilities menu again.
  5. Select Rebuild Data, then follow the prompts. 

 

verifyrebuild1.PNG

 

An overview about the Verify and Rebuild process is found here: Verify and Rebuild Data in QuickBooks Desktop

 

After doing the rebuild process, run the Open Sales Order by Customer report again and check for the sales order. 

 

Another solution is to run and use the Tool Hub to fix the open sales order. We can download the latest version of the Tool Hub and follow the steps in this article: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

 

After fixing the issue, do you use the Bank Feeds feature to categorize and add your transactions? In any case, we can take a look at this article if you need help matching your payments or expenses with the records in QuickBooks: Add and match Bank Feed transactions in QuickBooks Desktop.

 

If you have any other concerns about other sales orders or invoices, let me know. Need to check on other reports or want to manage your financial data? I can help you out again. Just reply here and I'll get back to you as soon as possible. 

ScotDesort
Level 1

Erroneous Open Order - QBD Premier 2021

Hello

I ran VERIFY

I ran rebuild - 2 minor unrelated issues fixed.

 

Open sales order report still shows the open order.

 

Ran the Desktop tool hub. First ran Quick Fix. Then ran File doctor - no issues found.

 

Not sure what else to do at this point. Any other tips to resolve this? Thanks.

 

DebSheenD
QuickBooks Team

Erroneous Open Order - QBD Premier 2021

I can see the urgency of getting this fixed, ScotDesort.

 

At this moment, we aren't able to give a specific timeframe for when the issue will be resolved. Since they're still working on it and conducting further investigation, I'd suggest contacting our Customer Care Team again so they'll add you to the list of affected users and receive updates through email once a fix is available.

 

If you have a case number, that would help streamline the process. Your case number has the previous agent's notes according to what happened to your issue. This way, you won't be repeating yourself.

 

To reach them, here's how:
 

  1. Open QuickBooks.
  2. Go to the Help menu at the top.
  3. Select QuickBooks Desktop Help.
  4. Type Contact Us in the search box. Then, click on Contact Us at the bottom.
  5. Select the way you wish to connect with support.
     

You may check out this link if you'd like to personalize your own report: Customize customer, job, and sales reports in QuickBooks Desktop.

 

Let us know if you still have other concerns about the Open Sales Order report. We'll be here to help. Have a wonderful day.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us