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

QB 2016 Open Invoices report no longer sorted in chronological order

I need my Open Invoices report to sort by customer name and then each open invoice for that customer to be listed in chronological order, oldest invoiced date first. My report has always generated in this manner and now today it is listing the invoices out of order.

 

When I click on "date" on the report, it sorts the entire report by the date so the report is no longer in alphabetical order by customer name. I have searched the Q&A section but have not been able to find an answer that has worked for me. I already attempted "edit" and "re-sort list" but that did not affect this report.

 

Thanks for any help provided.

5 Comments 5
CarlSJ
QuickBooks Team

QB 2016 Open Invoices report no longer sorted in chronological order

Allow me to assist you in ensuring you'll be able to run an open invoice report where you can see your desired details in QuickBooks Desktop for Mac, ABerg. 
 
We can toggle the report from Descending to Ascending to refresh the report. This way, it will show the customer's name in order when running the report. Also, make sure to manually enter the correct period in the Date field. Let me guide you how:
 
  1. Access the Open Invoices report.
  2. Go to Customize Report, and select Display.
  3. Filter out the required Dates.
  4. Select Default from the Sort by, toggle Descending order, and click OK.
  5. Tap Refresh.
  6. Go back to Customize Report, and select Display.
  7. Put a checkmark next to each column that you want to appear in the report.
  8. This time, toggle Ascending order, click OK, and tap Refresh.
 
If the same thing happens, we'll need to re-sort the customer lists only. It makes your lists go back to their default order. So if you have manually changed the order of your list, re-sorting will undo these changes. Here's how:
 
  1. Go to the Customer Center.
  2. Click Edit at the top left of QuickBooks.
  3. Select Re-sort List
  4. Tap OK.
 
If the problem persists, we can verify and rebuild your data in QuickBooks Desktop for Mac to fix any damaged data issues. Just follow the steps and details in this article: Verify and rebuild data in QuickBooks Desktop for Mac.
 
Feel free to visit the Help Article page for more insights about managing your business in QuickBooks Desktop for Mac.
 
Please come back and keep us posted on your progress in performing the recommended solutions. I'm determined to get this resolved. You have a good one.
ABerg
Level 1

QB 2016 Open Invoices report no longer sorted in chronological order

Thank you for the reply.

Unfortunately you lost me in the first step, I cannot find "customize report" anywhere. No buttons on the report itself and cannot locate it in any of the drop down menus. When I use the HELP button and search, I get "no results found"

 

 

GenmarieM
QuickBooks Team

QB 2016 Open Invoices report no longer sorted in chronological order

Hello there, @ABerg.

 

Let me help you find the Customize Report button when running an open invoices report in QuickBooks Desktop for Mac.

 

  1. Access the Open Invoices report.
  2. Go to Customize Report and select Display.
  3. Filter out the required Dates.
  4. Select Default from the Sort by, toggle Descending order, and click OK.
  5. Tap Refresh.
  6. Go back to Customize Report and select Display.image_720.png

     

  7. Put a checkmark next to each column that you want to appear in the report.
  8. This time, toggle Ascending order, click OK, and tap Refresh.

 

Moreover, I'm adding this article as your reference in memorizing reports in QBDT for Mac: Create, access and modify memorized reports.

 

Return to this post if you have other concerns about customizing your reports in QBDT Mac. I'll be here to lend a helping hand. Have a good one!

ABerg
Level 1

QB 2016 Open Invoices report no longer sorted in chronological order

Those are the same instructions I already received. The issue is that I cannot see CUSTOMIZE REPORT anywhere in my version Quickbooks 2016 for Mac Version V17.2.32 R33.

 

I understand that it is not a supported version anymore so I am thankful for any help. I'm having a hard time understanding how this could happen to the report overnight with my computer being in sleep mode and not being touched.

 

I did perform the VERIFY DATA and it did need to be REBUILT, this did not change the report.

 

I attached a pdf of how my report looks for any clarification it may help with. I do use a memorized report that only shows the info I need. The standard Open Invoices report populates the same way though.

 

Thanks!

ShyMae
QuickBooks Team

QB 2016 Open Invoices report no longer sorted in chronological order

Hi there, ABerg. I understand you'll want to customize the reports in your QuickBooks for Mac 2016.

 

The Customize Report option is available in QuickBooks Desktop. Alternatively, you can click the column header to sort your customer name in chronological order (ascending or descending). You can do this for any column (Name, Type, Date Modified, and Size).

 

If the issue persists, I recommend contacting our technical support. They've got the experience to ensure that your concerns are conducted thoroughly. Additionally, they can refer this to our engineering department if necessary for a more in-depth resolution. 

 

Moreover, you can visit our Help pages. It contains detailed articles that provide comprehensive instructions and guidelines on managing QuickBooks Desktop for Mac more efficiently. 

 

You can always return here whenever you need assistance generating reports in QuickBooks Desktop for Mac. I'm still around to help. 

Need to get in touch?

Contact us