QB Inventory Adjustment Error: Can't Adjust Inventory Qua...

Quick Fix: Make sure you're using the correct adjustment type — go to Vendors → Inventory Activities → Adjust Quantity/Value on Hand and select whether you're adjusting quantity, value, or both.

What Causes the Inventory Adjustment Error?

Inventory adjustments correct discrepancies between your physical stock and what QuickBooks shows. Errors during this process usually stem from account configuration or data conflicts:

1. Missing or incorrect Inventory Adjustment Account. Every inventory adjustment needs an expense account to absorb the cost difference. If the default adjustment account hasn't been set up, or if it's mapped to the wrong account type (e.g., a bank account instead of a Cost of Goods Sold or Expense account), QuickBooks will reject the adjustment.

1. Negative inventory quantities. If an adjustment would result in a negative quantity on hand for any item, QuickBooks may allow it but it creates cascading problems — incorrect COGS calculations, wrong average costs, and errors when you later try to condense or run reports. Some versions block the adjustment outright.

1. Item type conflicts. Only items set up as Inventory Part (Desktop) or Inventory type (Online) can be adjusted through the inventory adjustment screen. If an item was created as a Non-Inventory Part, Service, or Group item, it won't appear in the adjustment window, or the adjustment will fail silently.

How to Fix the QuickBooks Inventory Adjustment Error

Solution 1: Set Up the Correct Adjustment Account

In QuickBooks Desktop:

1. Go to Vendors → Inventory Activities → Adjust Quantity/Value on Hand.
2. In the Adjustment Account dropdown, select an appropriate account.
3. If no suitable account exists, click Add New and create one:

- Account Type: Cost of Goods Sold (preferred) or Expense

- Name: "Inventory Adjustments" or "Inventory Shrinkage"

1. Do not use a Balance Sheet account (Asset, Liability, or Equity) — it must be an income statement account.
2. Set the adjustment date and reference number.
3. Enter your item adjustments and click Save & Close.

In QuickBooks Online:

1. Click the + New button and select Inventory Qty Adjustment.
2. QuickBooks Online automatically uses the "Inventory Shrinkage" account. To change it, click the Inventory adjustment account dropdown.
3. Select or create a COGS or Expense account.
4. Enter the new quantities for each item and save.

Solution 2: Fix Negative Inventory Before Adjusting

1. Run the Inventory Valuation Summary report (Reports → Inventory → Inventory Valuation Summary).
2. Look for any items showing negative quantities.
3. For each negative-quantity item, investigate the cause:

- Were sales recorded before purchase receipts? Enter the missing purchase orders or bills first.

- Was an item receipt accidentally deleted? Recreate it.

- Are there duplicate sales transactions? Void the duplicates.

1. After correcting the underlying transactions, the quantities should be positive.
2. Now run your inventory adjustment — it should process without errors.
3. Pro tip: In QuickBooks Desktop, go to Edit → Preferences → Items & Inventory → Company Preferences and check "Warn about negative inventory" to catch these issues early.

Solution 3: Verify and Convert Item Types

In QuickBooks Desktop:

1. Go to Lists → Item List.
2. Find the item you're trying to adjust.
3. Double-click to open it and check the Type field at the top.
4. If it's listed as Non-Inventory Part or Service, it can't be adjusted through Inventory Activities.
5. To convert it: you can't change an existing item's type directly. Instead:

- Make the current item inactive.

- Create a new item with the same name but as Inventory Part type.

- Set the opening quantity and value on the new item.

1. Update any open transactions that reference the old item.

In QuickBooks Online:

1. Go to Sales → Products and Services.
2. Click Edit on the item.
3. Change the type to Inventory and fill in the required fields (quantity on hand, as-of date, reorder point).
4. Save the item, then try your adjustment again.

Still Getting the Inventory Adjustment Error?

• Check for locked transactions. If the adjustment date falls in a closed accounting period, QuickBooks may block it. Go to Edit → Preferences → Accounting → Company Preferences and check the closing date. Either adjust after the closing date or get the admin password to override.
• Look for pending builds or transfers. Open inventory assembly builds or pending inventory transfers can lock item quantities. Complete or void these transactions before adjusting.
• Run Verify Data. Go to File → Utilities → Verify Data to check for inventory-related corruption. If errors are found, run Rebuild Data.
• Contact Intuit Support at 1-800-446-8848 if adjustments consistently fail for specific items — there may be underlying item record corruption.

Prevent This Error in the Future

1. Do regular physical inventory counts. Monthly or quarterly cycle counts catch discrepancies before they compound into major adjustment headaches.
2. Enter purchases before sales. Always record inventory receipts (bills, purchase orders) before recording sales of those items to avoid negative quantities.
3. Use a dedicated adjustment account. Create a specific "Inventory Adjustments" COGS account so all shrinkage, damage, and count corrections are tracked in one place for easy review.
4. Review the Inventory Valuation Summary monthly. This report is your early warning system for negative quantities, zero-cost items, and valuation errors.
5. Set up reorder points. In QuickBooks, set reorder points for each inventory item. This won't prevent adjustment errors directly, but it helps you maintain accurate stock levels that reduce the need for large corrections.

Related Errors

• QuickBooks Condense Data Error
• QuickBooks Verify and Rebuild Error
• QuickBooks Journal Entry Error
• QuickBooks Missing Name List Error

> Tired of QuickBooks errors? Ketchup's AI-powered bookkeeping catches up your books in 3–7 days — so you can stop troubleshooting and start running your business. Get your price →