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

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

I don't want these items in the inventory because I decided not to carry them at all.  why do I get the pop-up telling me item has been used in a transaction, Which is not true.
Solved
Best answer 12-10-2018

Best Answers
Highlighted
Level 3

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Hello Khan

I'd be happy to help you with this.

Let's pull up the QuickReport for this inventory item to double-check if there are no transactions using it.

Here's how:

  1. From the Lists menu, choose Item List.
  2. Right click on the inventory item, and choose QuickReport: [Item Name].
  3. Choose All from the Dates drop down option, and click Refresh.
  4. If there are transactions on the report, just double click it, and press Ctrl+D on your keyboard.
  5. Click OK to confirm.

Then try deleting the inventory item again. If you can't find any transactions, your best bet is to make it inactive.

Let me know how it goes. I'll be waiting to hear back.

View solution in original post

11 Comments
Highlighted
Level 3

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Hello Khan

I'd be happy to help you with this.

Let's pull up the QuickReport for this inventory item to double-check if there are no transactions using it.

Here's how:

  1. From the Lists menu, choose Item List.
  2. Right click on the inventory item, and choose QuickReport: [Item Name].
  3. Choose All from the Dates drop down option, and click Refresh.
  4. If there are transactions on the report, just double click it, and press Ctrl+D on your keyboard.
  5. Click OK to confirm.

Then try deleting the inventory item again. If you can't find any transactions, your best bet is to make it inactive.

Let me know how it goes. I'll be waiting to hear back.

View solution in original post

Highlighted
Level 1

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Thank you very much.  I followed your instructions and was able to delete items from the inventory.  Thanks again.
Highlighted
Level 3

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Hi Khan,

I'm glad that you were able to delete them. You can always post any questions here in the Community and we are happy to help.

Have great day!
Highlighted
Level 1

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Can you delete items even if they have transactions after you condense data?  Our item list is completely out of control.  Help
Highlighted
Level 3

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Hello there @accounting

In order to completely delete an item, you'll need to make sure that there are no transactions associated with it. You can right click on the item you want to delete and select QuickReport to show all the transactions associated with it.
Highlighted
Level 1

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

There are not transaction on the QuickReport for the item I need to delete. But when I click delete a window pops up that says "Problem Although this list item is inactive, Quickbooks cannot delete it because it is used in at least one transation"
The best I can figure is maybe it was used on an Estimate but since that doesn't show on the QuickReport I can't find which Estimate. So how can I delete it. Having it as Inactive doesn't help cause I need to clean up my item list to make setting the price list easier. Even if the item is inactive it still shows up when setting the price list.
Highlighted
Level 15

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

"I need to delete some but it won't let me because it says the item was used. If I could find where it is used I can delete the Estimate it was used on but I don't know how to find the Estimate"

Yes, I described it: Reports menu > Jobs, Time and Mileage reports. There is "Item Estimates Vs Actuals" right there; filter it for the items you want, which cannot be Left Inactive to Filter on them. They will show, if there were used, even if left inactive. Set your date range at the top to ALL.


Highlighted
Level 15

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

"Although this list item is inactive,"

Open your Items List. At the bottom, Checkmark "Include Inactive." Now you see everything.

"maybe it was used on an Estimate but since that doesn't show on the QuickReport I can't find which Estimate"

Or, you likely have this inside a Group Item or an Assembly Item from Builds.

Or, a Service Item is in use on Timesheets. It is easy to see this, but you need Other Reports.

Reports menu > Jobs, Time and Mileage.

Examples: Time by Item. Item Profitability. Estimates vs Actuals Detail.

Or, you used a Charge item in a Mileage entry. Run the Mileage reports, from here.
Highlighted
Level 1

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

We are a building supply company and just have inventory items no service items and we don't assembly anything here so everything is individual items. I need to delete some but it won't let me because it says the item was used. If I could find where it is used I can delete the Estimate it was used on but I don't know how to find the Estimate.
Highlighted
Level 1

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Can I actually permanently delete an inventory assembly item?  We have a sitation where an item was edited and then a different one was added.  I need to delete the item completely so I can add it again.  I believe that when I delete it, it actually just makes it inactive and I can't use the same number again.

 

Highlighted
QuickBooks Team

Can I completely delete an inventory item entered by mistake and has not been used in any transaction? When I try to delete, the only option I get is to make it inactive

Thanks for joining on this thread, @ldevore.


In QuickBooks Desktop, yes, you’ll only be able to delete an assembly. Make sure item if it doesn’t fall to any of these scenarios.

 

  • You can't delete inventory parts or assemblies that are used as components of other assemblies (even if the assemblies are inactive).
  • If you create an assembly and build it and don't use it in any other transaction, remove the assembly from inventory.
  • When you take out an assembly item that hasn't been used in a transaction, component parts are not deleted automatically.

The Delete feature will completely erase the inventory from your list. To keep the records correct, inactivate the item that you’re not going to use and change its name.


This way, you’ll be able to use the correct item to track the inventory. Here’s how:

 

  1. Go to the Lists menu and choose Item List to view all products/services entered in the company file.
  2. From there, choose the item you’re working on and then choose Make Item inactive.
  3. Click OK to keep the changes.

I’m adding an article that contains links about adding or modifying products/services in QuickBooks Desktop. It also has answers to frequently asked questions: Add, edit, and delete items.


Let me know if you have any other concerns. I’m always ready to answer them for you. Have a good one.

Need to get in touch?

Contact us