Skip to main content
N
NSbookkeeper
February 14, 2020
Question

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

  • February 14, 2020
  • 2 replies
  • 0 views

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

    2 replies

    Ashley H
    Ashley H
    February 14, 2020

    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!

    N
    NSbookkeeperAuthor
    February 14, 2020

    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?

    G
    GraceC
    February 14, 2020

    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!

    MJoy_D
    MJoy_D
    February 15, 2020

    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!

    Terms & ConditionsAccessibility statement