Skip to main content
NSbookkeeper
Feb 14, 2020 7:57 PM UTC
Question

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

    14 replies

    Ashley H
    Ashley H
    Feb 14, 2020 8:40 PM UTC

    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!

    NSbookkeeperAuthor
    Feb 14, 2020 8:48 PM UTC

    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
    Feb 14, 2020 10:34 PM UTC

    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
    Feb 15, 2020 4:05 PM UTC

    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