Solved

Delete Inventory Adjustment

Forum|Forum|6 years ago
June 23, 2020
6 replies
20 views

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.

QuickBooks Desktop

Best answer by LieraMarie_A

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:

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

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

Go to Reports and then Inventory.
Select the Inventory Valuation Detail report.
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.

MariaSoledadG

QuickBooks Team

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.

Launch QuickBooks & Login
Click on New and then select the Inventory part.
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.
In case you need to delete several adjusted inventories, you can follow the same steps and delete multiple inventories at once.
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 Account.

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

J

JeanLutzNAAuthor

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_AAnswer

Level 8

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:

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

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

Go to Reports and then Inventory.
Select the Inventory Valuation Detail report.
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.

S

sabrinak91

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

cube

@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

D

DebSheenD

Level 5

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.

P

Proteus24

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.

F

Fernandezhk

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

Level 9

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!

O

Oland11

I want delete all information is QuickBooks

I just need the contacts

A

AileneA

Moderator

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:

Go to Help, then select QuickBooks Desktop Help.
Select Contact Us.
Give a brief description of your issue, then select Let's talk.
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!

L

LiquidStone

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.

E

Eleanor Cleverence

Hey, I get your dilemma. With QB desktop Pro 2020, you can actually delete an inventory adjustment directly if it was entered by mistake. Here's what you can do:

Open the inventory menu and find 'adjust quantity/value on hand.' Now, the trick is to go to the 'find' or 'adjustments' tab to locate teh duplicate adjustment. When you get it, open the adjustment transaction and there's a delete option on the toolbar or maybe under the edit menu. Just hit 'delete.'

This should clear out taht pesky duplicate. Deletion is often the better route here cuz having extra reversing entries can mess up your records and make reconciliations messy later on. It's cleaner to remove a mistake outright, but make sure nothing else depends on that entry, as deleting can lead to discrepancies if something is tied to it. If ya can't delete it due to restrictions or something, a reversing entry is yor next best bet. Hope this helps!

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded