Old MPN of an inventory assembly still showing up in the Item List

I appreciate you raising this with us, AO-EL. Let’s work together to find a solution for updating the MPN so that your inventory reflects the most accurate information.

Inventory assemblies require a manual adjustment to ensure that all fields, including the MPN, reflect the new item. It occurs because the MPN is tied to the assembly item rather than the individual components.

To manually update the MPN linked to that assembly, Here’s how:

1. Go to List in the main menu and choose Item List.
2. Locate the inventory assembly item that is showing the old MPN.
3. Click on the assembly item to open its details.
4. Click the option to edit the item.
5. In the item details, locate the MPN field and update the field with the new MPN.
6. Select Ok to Save.

I've included screenshots for your reference:

You may also consider adding a custom field for better tracking of your MPNs in the future. It enhances your inventory management and reporting capabilities. 

Furthermore, I've included these helpful resources you can visit for future help on understanding basic reports and customizing them in QuickBooks Desktop (QBDT) :

• Understand reports in QBDT
• Customize reports in QBDT

I'm just around the corner and ready to answer any additional questions or concerns about the item code in your QBDT. If you have any inquiries about your data, entries, or other items in QuickBooks, enter a reply below, and I've got your back. 

As soon as I updated the bill of materials to a new item, all the information on the "edit item" window was automatically changed to match the new item.

The problem is that the correct new MPN shows up here, but the old MPN still shows up on the item list. I don't remember how I fixed this before, but I definitely didn't do it through "edit item". There was another menu or something I had to get into where I could see and update information that is not normally available.

Unfortunately, this is not the solution. As soon as I updated the bill of materials to use a new item, all the information in the "edit item" window was automatically changed to the correct information. The problem is that even though the MPN is correct here, the item list still is pulling the old MPN from somewhere else.

I don't remember where I went exactly, but the last time I had to fix this I know it wasn't through the "edit item" window. I had to find another menu or something where normally hidden information can be seen and changed. That was where I found a lingering connection between the inventory assembly and the old MPN that I could update.

Hi there, @AO-EL.

Thank you for reaching out to QuickBooks Desktop Support. I understand you're experiencing an issue where the MPN (Manufacturer Part Number) of an inventory assembly still shows the old MPN in the Item List, even though you've updated the Bill of Materials. This can be challenging, especially since regular inventory parts update automatically.

I recommend re-sorting the Item List to update the item list information. Here's how:

1. Go to Lists and select Item List.
2. Click the Item dropdown button
3. Choose Re-sort List.

If you're seeing the same MPN, I recommend verifying and rebuilding your QuickBooks data to ensure the application runs effectively.

Here's how:

1. Go to Window then select Close All.
2. Head to File, then select Utilities.
3. Select Verify Data. If you see:
   1. QuickBooks detected no problems with your data: your data is clean, and you don’t need to do anything else.
   2. An error message: browse for it on our QuickBooks Desktop support site to learn how to fix it.
   3. Your data has lost integrity: Data damage was found in the file. Rebuild your data to fix it.

Next, we'll need to rebuild your company file data. Here's how:

1. Head to File, Utilities, and then select Rebuild Data.
2. Backup your company file and save it in your local storage before rebuilding.
3. Click OK when you get the message Rebuild has completed.

If you've followed all the steps above and the old MPN is still showing, our support team is here to assist further. Please don't hesitate to contact QuickBooks Support for more detailed guidance tailored to your specific issue.

Additionally, you can also check these articles as you may need them in the future:

• Adjust your inventory quantity or value in QuickBooks Desktop.
• Adjust your inventory of finished goods.

We appreciate your patience as we work together to resolve this matter. Please feel free to leave a reply if you have further concerns about Inventory Assemblies in QuickBooks Desktop.

I tried the resort list, verify data, and rebuild data, but I am unfortunately still having the old MPN show up in the Item List. Verify data did find a few errors that rebuild data fixed, but it seems that the MPN problem isn't one of them.

Please let me know if you have any other ideas on how to fix this or if I will need to reach out to QuickBooks support.

Thanks for returning to the thread and following the suggestions above, @AO-EL.

Let me share other troubleshooting steps to help fix the issue and remove the old MPN from the Item List. Let's start by using the latest version of  QuickBooks Tool Hub. This contains a set of tools to rectify the problem in your company file.

You can follow the steps in this article to utilize QuickBooks Tool Hub: Fix common problems and errors with the QuickBooks Desktop Tool Hub.

If you're still getting the same results, I recommend contacting our QuickBooks Team. They can further investigate the problem and provide you with additional help to fix the issue. 

Here's how to connect with them:
 

1. Go to Help, then select QuickBooks Desktop Help/Contact Us.
2. Click Contact Us.
   Give a brief description of your issue, then select Continue.
3. Sign in to your Intuit account, then click Continue and Continue with my account.
4. If you don't already have an account, make sure to Create a new account.
5. We'll email you a single-use code. Enter your code and select Continue.
6. If you have more than one account, choose the account you want to use and then Continue.
7. Select to chat with us or Have us call you.

If you have further questions about handling MPN (Manufacturer Part Number), just add them to the thread. We'll be here to help.