Skip to main content
KAY15
Jun 19, 2020 6:04 PM UTC
Solved

Exporting Manufacturer's Part Number

I need to export the Manufacturer's Part Number in the Item List. I don't see it as an option on Customize Report. It is possible to export this field by item?

SashaMCAnswer
Jun 19, 2020 7:02 PM UTC

Thank you for reaching out to the QuickBooks Community, KAY15. Yes, it is possible to export the Manufacturer's Part Number by item through some customization. Here's how:

 

  1. Go to the Reports tab, then List, and select Items Listing.
  2. Once that report appears, click the Customize Report tab.
  3. In the Modify Report screen, under Columns, put a checkmark next to MPN (Manufacturer's Part Number). At this stage, you can make adjustments to unselect or select what you would like to see displayed on the report.
  4. Click OK once completed.
 

Now, you can print, email, or export the document as you wish by select one of the options above the report. For more information about customizing reports or exporting data in Quickbooks Desktop, these articles are very resourceful.

 

 

Please let me know if you have any other questions or need clarification. I will be just a Reply away. Know that the Community and I are here to cater to your needs at any time. Have a lovely weekend!

View in thread

10 replies

SashaMCAnswer
Jun 19, 2020 7:02 PM UTC

Thank you for reaching out to the QuickBooks Community, KAY15. Yes, it is possible to export the Manufacturer's Part Number by item through some customization. Here's how:

 

  1. Go to the Reports tab, then List, and select Items Listing.
  2. Once that report appears, click the Customize Report tab.
  3. In the Modify Report screen, under Columns, put a checkmark next to MPN (Manufacturer's Part Number). At this stage, you can make adjustments to unselect or select what you would like to see displayed on the report.
  4. Click OK once completed.
 

Now, you can print, email, or export the document as you wish by select one of the options above the report. For more information about customizing reports or exporting data in Quickbooks Desktop, these articles are very resourceful.

 

 

Please let me know if you have any other questions or need clarification. I will be just a Reply away. Know that the Community and I are here to cater to your needs at any time. Have a lovely weekend!

    KAY15Author
    Jun 19, 2020 7:15 PM UTC

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

      Nick_M
      Jun 19, 2020 7:49 PM UTC

      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. 

      jsharpe
      Feb 13, 2023 3:55 PM UTC

      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.

      Terms & ConditionsAccessibility statement