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

remove grouping from report

I want to create a report similar to the Open Invoices report, but without any grouping. It should be a simple list of open invoices, sorted by due date, but not grouped by customer or job.

 

It would also be great if I could add a customer phone number column.

 

We plan to use this report as an easy way to start calling all our late pays.

Solved
Best answer November 22, 2023

Best Answers
ChristieAnn
QuickBooks Team

remove grouping from report

Hello there, eomerspider. 

 

I've got steps so you can create a report that is similar to Open Invoice without grouped by customer in QuickBooks Desktop. 

 

I suggest using the Custom Transaction Detail report, where you can filter to display only open invoices, their due dates, and the phone number column.

 

Here's how:

 

  1. Click the Reports menu at the top.
  2. Choose Custom Reports and Transaction Detail.
  3. Select the Customize Report button.
  4. Choose TypeName, Phone #Due date, and Paid in the search column field.
  5. Go to the Filters tab.
  6. Select Transaction Type on the search bar and choose Invoice.
  7. Choose Paid on the search bar and click the Open radio button so you'll be able see all the unpaid/open transactions.
  8. Click OK to save the customization.

 

In case you need steps to memorize reports in QBDT so the same settings of the customized data will be available for future use, you can refer to this article: Create, access and modify memorized reports.

 

You can always reply or reach out to us again if you need further assistance in customizing reports in QBDT. I'll get back here as soon as I can to help you again, eomerspider. Take care!

View solution in original post

3 Comments 3
ChristieAnn
QuickBooks Team

remove grouping from report

Hello there, eomerspider. 

 

I've got steps so you can create a report that is similar to Open Invoice without grouped by customer in QuickBooks Desktop. 

 

I suggest using the Custom Transaction Detail report, where you can filter to display only open invoices, their due dates, and the phone number column.

 

Here's how:

 

  1. Click the Reports menu at the top.
  2. Choose Custom Reports and Transaction Detail.
  3. Select the Customize Report button.
  4. Choose TypeName, Phone #Due date, and Paid in the search column field.
  5. Go to the Filters tab.
  6. Select Transaction Type on the search bar and choose Invoice.
  7. Choose Paid on the search bar and click the Open radio button so you'll be able see all the unpaid/open transactions.
  8. Click OK to save the customization.

 

In case you need steps to memorize reports in QBDT so the same settings of the customized data will be available for future use, you can refer to this article: Create, access and modify memorized reports.

 

You can always reply or reach out to us again if you need further assistance in customizing reports in QBDT. I'll get back here as soon as I can to help you again, eomerspider. Take care!

eomerspider
Level 1

remove grouping from report

This is great! Thank you QB team.

Tori B
QuickBooks Team

remove grouping from report

On behalf of my colleague above, you're certainly welcome, @eomerspider

 

Please reach back out to the QuickBooks Community anytime you need a helping hand. We've got you covered. Take care!

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

Need to get in touch?

Contact us