Exporting Manufacturer's Part Number

Thank you for your prompt response. This is exactly what I needed. I appreciate it.

Hi KAY15. 

We're glad to hear you got the help you needed. If there's anything else we can help with, feel free to post down below. 

Thanks for dropping by and have a lovely weekend. 

How do you list the MPN field in an inventory report?  I have inventory in multiple sites that needs to be coutned and I use the MPN field for the inventory SKUs so I need the MPN column on the inventory report

Thank you for joining the thread, @doug_martin.

Allow me to share additional details about running reports in QuickBooks Desktop.

At this time, we can only add the MPN information or field on the Item Listing report. Displaying the field on any Inventory report is currently unavailable. The good news is, you can open both reports, export them to Excel, and customize the information from there to add the MPN field on your inventory report.

To export the report to Excel:

1. From the report's page, click on the drop-down arrow under the Excel tab, then select Create New Worksheet.
2. Click on the Create new worksheet radio button, then tap in a new workbook.
3. Hit Export. Replicate the steps for the two reports (inventory and item listing).

Once completed, add the details from the MPN field from the Item Listing report to your Inventory report.

To learn more about the basic information about reports in QuickBooks Desktop, feel free to read the details from this article: Customize reports in QuickBooks Desktop.

Once done, you can also read the topics from our help articles in case you need related resources while working with QuickBooks.

Post again if you have any other questions. I'm a few clicks away to help. Keep safe always!

Similarly, I am trying to print the Manufacturer's Part Number on an Open Purchase Order Report.

When dealing with Purchase Orders and the applicable Vendor, we always refer to their number not ours. I am surprised that I can't add this field to any of my Purchase Reports.

Is there a work around other than creating a custom field and double populating it so that I can print it on a report?

Hello, KimAEInc. 

Thank you for reaching out to the Community. We can open a report and export them in Excel. From there, you can customize the field you'd like to add on. 

You can follow my colleague's steps above on how to perform the exporting in QuickBooks. 

For further insights about customizing reports, I recommend checking below articles: 

• Customize reports in QuickBooks Desktop 
• Export reports as Excel workbooks in QuickBooks Desktop 

The Community has your back, so please let me know if you have questions or need additional help. Have a great day.

So.... let me see if I understand you correctly...

If I want to show the MFR Part# on an Open PO report, I will need to pull two reports. 

1. The Open PO report

2. The Item List

Then I need to VLookup the MFR Part# from the item list and display it in my Open PO Report.

Is this what you're saying??

Thanks for getting back to this thread, @KimAEInc. Allow me to clarify things for you.

You are right about what my colleague is trying to say. 

To show the MFR Part # on an Open PO report, you will need to pull two reports. Then, export this to Microsoft Excel. From there, add the MFR Part# from the item list and display it in my Open PO Report.

You can follow the steps provided by my colleague above on how to export reports. Otherwise, check this article for the detailed procedure: Export reports as Excel workbooks in QuickBooks Desktop. 

In addition, let me share this resource for you to better understand the functionality of reports in QuickBooks Desktop: Understand reports.

Keep me posted if you have other questions about managing reports in QuickBooks. I'll be happy to lend a helping hand. Stay safe always!

Is it possible to add the Manufacturer's Part Number field to be included in printing the assembly Bill of Materials?

I've included a sample of what the print-out currently looks like through Quickbooks. Would love to be able to add MPN as one of the columns here.