cancel
Showing results for 
Search instead for 
Did you mean: 
HTF
Level 1

Listing Paid Invoices Containing a Particular Product/Line Item

I have searched Google and this forum for the answer, but couldn't find it.

 

I want to make a list of all paid invoices with a particular product/line item (2018 Dues). I then want to use that list to create copies of those invoices for this year's billing (2019 Dues).

 

Is there an easy way to do this? I can't seem to find a filter to show me only invoices with a particular product as a line item.

 

Also, is there an easier way to manage annual dues/fees?

 

8 Comments 8
FritzF
Moderator

Listing Paid Invoices Containing a Particular Product/Line Item

Hi there, @HTF.

 

Welcome and thanks for posting here in the Community. I can help pull up the list that you need in QuickBooks Online (QBO).

 

Yes! There's an easy way to pull up the list that has all the paid invoices with a particular product/line item, and that is through Sales by Product/Service Detail report. This report will also help you mange your annual dues/fees in QBO. All you need to do is to make some tweaks on it by simply customizing the report to show all the information.

 

Here's how:

 

1. Go to Reports menu on the left pane.
2. On the search bar, type Sales by Product/Service Detail.
3. Change the Date to This Year.
4. On the Group by drop-down, select Product/Service under Rows/columns.
5. Now, click Customize on the upper right, then go to Filter.
6. Choose Invoice as the Transaction Type.
7. Select the specific product/line item on the Product/Service.
8. On the A/R Paid, choose Paid.

9. Once done, click Run report.

 

That should get you the list with all the paid invoices. For future reference, you may visit this article that tackles customizing reports in QBO: Customize reports.

 

I'd be glad to continue assisting if you should have any additional questions. Wishing you and your organization continued success.

HTF
Level 1

Listing Paid Invoices Containing a Particular Product/Line Item


Yes! There's an easy way to pull up the list that has all the paid invoices with a particular product/line item, and that is through Sales by Product/Service Detail report.

 

1. Go to Reports menu on the left pane.
2. On the search bar, type Sales by Product/Service Detail.
3. Change the Date to This Year.
4. On the Group by drop-down, select Product/Service under Rows/columns.
5. Now, click Customize on the upper right, then go to Filter.
6. Choose Invoice as the Transaction Type.
7. Select the specific product/line item on the Product/Service.
8. On the A/R Paid, choose Paid.

9. Once done, click Run report.

 

That should get you the list with all the paid invoices.

Hi, Fritz. Thank you for the help.

 

I had gotten that far. My question was more for the All Sales/Invoices screens. On the report screen, there is no drop-down for the invoice that lets me select "Copy." From the report screen, I have to click the invoice, then copy it from there. I was hoping to be able to use the Product filter on the https://c32.qbo.intuit.com/app/sales screen to give me the same list, then just one click to the Copy.

 

Thank you, again, for the help! I guess if this is the only way to do it, then that's how it has to be done.

HTF
Level 1

Listing Paid Invoices Containing a Particular Product/Line Item

Also, is there a way to sort the report by Customer instead of by Date?

Found the answer to this one! :-)

 

HoneyLynn_G
QuickBooks Team

Listing Paid Invoices Containing a Particular Product/Line Item

Good day, @HTF.

 

I can share more information about reports in QuickBooks Online.

 

Yes, there's a way to sort the report by Customer instead of by Date. Let me show you how to filter the Sales by Product/Service Detail report:

  1. Click Customize.
  2. Click the Rows/Columns drop-down arrow.
  3. For Group by, choose Customer.
  4. Click Run report to refresh the report.

To learn more about customizing reports, you can refer to this article: https://community.intuit.com/articles/1614765-customize-reports.

 

That should do it. Keep us posted if you have other concerns about reports. Wishing you and your business continued success. 

Mikes_RV_Towing
Level 1

Listing Paid Invoices Containing a Particular Product/Line Item

It appears there have been some updates to the Quickbooks Online user interface since this answer was given.

 

How do I do this now that there is no longer a "group by" option?  All I can access with these instructions is a summary of total sold for a particular product.

 

Also, the linked help page is gone from that location.  :/

MirriamM
Moderator

Listing Paid Invoices Containing a Particular Product/Line Item

Hi there, @Mikes_RV_Towing.

 

It's my priority that you'll be able to run the report you need in QuickBooks Online (QBO).

 

I've replicated this in my sample QBO account to be sure, and when I try to pull up the Sales by Product/Service Detail report, the Group by option is there.

 

To isolate the issue, let's try opening your account in a private (incognito) window. Using a safe browser and accessing the program from there can usually fix the issue.

 

Check out these keyboard shortcuts:

  • Command + Shift + N (Safari)
  • Ctrl+ Shift + N (Google Chrome)
  • Ctrl + Shift + P (Mozilla Firefox) 

 

Once done, try to run the report again. If this works in incognito, we can try clearing your Internet cache. Before doing so, ensure to close the browser after clearing for the changes to take effect. See Clear cache and cookies to fix issues when using QuickBooks Online for more information.

 

Otherwise, switch to a different browser like Firefox, Google Chrome, or Safari. The one you are currently on maybe have a temporary issue with QuickBooks, and using a new browser for the moment will allow you to get back to work.

 

To learn more about how to run a report in QBO, visit these articles:

 

Please let me know how it goes. I'll be looking forward to hearing back from you. Have a great day!

Susie28
Level 1

Listing Paid Invoices Containing a Particular Product/Line Item

Mikes_RV_Towing did you ever figure out how to do this? I need to figure this out too but the instructions don't work. 

ChristieAnn
QuickBooks Team

Listing Paid Invoices Containing a Particular Product/Line Item

Welcome to the QuickBooks Community, Susie28. I can see how important to figure out some things in QuickBooks Online to help run your business. With this, let me share extra details about customizing a report in our program and ensure you can see the Group By option.

 

You can always have the option to format the layout so the right data shows up in the right place. That being said, you can always see the Group by option under the Rows/columns and below the Report period drop-down. I attached a screenshot below for visual reference.

 

gb.PNG

If the issue continues after following the steps shared by my colleague MirriamM, I recommend contacting our QuickBooks Support Team. They have the tools to pull up your account in a secure environment which we're unable to do it here in the Community. That way, they'll be able to investigate the cause of why the Group By option is missing.

 

Here's how to contact them:

 

  1. Open your QuickBooks Account.
  2. At the top right, click the Help icon.
  3. Choose the Assistant section.
  4. Type your concern in the Type something field.
  5. Click Talk to a human.
  6. Click I still need a human.
  7. Click the Get help from a human.
  8. You'll be routed into the How can we help? page. Then, select how you want to contact them and fill in the information.

 

You can also browse this article to learn more about the different types of support we offer at Intuit and its availability: Support hours and types.

 

Lastly, you may refer to this article to see steps on how you can print, email, and export different reports in QBO: Run reports in QuickBooks Online.

 

Please know that we aim to deliver customer satisfaction at all times that's why we fix an issue as soon as possible. With this, you can click the Reply button below if you encounter a specific error message. I'm always here to help, Susie28.

Need to get in touch?

Contact us