cancel
Showing results for 
Search instead for 
Did you mean: 
JeanLutzNA
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
LieraMarie_A
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

21 Comments 21
MariaSoledadG
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.

JeanLutzNA
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?

LieraMarie_A
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.

ajboutiqueatx
Level 2

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. 

may0927
Level 1

Delete Inventory Adjustment

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

RaymondJayO
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. 

sabrinak91
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

Proteus24
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.

 

 

cube
Level 2

Delete Inventory Adjustment

As another pointed out, while viewing the adjustment record opened, Edit menu (also shows Ctrl-D shortcut) Delete adjustment.

 

Fernandezhk
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?

RenjolynC
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!

cube
Level 2

Delete Inventory Adjustment


@sabrinak91 wrote:

How to delete inventory adjustments in Quickbooks DESKTOP:

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


 

 

Thank you this solution works for me

DebSheenD
QuickBooks Team

Delete Inventory Adjustment

Hello, cube.

I'm happy to see that one of my colleagues was able to help you in an efficient and timely manner.

Feel free to post your concern in the Community if you have further questions.

Thank you and have a great day.

pantone06
Level 2

Delete Inventory Adjustment

This answer needs to be first on the list. I just spent way too long fighting with adjusting an inventory adjustment (which never worked) when all I really wanted to do was delete it in the first place. 

Oland11
Level 1

Delete Inventory Adjustment

I want delete all information is QuickBooks 

I just need the contacts

AileneA
QuickBooks Team

Delete Inventory Adjustment

Hello, Oland11. 

 

Since Community is a public space and this requires pulling your account. I encourage reaching out to our Support care team. This way, a representative can review your account and help you further with this.   

 

Here's how:  

 

  1. Go to Help, then select QuickBooks Desktop Help.
  2. Select Contact Us.
  3. Give a brief description of your issue, then select Let's talk. 
  4. Choose a way to connect.

 

To make sure you'll get prioritize to your concern, please check the availability time of or customer support team. You can contact us every Monday to Friday from 8 AM - 6 PM. Also, phone support may be limited due to volume.   

   

If you need some references in the future, you can also check out our site: Help articles for QuickBooks Desktop

 

Keep me posted on how the contact goes or if there's anything else you need. I'm always around to help you out. Stay safe!

amcordes
Level 1

Delete Inventory Adjustment

Exactly what I needed to know. Thank you!

ShawnLM
Level 1

Delete Inventory Adjustment

This is the answer you are looking for people. Thank you!!!

LiquidStone
Level 1

Delete Inventory Adjustment

when you are on the page viewing your inventory adjustment (the one you want to delete), hit Ctrl and D. This is the only way that I was able to delete the entry since there is no Edit button on the inventory area.  Make sure it is the entry that you want to delete.

JohnFreeman
Level 2

Delete Inventory Adjustment

Thank you so much. Now I know to check the edit menu when I can't find an option that should obvious exist (like deleting ANY transaction). Burying the most basic delete operation in a context menu is maddening.

JohnFreeman
Level 2

Delete Inventory Adjustment

I don't know if this response was warranted at the time it was posted (unlikely) but sabrinak91's comment 4 months later makes it completely invalid. Scroll down to their response for how to actually delete an inventory adjustment instead of whatever this response is suggesting.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us