Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
MTS2022
Level 1

How to get the Manufacturers part number on the item List report

Currently the Items List does not show "Manufacturer Part Number" as a field that can be added to the Items List report. 

How can I get "Manufacturer Part Number" to show up in the Available Columns

Solved
Best answer February 28, 2022

Best Answers
BigRedConsulting
Community Champion

How to get the Manufacturers part number on the item List report

Add the column/field "MPN" to the item report.

View solution in original post

10 Comments 10
BigRedConsulting
Community Champion

How to get the Manufacturers part number on the item List report

Add the column/field "MPN" to the item report.

MTS2022
Level 1

How to get the Manufacturers part number on the item List report

Boy, it must be a long day!  We were looking for the spelled out version not the abbreviation!

 

Thanks so much!

GlinetteC
Moderator

How to get the Manufacturers part number on the item List report

Welcome back to the Community, MTS2022.

 

I understand that you need to have the spelled out Manufacturer's Product Number (MPN) to show on your report. However, the option is unavailable.

 

While this isn't available yet, I suggest sending feedback to our engineers. We consider our customer suggestions when looking for product improvements and ways to enhance QuickBooks.

 

  1. Go to the Help menu, select Send Feedback Online, then choose Product Suggestion.
  2. On the pop-up, enter a short description.
  3. Click Send Feedback.

 

You can check all new features added and see all our latest news by visiting our QuickBooks blog.

 

If you need help in customizing reports, please check this link: Customize reports in QuickBooks Desktop.

 

Keep on posting if you have any other questions. The Community is always here to help.

nancy2005
Level 1

How to get the Manufacturers part number on the item List report

You can add the mpn to your list but has no value when you run the report??

 

Bryan_M
QuickBooks Team

How to get the Manufacturers part number on the item List report

I appreciate you for joining the thread, @nancy2005.

 

For me to help you. Would you mind sharing a screenshot of what report did you pull up that shows MPN no value? This way, I can see what's on your end and what type of error it must be.

 

If you have additional queries about managing your reports, feel free to reply to this post. I'll be willing to help you. Take care and have a good day!

FUSE IT Sheila
Level 1

How to get the Manufacturers part number on the item List report

I have Enterprise 23.0.  I need a report that shows the MPN so I can easliy import a price increase's  from manufactures. I am not seeing any info here on how to do that.  

RhoiceW
QuickBooks Team

How to get the Manufacturers part number on the item List report

Welcome to the Community, Sheila. Thank you for joining this thread. I can assist you and provide the steps for adding the MPN to your reports.

 

Here's how:

 

  1. Go to Reports, then choose Report Center.
  2. Search for the Item Listing report.
  3. Double-click the report to open it.
  4. Click Customize Report. On the Display tab, type in MPN in the column search bar.
  5. Mark the MPN as a check. Then tap OK.

 

Additionally, you can check on this article to learn how to customize your reports: Customize reports in QuickBooks Desktop

 

You can leave a comment if you still have concerns about running your reports. I'm here to help you always.

fvc
Level 1

How to get the Manufacturers part number on the item List report

How do we add a MPN number to our Purchase Orders?   We just switched from Desktop to QBO and are looking for some guidance.   We order the same product from several vendors and need to keep their mfn numbers for each vendor. 

 

KayePe
QuickBooks Team

How to get the Manufacturers part number on the item List report

Hello there, @fvc. In QuickBooks Online, there's no specific field for MPN. However, you can enter the item's MPN in the Description column when creating a purchase order.

 

po.png

 

Note that you don't need to add the MPN from the general item setup, as you source this product from multiple vendors. To ensure the correct number is used for each supplier, please continue entering it in the item Description on the Purchase Order itself.

 

Let us know if you have additional concerns. 

SIAB
Level 8

How to get the Manufacturers part number on the item List report

@fvc 

If you run a manufacturing company or workshop, consider having a manufacturing app to sync with QBO.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us