Connect with and learn from others in the QuickBooks Community.
Join nowWe 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! Go to Solution.
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:
Once done, you can take a look at your Inventory Valuation Detail report to make sure they are now correct.
Do let us know if you have any further questions. I'm always here to help. Take care.
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.
Select The Particular Item to be Deleted.
Select Quick Reports. Click on All Tab and then choose the date range.
Right-click on the entry next to the product entry which you want to delete. Choose Delete.
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.
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?
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:
Once done, you can take a look at your Inventory Valuation Detail report to make sure they are now correct.
Do let us know if you have any further questions. I'm always here to help. Take care.
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.
But what are the steps on how to delete the 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.
The screenshot below shows you the last step. For the detailed instructions, check out this article: Edit Or Delete An Inventory Quantity Adjustment.
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.
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.
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
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.
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.
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?
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!