Skip to main content
K
KAY15
June 19, 2020
Solved

Exporting Manufacturer's Part Number

  • June 19, 2020
  • 2 replies
  • 0 views

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?

Best answer by SashaMC

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!

2 replies

S
SashaMCAnswer
June 19, 2020

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!

    K
    KAY15Author
    June 19, 2020

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

      N
      Nick_M
      June 19, 2020

      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. 

      J
      jsharpe
      February 13, 2023

      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