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

Delete Inventory Adjustment

We just recently upgraded to QB Desktop Pro 2020.  I accidentally entered an inventory adjustment twice.  Is there a way to delete the duplicate entry or do I just have to do a reversing entry?  I would prefer to delete rather than have the extra entries possibly cause more confusion.  I have searched the web and the QB community but all of the solutions don't seem to work for my version.  Many thanks on a solution.

Solved
Best answer June 23, 2020

Best Answers
QuickBooks Team

Delete Inventory Adjustment

Hey there, @JeanLutzNA.

 

The steps provided by my colleague above are applicable in QuickBooks Online (QBO). I'd be glad to guide you on how to handle this in QuickBooks Desktop (QBDT).

 

For now, we're unable to delete an inventory adjustment in QBDT. As a workaround, you'll want to create a new adjustment to offset the duplicate entry. Then, you can add a memo to avoid confusion.

 

Here's how:

  1. Go to the Vendors menu.
  2. Select Inventory Activities and choose Adjust Quantity/Value on Hand.
  3. Fill in the necessary information.
  4. The QTY Difference should be negative if you're decreasing the quantity. Otherwise, it should be positive if it's an increase. 
  5. Enter a note in the Memo field.
  6. Select Save & Close.

 

Once done, you can take a look at your Inventory Valuation Detail report to make sure they are now correct.

 

  1. Go to Reports and then Inventory.
  2. Select the Inventory Valuation Detail report.
  3. Look for the items you adjusted and make sure everything is correct.

 

Do let us know if you have any further questions. I'm always here to help. Take care.

View solution in original post

11 Comments
QuickBooks Team

Delete Inventory Adjustment

QuickBooks updates inventory quantities and values when you track all the purchases and sales, JeanLutzNA.

 

 

There are times we need to deal with our inventory adjustment by deleting them instead of reversing. Let me guide you with the steps.

  1. Launch QuickBooks & Login
  2. Click on New and then select the Inventory part.
  3. Select The Particular Item to be Deleted.

  4. Select Quick Reports. Click on All Tab and then choose the date range.

  5. Right-click on the entry next to the product entry which you want to delete. Choose Delete.

  6. In case you need to delete several adjusted inventories, you can follow the same steps and delete multiple inventories at once.
  7. To save your preferences and your inventory adjustments, click Save.

You can also use the Balance Sheet and Inventory Valuation reports to find all transactions causing discrepancies. Please read this article: Balance Sheet and Inventory/Stock Valuation Reports Show Different Amounts for Inventory Asset Accou....

 

Fill me in if there's anything else you'd like us to help with. We're always here to help.

Level 1

Delete Inventory Adjustment

Thank you for the response however these are the same directions I have tried to no avail.  

"Click on New and then select the Inventory part." - Where am I clicking on New?  After logging in I don't see anything that says New.  I have entered the Item List and found the inventory part.  When I launch Quick Reports I see the transaction I want to delete however when I right click on the line all I get is the properties of the report (font, size, etc).  What step am I missing?

QuickBooks Team

Delete Inventory Adjustment

Hey there, @JeanLutzNA.

 

The steps provided by my colleague above are applicable in QuickBooks Online (QBO). I'd be glad to guide you on how to handle this in QuickBooks Desktop (QBDT).

 

For now, we're unable to delete an inventory adjustment in QBDT. As a workaround, you'll want to create a new adjustment to offset the duplicate entry. Then, you can add a memo to avoid confusion.

 

Here's how:

  1. Go to the Vendors menu.
  2. Select Inventory Activities and choose Adjust Quantity/Value on Hand.
  3. Fill in the necessary information.
  4. The QTY Difference should be negative if you're decreasing the quantity. Otherwise, it should be positive if it's an increase. 
  5. Enter a note in the Memo field.
  6. Select Save & Close.

 

