Add Custom Data Figure to Sales By Item Summary/Detail Report

Thank you very much for this! This is helpful, but having to sum up the Sales by Item Detail Report is still time consuming. Is there any means by which a custom column can be added to the Sales by Item Summary Report?

It's great to hear again from  you, @rsteve06.

With QuickBooks Desktop, you have the ability to customize your Sales by Item Summary report to include the specific information you need.

The Sales by Item Summary Report shows the following:

• How many items were sold?
• What is total sales?
• Which among your list of items or product brings in most or least income?

If I may ask, did you add Net Weight as one of the columns in your Sales form (Invoice, estimate or sales receipt)? If yes, was it added as an additional column?

Here's how to customize reports:

1. Go to Reports.
2. Choose Reports Center.
3. Click Sales.
4. Look for Sales by Item Summary report.
5. Click the green arrow to run report.
6. Click Customize  Report.
7. Choose Filters tab.
8. Add the specific column you want to add.
9. Click Ok.

If you need further assistance with the steps above, I'd recommend contacting our Customer Care Team. A specialist will be able to access your account on a secured environment and further help help you via secured remote access session.

Here’s how you can reach them:

1. Click the Help menu.
2. Choose QuickBooks Desktop Help.
3. In the Have a Question window, click Contact us at the bottom portion of the screen.
4. Click Search for something else.
5. Type in a keyword about your concern.
6. Hit Search.
7. Click on Start a Message.

Stay in touch with us here in the Community if your have other questions about generating and customizing sales reports in QuickBooks Desktop. I'm here to help.

By adding a filter with a Net Weight specified it will only let me see items that have that Net Weight. The Net Weight of each item is not displayed even in this custom report. I'd like a way to run the Sales by Item Summary Report and have the Net Weight of each item listed appear in its own column. This would let me export the report to Excel, and multiply the quantity sold times the net weight of each item to calculate weight sold.

I forgot to note that there is now a Net Weight field on both Sales Orders and Invoices. The Net Weight of each item we produce now appears in the Sales By Item Detail Report, but not in the Sales by Item Summary Report. As you can imagine, trying to calculate the weight sold to each customer with a group of items is more difficult if limited to the Sales By Item Detail Report as it is hundreds of pages long. Being able to sum up the rows in a Sales By Item Summary Report would be much less time consuming! Thanks again.

Hello again, @rsteve06.

I appreciate you coming back and providing us the result. 

Since you've already followed the steps on my initial post and the Net Weight field still isn't reflecting on the customized report, I'd recommend calling our phone support.

You can scroll up a little and go to juVielL's answer to get our phone directory. Our phone agents can initial a screen sharing session with you to help you more with the process.

Keep me posted on how the call went, rsteve06. You can add a comment or mention my name. Have a good one.

Hello All,

Just checking in here...  I read the whole post, but the answers that the Moderator were giving were for the Item by sales Detail report. 

What we need is the Weight to be added to the Item by sales Summary Report instead...  As the Summary report does not give you the option of Customizing in the Display tab...

Any help on this?

Linda

Hello All,

Just checking in here.  I have read the whole post, and am also looking for the answer here...

All the answers the Moderator work great on the Sales by Item Detail report.

But what we need is the Weight to show up on the Sales by item Summary Report...

Is there a way for that?  I have added the Custom Field, and clicked 'Use'. I have added it to the Invoice template.  I can pull up the Custom Field on the report, int he Filter tab, not the Display tab, obviously, as the Display tab, there is no way to add anything to the report.  The Net Weight Field will come up, but then it asks me to select which value I would like to pull... We have several different weights, and I want it to pull all of them.

I have tried entering the weights separated by a semi colon, but the report goes blank.  I tried entering just one of the weights, and the report still went blank.

Any thought?

Linda

I appreciate you trying my recommendations above, @orderdesk.

You won't be able to add and use Weight as a filter option since its setup was for the custom field. The option to group or add the column is unavailable in the Summary report.

You can use the Detail report for now. To get the total amounts, export it to Excel and do the totals there. But I get your point and its useful effects, and I'm sending your feedback to our developers on your behalf.

Meanwhile, you can check our blog site to know the latest update of QuickBooks.

Thank you for taking the time to share your thoughts in this forum for other users to see. I'll be here to lend you a helping hand if you have other concerns. 

When custom fields are entered, is there a way to set it automatically calculate?  For example:  I put a custom field for Net Weight as 105 lbs.... Then on the sales order I put that item in with a quantity of 5.... it should calculate to a total net weight of 525 lbs. 

Thanks for visiting the Community! Currently, there isn't a way for that, but I see the benefit of this. I will go ahead and submit feedback about including a future feature like this. I encourage you to do the same by filling out the form below.

• Submit Feedback

In the meantime, though, you could use a third-party app to accomplish what you need. Feel free to use this link below and find the one that matches your needs.

• Third-Party Apps

Don't hesitate to let me know if you have any questions or concerns. I will be around. Bye for now.