cancel
Showing results for 
Search instead for 
Did you mean: 
shaysler
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 December 10, 2018

Best Answers
SkinnyRaven
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
SkinnyRaven
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

shaysler
Level 3

Open Invoices Report Doesn't Sort By Name

It worked! Thank you so much!
SkinnyRaven
Level 8

Open Invoices Report Doesn't Sort By Name

You're welcome.
Sheila3
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.
SkinnyRaven
Level 8

Open Invoices Report Doesn't Sort By Name

Yes
Sheila3
Level 1

Open Invoices Report Doesn't Sort By Name

Thanks
pinkasb
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?
qbteachmt
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.
pinkasb
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.
qbteachmt
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.
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us