Once done, you can take a look at your Inventory Valuation Detail report to make sure they are now correct.

 

  1. Go to Reports and then Inventory.
  2. Select the Inventory Valuation Detail report.
  3. Look for the items you adjusted and make sure everything is correct.

 

Do let us know if you have any further questions. I'm always here to help. Take care.

View solution in original post

Level 1

Delete Inventory Adjustment

This is not helpful at all. These steps do not take me to a list of inventory adjustments that were made and I still do not see a way to delete them. 

Level 1

Delete Inventory Adjustment

But what are the steps on how to delete the inventory Adjustment ?

Moderator

Delete Inventory Adjustment

I'll provide the two options to help achieve your goal, @may0927

 

If you're using QuickBooks Online (QBO), let's use the Advanced Search feature to delete an inventory adjustment. I'll guide you how. 

  1. Go to the Search icon on the toolbar.
  2. Select Advanced search.
  3. Choose Inventory Quantity Adjustment from the All Transactions drop-down list. 
  4. Set the other filters. 
  5. Click Search.
  6. Select the transaction. 
  7. Click Delete at the bottom of the screen. 

 

The screenshot below shows you the last step. For the detailed instructions, check out this article: Edit Or Delete An Inventory Quantity Adjustment

DeleteTheInventoryAdjustmentInQBO.PNG

 

You can also run reports to view your sales, cost of goods, and inventory status in QBO. 

 

If you're using QuickBooks Desktop (QBDT), deleting an inventory adjustment is currently unavailable. I'd suggest performing the workaround provided by LieraMarie_A above. 

 

In the meantime, I recommend going to the Help menu and select New Features. Then, choose either of the two options from the list (see the screenshot below). This way, you can keep track of our product innovations. 

NewFeaturesInQBDT.PNG

 

Lastly, you can run the Inventory Valuation Summary report to ensure your inventory status is correct. For more details, see Step 4 through this article: Adjusting Inventory Quantity Or Value In QBDT

 

Click the Reply button below if you have other concerns. The Community and I will be around to lend a helping hand. 

Level 1

Delete Inventory Adjustment

How to delete inventory adjustments in Quickbooks DESKTOP:

1. Have the inventory adjustment you want to delete open. (Vendors > Inventory Activities > Adjust Quantity/Value at Hand > Use Previous/Next arrows to find the adjustment you want to delete)

 

2. Click Edit > Delete Inventory Adjustment OR on your keyboard hit CTRL + D

Level 1

Delete Inventory Adjustment

I've been using QB Desktop for many years and there is a very simple step to remove your duplicate "Inventory Adjustment" entry.

 

Go to your Chart of Accounts

Double click on "Inventory Asset"

Go to the date you made the adjustment and select the line item (you don't need to open the entry), right click and delete the entry. This will remove your inventory adjustment.

Hope this resolves your issue.

 

 

Level 2

Delete Inventory Adjustment

any indication of this changing in enterprise 21 or later? pretty sad the premier product doesn't support deleting this transaction considering we even pay extra for advanced inventory. ok, rant done.

 

Level 1

Delete Inventory Adjustment

Hello, I made a mistake and double uploaded all my products and services.. I then made the duplicates inactive to remove them but now the value shows inventory shrinkage.

 

Is there a fast way to fix this?

QuickBooks Team

Delete Inventory Adjustment

Hi there, Fernandezhk.

 

I'd like to share some solutions to help resolve your concern. If you still have the backup copy prior importing the inventory items, then you'll want to restore it. I've got this article for the instructions: Restore a backup of your company file.

 

Otherwise, you need to zero out the inventory shrinkage account by creating a journal entry. I'd recommend consulting with your accountant before doing the process. This is to ensure that your reports are accurate.

 

I'm also adding this article if you have other issues with inventory in QuickBooks Desktop: Fix negative inventory issues in QuickBooks Desktop.

 

If you need more help with QuickBooks Desktop, please let me know in the comments below. Take care!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us