cancel
Showing results for 
Search instead for 
Did you mean: 
NSbookkeeper
Level 2

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

When I run a Sales by Item report, I get all the columns I need, but I cannot get it to show a column that displays the Manufactuer's Part Number. I need to see that column as well. Any tricks to display that? Thank you

12 Comments 12
Ashley H
QuickBooks Team

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!

NSbookkeeper
Level 2

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

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?

GraceC
QuickBooks Team

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

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!

NSbookkeeper
Level 2

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

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.

MJoy_D
Moderator

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

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!

Nelsont2
Level 1

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

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

Joseph_A
QuickBooks Team

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

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!

 

 

 

1080
Level 1

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

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. 

MW-Lisa
Level 1

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

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.

AlexV
QuickBooks Team

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

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!

1080
Level 1

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

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!

Nicole_N
QuickBooks Team

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

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us