cancel
Showing results for 
Search instead for 
Did you mean: 
Pet Lover
Level 2

Editing item number for assembly

A couple years ago I created some assemblies that had an incorrect item number. There is a suffix for the color and I entered it wrong and now there is a small group of assembly item numbers that don't match all the others. This is confusing for users. We have been using it this way all this time, but we are expanding and I need to correct it.

I want to create the correct item number for the assembly and merge the incorrect number (and all of it's associated bills of material and transaction history) into the new number. Can someone walk me through the steps for this? 

5 Comments 5
AileneA
QuickBooks Team

Editing item number for assembly

Hi there, @Pet Lover.  

 

Thank you for reaching out to the Community. 

 

We can edit the multiple items under Inventory Assemblies. Doing this, you can modify the incorrect items number. 

 

Let me show you how: 

 

  1. Click the Lists menu, and select Add/Edit Multiple List Entries
  2. Under List drop-down arrow and choose Inventory Assemblies
  3. Select the field you want to modify. 
  4. Hit Save Changes once done. 

  

list.PNG  

list1.PNG

 

Note: If there are errors, the list will clear all saved records (the View drop-down arrow changes to show only records with errors). Only those records with errors will remain on the list so you can make corrections. If there are no errors, the list with all saved records remains in view. 

 

Once finished modifying your inventory, you can run an Inventory Stock Status by Item Report to review the changes made.

 

report1..PNG

 

 For more detailed instruction in editing assembly items, you may check out these articles: 

 

Please let me know how it goes by clicking the Reply button. I'm just a post away. Have a great day!

Fiat Lux - ASIA
Level 15

Editing item number for assembly

@Pet Lover 

You may also utilize the 3rd party importer tool to modify Item Assembly, Item Group, or Item List in bulk.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Hope it helps.

Pet Lover
Level 2

Editing item number for assembly

Thank you for the reply.

I just want to make sure before I do this that simply changing the item number for the assembly in the edit list will change all past records that use the old item number. For example, if I open a sale receipt for one of these items after making this change, that sales receipt will be exactly as it was, just with the new number.

 

Is that right? 

Rose-A
Moderator

Editing item number for assembly

Hi, Pet Lover.

 

Yes, you're right. Changing the item number doesn't affect any sales information. The following article guides you through adding, modifying and deleting items in QuickBooks Desktop: Add, edit, and delete items.

 

Also, to learn more about inventory assemblies, check out the following resources:

 

For more inventory questions, you can visit our QuickBooks Desktop Help Articles.

 

If you still need help with inventory, please let me know. I'd be more than willing to lend you a hand.

Pet Lover
Level 2

Editing item number for assembly

Ok. Thanks so much for your help all!

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

Need to get in touch?

Contact us