cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
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.

 

 

 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up