cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

Open Invoices Report Doesn't Sort By Name

The Open Invoices report displays the customers in some random order. Clicking on the column headings doesn't change anything - doesn't re-sort by date or any other option.

I've verified and rebuilt the data, closed the file, and re-opened the program, and it's still doing it. 

It does this on all of the Receivables reports, not just Open Invoices, but that's the primary one I work from and have to give copies to the executive team.

This is making me crazy - I need the report to show the customers in alphabetical order. It used to do it as the default sort, but now - who knows what the logic is?

Solved
Best answer 12-10-2018

Best Answers
Highlighted
Level 8

Open Invoices Report Doesn't Sort By Name

Try resorting the mast names list. Go to write checks enter command+L in the pay to field, select edit>resort list.

View solution in original post

10 Comments
Highlighted
Level 8

Open Invoices Report Doesn't Sort By Name

Try resorting the mast names list. Go to write checks enter command+L in the pay to field, select edit>resort list.

View solution in original post

Highlighted
Level 3

Open Invoices Report Doesn't Sort By Name

It worked! Thank you so much!
Highlighted
Level 8

Open Invoices Report Doesn't Sort By Name

You're welcome.
Highlighted
Level 1

Open Invoices Report Doesn't Sort By Name

Hi Is this solution applicable to Qb 2015 for Mac? I am experiencing the same problem.
Highlighted
Level 8

Open Invoices Report Doesn't Sort By Name

Yes
Highlighted
Level 1

Open Invoices Report Doesn't Sort By Name

Thanks
Highlighted
Level 1

Open Invoices Report Doesn't Sort By Name

We use QB Desktop, 2017, and we experience the same issue.

When I run the "Open Invoices" report, QB makes it in the order which is from the last created Customer. And we want from A-to-Z.

So as SkinnyRaven suggests:

I went to "write checks";
then staying in the "pay to "Pay to" field I've clicked Ctr+L,  and now I see the list called "Name List" that consists of all.
then
I go to "EDIT" from the upper menu, but I don't see the "resort list" in the "Edit".

what I'm doing wrong?
Highlighted
Level 15

Open Invoices Report Doesn't Sort By Name

"We use QB Desktop, 2017,"
That is PC. This topic is for Mac.

"I go to "EDIT" from the upper menu, but I don't see the "resort list" in the "Edit"."

View menu > ReSort List.
Highlighted
Level 1

Open Invoices Report Doesn't Sort By Name

Thank you. I didn't know it's Mac's forum. wheni've googled, this was the only page regarding QB
anyway, I've found the way for PC (and anybody like me get's this page so there is a solution:

1. open "Write Checks" window.
2. Place the cursor in the Pay to the order of field, and press Ctrl-L
3. This opens the master "Name List'.
4. look at the bottom and:
     4.a. - Check the "Include Inactive" checkbox (this is important!),
     4.b. - click the "Name" button, and select "Re-sort List".
5. Restart QB

that's it.
Highlighted
Level 15

Open Invoices Report Doesn't Sort By Name

This is a Mac Topic, on the QB User forum. Mac has the Command Key; PC has the Control Key. That's how you know they are Different.

"click the "Name" button, and select "Re-sort List"."

PC Desktop "View Menu" has it, as well. Mac has it on the Edit Menu.

These programs are Different.

"5. Restart QB"
You didn't need to Restart it.

Need to get in touch?

Contact us