cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member

Need to merge 3 items in my inventory into one

I have items in my inventory that are negative.  I need to somehow adjust or merge 3 items into 1 in my QB inventory.  So, for example, say quantity 25 of item #123 is purchased; but item #123 can be sold as either item #123, or #124 or #125.  So on the purchase order item #123 is brought in with the quantity of 25.  Then customers order item 124 or 125 and it creates a negative inventory for those items .......They are all sold for the same amount.  How can I fix this?  I have no way of changing the purchase order as I don't know what item it will be sold as until the customer buys it.  Could I merge item #123,#124#125 together and in the description on the invoice it can say item #123, or #124 or #125.  What is the best way to handle this?

Solved
Best answer 12-10-2018

Accepted Solutions
Not applicable

Hi advancedlaserrec,  You can only merge items of the sa...

Hi advancedlaserrec, 

You can only merge items of the same type. Duplicate service item types can be merged together, but a service type item cannot be merged with a non-inventory item type.When you merge inventory items, QuickBooks merges ALL historical transactions, including the purchases, sales, average costs, etc.

Before attempting to merge your items, make sure to create a backup of your company file. This is in case you need to undo the actions done.

To merge two items:

  1. Click Lists > Item List.
  2. Review the list for duplicate items; note the name of the item you want to remain.
  3. Double-click the item you want to merge into another item. The Edit Item dialog displays.
  4. Type in the Item Name/Number field the name exactly as you noted it in step 2.
  5. Click OK to save your change. QuickBooks provides a warning message that you are merging items.

Merging items needs careful consideration for this results in a different inventory reduction on all sales transactions, and that means all historical financial statements will be different after your merge. This is definitely something we recommend you consult with your accountant or legal adviser.

Let us know if you have other concerns.
Have a great day!

1 Comment
Not applicable

Hi advancedlaserrec,  You can only merge items of the sa...

Hi advancedlaserrec, 

You can only merge items of the same type. Duplicate service item types can be merged together, but a service type item cannot be merged with a non-inventory item type.When you merge inventory items, QuickBooks merges ALL historical transactions, including the purchases, sales, average costs, etc.

Before attempting to merge your items, make sure to create a backup of your company file. This is in case you need to undo the actions done.

To merge two items:

  1. Click Lists > Item List.
  2. Review the list for duplicate items; note the name of the item you want to remain.
  3. Double-click the item you want to merge into another item. The Edit Item dialog displays.
  4. Type in the Item Name/Number field the name exactly as you noted it in step 2.
  5. Click OK to save your change. QuickBooks provides a warning message that you are merging items.

Merging items needs careful consideration for this results in a different inventory reduction on all sales transactions, and that means all historical financial statements will be different after your merge. This is definitely something we recommend you consult with your accountant or legal adviser.

Let us know if you have other concerns.
Have a great day!