Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
lttlebebop
Level 1

open invoice report sorted by sales rep

can anyone help me get an open invoice report sorted by the sales rep?  Even when i change the sort by column within the open invoice report is still only sorting by customer names.

Solved
Best answer December 06, 2021

Best Answers
BigRedConsulting
Community Champion

open invoice report sorted by sales rep

You can't change the canned Open Invoices report because it is hard-coded to subtotal by customer.

 

However, you can create your own version of the report that you can sort.

 

To do this, start on the Reports menu and Pick Custom Reports | Transaction Detail.

Then modify the report as follows:

Filters:

- Remove the Date Filter

- Add the Account filter and set it to All accounts receivable

- Add the Detail Level filter and set it to Summary Only

- Add the Paid Status filter and set it to Open

 

Display | Columns:

- Add the Rep and Aging and Open Balance columns and any other desired columns.

- Remove unwanted columns.

- Set Sort By to Rep

 

Run the report.  It'll have the same data as the open invoices report, only you can sort it any way you want, on any column you include on the report.

 

 

 

View solution in original post

1 Comment 1
BigRedConsulting
Community Champion

open invoice report sorted by sales rep

You can't change the canned Open Invoices report because it is hard-coded to subtotal by customer.

 

However, you can create your own version of the report that you can sort.

 

To do this, start on the Reports menu and Pick Custom Reports | Transaction Detail.

Then modify the report as follows:

Filters:

- Remove the Date Filter

- Add the Account filter and set it to All accounts receivable

- Add the Detail Level filter and set it to Summary Only

- Add the Paid Status filter and set it to Open

 

Display | Columns:

- Add the Rep and Aging and Open Balance columns and any other desired columns.

- Remove unwanted columns.

- Set Sort By to Rep

 

Run the report.  It'll have the same data as the open invoices report, only you can sort it any way you want, on any column you include on the report.

 

 

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us