Removing Advanced Inventory from a QuickBooks Desktop Enterprise Company File

Advanced Inventory can be stripped from an Enterprise company file when subscription costs or complexity no longer justify the feature, but the removal process carries permanent consequences for serialized and lot-tracked items.

When a business stops using warehouse management, barcode scanning, or serial/lot tracking, the Advanced Inventory add-on in QuickBooks Desktop Enterprise becomes dead overhead. Turning the feature off is straightforward, but the aftermath is not: existing serial and lot data does not survive the removal in a usable form, and in some cases the file itself needs professional attention before the feature can be cleanly detached. This page walks through the preconditions, the disable steps, and what to expect afterward.

Preconditions and Backups

Before disabling Advanced Inventory, our engineers require the following:

1. A verified backup of the company file (.QBB), not just a copy of the working (.QBW) file. Run File > Back Up Company > Create Local Backup, then run File > Utilities > Verify Data on the backup to confirm it is clean.
2. Single-user mode. Switch to single-user mode (File > Switch to Single-User Mode) and ensure no one else is accessing the file on the network.
3. Admin credentials. You must be logged in as the Admin user, and the Admin password must be known and available.
4. A printed or exported inventory valuation report. Run Reports > Inventory > Inventory Valuation Summary and export it to Excel. Once Advanced Inventory is removed, you will need this report to reconcile on-hand quantities and values afterward.

If the file has any existing damage — Verify errors, unrecoverable crashes, or target chaining errors during repair — resolve those issues first. Disabling Advanced Inventory on a structurally damaged file can worsen the corruption.

Steps to Disable Advanced Inventory

With the backup secured and single-user mode active:

1. Go to Edit > Preferences > Items & Inventory.
2. Click the Company Preferences tab.
3. Click the Advanced Inventory Settings button. Note any configuration details you may need later, then close that window.
4. Uncheck Advanced Inventory (or click Turn Off Advanced Inventory, depending on your Enterprise version).
5. QuickBooks will display a warning that serial and lot tracking data will no longer be accessible. Acknowledge it.
6. Click OK to save the preference change.
7. Close and reopen QuickBooks, then log back into the company file.
8. Run File > Utilities > Verify Data to confirm the file is structurally sound after the change.

What Happens to Serialized and Lot-Tracked Items

This is the part that catches most businesses off guard. When Advanced Inventory is removed:

• Serial numbers and lot numbers already assigned to on-hand quantities are no longer viewable or searchable. The quantity on hand for each item remains intact, but the granular tracking layer — which serial is on which shelf, which lot expires when — is stripped from the active interface.
• Historical transactions (sales receipts, invoices, purchase orders) retain their line-item detail — quantities, costs, and dates are preserved. What is lost is the ability to drill into the serial/lot assignment from those transactions.
• FIFO cost tracking reverts to QuickBooks' default average-cost method if you were using Advanced Inventory's FIFO costing option. This can produce different valuation results on reports going forward.
• Barcoding, bin tracking, and multi-warehouse configurations are disabled. Bin locations and site assignments become inaccessible.

Signs It Worked

The removal is successful when:

• The Items & Inventory preference no longer shows the Advanced Inventory checkbox as enabled.
• The Advanced Inventory Settings button is greyed out or absent.
• The Inventory Valuation Summary report runs without error and shows correct on-hand quantities (compare against your pre-removal export).
• Verify Data passes with no errors.

When the Problem Runs Deeper

In some files — particularly those that have been upgraded across multiple Enterprise versions over the years, or files that carried Advanced Inventory data through a version downgrade or edition conversion — the standard disable step can fail or leave orphaned data structures behind. Symptoms include Verify errors after removal, greyed-out preferences that will not clear, or the Advanced Inventory option reappearing after a restart. In those cases the file typically needs a professional repair pass to cleanly strip the Advanced Inventory tables before the feature can be fully retired. Our engineers can evaluate the file and confirm whether that deeper work is necessary before you commit to it.