How can I show Manufacturer's part number as a column on the Sales by item Summary report

Hello, @NSbookkeeper.

At this time, adding Manufacturer's Part Number as a Column in QuickBooks Desktop is not available. I'm going to submit feedback to our Product Development Team about bringing in this feature. In the meantime, you'll want to manually add this column in Excel. Here's how:

1. Go to Reports > Sales > Sales by Item Summary.
2. Press on the Excel drop-down menu at the top of the report page, then Create New Worksheet.
3. Select Create New Worksheet and In New Workbook.
4. Hit Export.

I'm always here if you have more questions. Have a safe weekend!

Thanks for the response but all that does is export the same report into Excel. It still doesn't show the manufacturer's part and it would take me hours to manually fill that into Excel myself. Is there any way to get the item description into the report or am I limited to the preset columns?

Hello there, @NSbookkeeper.

You can pull up the Sales by Item Detail report to include the description to each transaction. Let me guide you how.

Here's how:

1. At the top menu bar, click Reports.
2. Select Sales.
3. Click Sales by Item Detail. 

If you need to customize the report, you can follow the steps in this article for the detailed steps: Customize reports in QuickBooks Desktop. 

Let me know if you have any other questions by adding a comment below, I'm always here to help. Have a good day ahead!

Thanks but that report doesn't give me anything I need. I need the info on the Sales by Item Summary report such as Cost of Goods, gross profit, gross profit margin, etc for each of the items.

You can run Gross margin by inventory item report, @NSbookkeeper.

This report lists inventory items and highlights sales, cost of goods, and gross margin per inventory item.

1. Go to the Reports menu.
2. Click Industry Specific and choose Retail.
3. Run the Gross Margin by Inventory Item.

You can double-click a particular item to view its detailed sales history.

Here's more information on how to create, access and modify memorized reports. 

I'm always here if you need help in generating the report that you need. Have a wonderful day!

Hi Ashley,

I too have the same need for a "sales report" that includes the MPN.  

Are there any updates to report on your efforts to have this field (MPN) included as a custom option within sales or inventory reporting?

Also, is there any other sales or inventory report that can be ran that includes the MPN filed?

Thanks,

TN

Hello there, @Nelsont2.

I had tried replicating it on my end, I can only see the PMN on the item listing since that's an item's identification. As an update, there is no option to add the MPN column on a report.

To know more about reports, feel free to read this article: Customize reports in QuickBooks Desktop.

Comment below if you have additional questions, have a great day!

Why is this not supported in Quickbooks? I see this was submitted 7 months ago- how come the developers have not addressed it? Not having the ability to add an MPN really limits the usefulness of the reports. 

Have the developers made any updates to the ability to add MPN to reports? I would think all inventory fields would be a option in reports. It would also be nice to have an alternate MPN so if you have 2 sources you don't have to keep overriding the default and change back and forth.

Thanks for joining us here, MW-Lisa.

I understand that you also need to add the Manufacturer's Part Number when running a report. While this isn't available yet, I suggest sending feedback to our engineers. A feature request is more likely to be implemented if they received more feedback about it.

1. Go to the Help, 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 blog.

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

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

It's worthwhile to point out that I found a report that enabled me to add MPN's. I had to go to Item listing and that report allowed me to customize it to add MPN's. However- it honestly doesn't make sense to me that the included reports still have no ability for me to customize them to add MPN's. If it's a supported field in QB- it should be a very simple thing!

Hi, @1080 thanks for getting back. It's good to know that you've found a report that enables you to add a column for Manufacturer's Part Number.

I can see how convenient it is for you to have the ability to add MPNs for the reports. For now, it's best to relay your feedback to our Product Developers. This way, they can review which parts of the program need enhancements and consider adding them to future updates. 

Here's how to submit your feedback:
 

1. Go to the Help menu.
2. Select Send Feedback Online then choose Product Suggestion.
3. Enter your suggestion.
4. Click Send Feedback.

You'll want to visit this article to learn more about managing reports in QuickBooks Desktop: Create, access, and modify memorized reports. 

Feel free to leave a reply if you have any other questions about running reports. I'm here to answer them for you. Have a nice day!

no one has addressed the original problem. when I enter a PO it has my item number and the MPN. when I go to enter the bill the MPN does not populate. if you have a bill with many items you now have to cross reference to the PO and the vendors bill and then update anything not sent or any price changes. this would be SO EASY if the bill I am entering from the po had the MPN - the vendors rarely align their bills in the same order as my PO - they all have their own ordering of their numbers. You cannot just add this column to the bill template, which is ridiculous as it's right there on the PO. PLEASE fix this - we should not have to run reports to efficiently enter a bill............................. fix this please - it should be easy..................

I understand how important it is to enter bills efficiently without running reports, walkermachine. I want to ensure that your idea about the Manufacturer Part Number (MPN) from purchase orders (POs) automatically populating in bills gets the attention it deserves.

Currently, the ability to automatically populate MPNs from purchase orders (POs) into bills is unavailable. However, we value your feedback and suggestions for improving our product. In this case, I recommend submitting your feature suggestion to our Product Development Team. Your recommendations are valuable to us as they help us identify areas for improvement. Our Development Team will review your suggestion for further consideration.

Here's how:
 

1. Go to the Help menu at the top.
2. Select Send Feedback Online.
3. Click Product Suggestion.
4. Click on the drop-down for Type of Feedback and select Product Suggestion.
5. Select the Product Area.
6. Enter your thoughts and suggestions.
7. Click Send Feedback.

Moreover, I've added this article as your reference in personalizing your generated report: Customize reports in QuickBooks Desktop.

Let us know if you have additional questions or concerns about entering bills in QuickBooks Desktop (QBDT). The whole community is always here to help.