cancel
Showing results for 
Search instead for 
Did you mean: 
NCFAB
Level 1

Open Sales Order Report

We are using ...

 

QBs Version.jpg

 

I am generating the Open Sales Orders by Customer report.  Using this same exact version of QBs at another company I used to work for, I can generate this report cleanly.  All items on orders for this company and the previous company are Non-Inventory items.

 

Now, this report generates with negative quantities & negative dollars for each of the lines on the order instead of positive numbers.  It also generates an additional line showing the total dollars for the entire order which I do not want included.

 

Below is a screenshot of the report results generated.  I have masked our customer names and product information.

 

I hope someone can help because I spent over 45 minutes on the phone with QBs support yesterday and the person could not find the problem. I was supposed to receive a call back and never did.

 

Thanks!

 

QB Sales Order - Masked.jpg

 

 

 

 

5 Comments 5
ChristineJoieR
QuickBooks Team

Open Sales Order Report

I appreciate your effort in calling our phone support team, NCFAB. I can help you resolve this data issue in QuickBooks Desktop.

 

First, non-inventory doesn't track quantities on hand. They represent services, fees, or products that don't use stockpile. Thus, QuickBooks does not record quantities for non-inventory items.

 

To resolve this, we can run the Verify/Rebuild tool. Verify will find any corrupted files, and Rebuild will fix the corrupted data in the software.

 

Let's ensure we create a backup copy of your company file before doing the process. If changes occur, having a backup copy allows you to restore it to undo the changes.

 

Follow the steps below on how to verify data:

 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
  4. Click OK when you see the message.
  5. If Verify finds an issue with your data, press the Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.

 

Next, here's how to rebuild data:

 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Rebuild Data.
  4. Click OK if you receive a prompt to back up your company file.
  5. Press OK when you get the message "Rebuild has completed and proceed to the next step.
  6. Then, run Verify Data to make sure there's no error.

 

Additionally, use these handbooks to address performance issues and optimize your company data file:

 

 

There you go, NCFAB. Feel free to swing by and add a comment if you have other concerns besides generating reports. Together, we can make it.

NCFAB
Level 1

Open Sales Order Report

Did all of that when I was on the phone with QBs Support yesterday.

NCFAB
Level 1

Open Sales Order Report

I did all of that when I was on the phone with QBs Support yesterday. 

NCFAB
Level 1

Open Sales Order Report

I did all that on the phone with support yesterday. 

CharleneMaeF
QuickBooks Team

Open Sales Order Report

Thanks for getting back to us, NCFAB.

 

I read all the interactions in this thread, and it looks like all of the possible troubleshooting steps and relevant articles have already been shared. You also mentioned that you used the Verify and Rebuild Data Utility Tool to no avail. 

 

In this case, I recommend reaching out to our Technical Support Team again. They can take a look at the report to check why the quantity and amount show negative. Here's how:

 

  1. Select QuickBooks Desktop Help from the Help menu.
  2. Click Contact Us.
  3. Type in a short description of your concern, then Continue.
  4. Choose a way to connect with support.

 

You can also go to this link to reach out to them outside of QuickBooks: https://quickbooks.intuit.com/learn-support/en-us/contact.

 

Support for QuickBooks Pro and Premier is open from Monday to Friday, between 6 AM to 6 PM Pacific. 

 

Don't hesitate to reach out to us again if you need anything else. 

Need to get in touch?

Contact us