QB Enterprise Will Not Condense Data

Hi, BigBillFL.

If you have inventories, QuickBooks files with negative inventory or negative quantity on hand are one of the reasons that QuickBooks will not condense. You will first need to repair negative inventory in your data file before condensing the file. 

Here's how:

1. From the QuickBooks Reports menu, choose Inventory, then select Inventory Valuation Summary.
2. QuickZoom an item that is showing incorrect values by double-clicking the item name. This opens the Inventory Valuation Detail report for the item. The transactions associated with this item are listed in order by date.
3. QuickZoom the first Bill listed to open the Enter Bills window.
4. Change the date on the bill to a date earlier than the first invoice listed on the detail report you opened in Step 2.
5. Click Save & Close to record the bill with the new date.
6. Repeat Steps 2 through 5 for each incorrect item.

To get more details on how to fix negative inventory, check out this article: Negative inventory causes issues in your company data file.

If you're still getting the same result, I'd suggest contacting our QuickBooks Desktop Support. Agents have the necessary tools to look into your account and locate where the problem is stemming from.

Here's how you can contact us:

1. Within your QuickBooks Desktop, click Help at the top menu bar.
2. Enter a brief description of your concern then click Contact Us.
3. To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
4. We’ll provide you a few options. You choose which one is best for you.

Here are additional references that might be helpful for future use of condensing and rebuilding your data:

• Target Chaining or Unrecoverable Error when running Rebuild utility.
• Use the Condense Data utility.

You can always leave a reply below if you have any other QuickBooks questions.

@BigBillFL 

Negative Inventory can show up on your Balance Sheet but primarily it shows on the following reports:

I have a client that I am currently having this EXACT same issue with. Did the suggestion below correct the issues or was there something else that you did to correct this? 

@slharris 

If the Condense Data utility doesn't do that, consider buying a third-party condense service. It is possible that your file is corrupted.

I'll help fix this condensed data issue, slharris.

If you already tried the steps mentioned in this thread, yet the problem persists, I can suggest another alternative solution to get this resolved. 

You can start using the repair tool in QuickBooks Desktop to examine the files and identify any corrupted components. Make sure to create a backup copy of your company file to save your accounting data before proceeding with the steps.

Here are the steps to repair QBDT:

1. Click the Start menu and select Control Panel.
2. Go to Programs and Features to open the Uninstall or change a program screen.
3. Select QuickBooks and choose Uninstall/Change option.
4. Click Continue and Next.
5. Tap Repair, then wait for it to complete.
6. After completing the repair, click Finish.

If you encounter an error like Files in use during the repair process, just click Ignore, then OK. You might have to click Ignore several times. Then, click Close and restart the computer.

However, if the problem continues, I suggest contacting our Customer Care Support to have this better checked and assist you further in condensing your data.

I'd appreciate it if you'll keep me posted on how the steps work. I want to ensure everything is taken care of for you.

Finding a legitimate 3rd-party company that does this is has proven nearly impossible. 

@slharris 

Click on my profile name and you will find our website address to send an email to. We can help to check your file and condense it if required.