Skip to main content
M
MTek
August 12, 2022
Question

Multiple parts numbers for inventory

  • August 12, 2022
  • 1 reply
  • 0 views

We purchase parts with a vendor part number, but sell them under our own part number.  How can I properly set up to eliminate an inventory headache?

1 reply

LieraMarie_A
LieraMarie_A
August 13, 2022

Hi there, @MTek.

 

Adding part numbers for inventory is essential for tracking them. I can help walk you through how to add manufacturer item numbers and show them on your transaction forms.

 

Currently, there's only one field for part numbers per item. It's used to keep track of the part number when ordering from the manufacturer. The good news is you can create a custom field of your own.

 

You can do this by following these steps:

 

  1. Go to the Lists menu and select Item List.
  2. Double-click any item on the list to open and edit it.
  3. Enter the vendor's part number in the Manufacturing Part Number field.
  4. To add your own, select Custom Fields. Then, Define Fields. 
  5. Name your custom field in the Label column. Names aren't case-sensitive.
  6. In the Use column, select the checkbox to turn on the custom field.
  7. Select OK to save the custom field. Your new custom item field now appears on the Custom Fields list for your products and services. 
  8. Enter the part number for that specific item. 
  9. Hit OK.

 

Finally, here are the steps to display these fields to your purchase or sales forms:

 

  1. Go to Lists, then Templates.
  2. Pick the form you want to edit.
  3. Click Additional Customization. If you are working in a locked template, select Make a Copy.
  4. In the window, select the Columns tab.
  5. Find the MPN and your new custom item field on the list and select the Screen or Print boxes to add them.
  6. When you're done, hit OK.

 

You can check out the following link, which highlights the steps above: Create and use custom fields in QuickBooks Desktop.


Please let me know how it goes and if you have any further questions, feel free to reach back out. We'll be happy to help!

M
MTekAuthor
August 15, 2022

Hello Liera,

Thank you for your response.  We have already added manufacturer part numbers in these cases.  It helps for searching for an item in the ITEM LIST and we are able to add the column to Purchase Orders for our reference, however it does not solve any part of the issue with our inventory.  We have tried adding the items we purchase as sub-items of those we sell, which allows us to "see" it them for ordering or stock information, but it doesn't have any effect on the actual inventory.  

Any other suggestions?

S
SarahannC
August 16, 2022

Hi @MTek, we're glad to have you back.

I appreciate you for considering the steps shared by my colleague and trying to set them up as sub-items. You're right that it helps us to search for a particular item in the lists. We understand how important to set up multiple parts numbers for your inventory and reflect them in your actual inventory.

However, this is something that we need to send as feedback to our product developers. Our team will review your suggestion and might include this in the product updates. Let's follow the steps below and share with them the benefits of this option.

 

  1. Open the QuickBooks Desktop program and select the Help menu.
  2. Click on the Send Feedback Online and choose Product Suggestion.
  3. Fill out the details needed and select Send Feedback.

 

We can review these articles for guides about doing some inventory tasks within your company file.

 

 

We'll be around if you have other concerns about tracking inventory items and other things related to QuickBooks. 

Terms & ConditionsAccessibility statement