Feature Requests
Share ideas, discuss and vote on requests from other users in community
 

Invoice Sorting in Client Area

JLHC shared this idea 4 years ago
Completed

We received a complaint today from a client about a default behavior of WHMCS which I've known for some time now.

When you navigate to the My Invoices page in the Client Area, WHMCS will sort the table by "Status" as default.

I am fine with it sorting by "Status" so that Unpaid invoices will show up first.

However, the problem is with the Paid invoices part as WHMCS sort it from the oldest to the newest. I understand the reason for this is to show older Unpaid invoices first.

I believe it would be better to sort it from the newest to the oldest at least for the Paid invoice section to prevent confusion.

I have two possible suggestions to handle this:-

1. Set the sorting for Unpaid invoices from the oldest to the newest while the sorting for Paid invoices from the newest to the oldest. I'm not sure if this is possible.

2. Allow us the ability to change the default sorting either from the oldest to the newest or from the newest to the oldest for both Paid and Unpaid invoices. This will be easier to implement.

Thank you.

Best Answer
photo

Hi,

Thanks for taking the time to provide your feedback on this. I'm pleased to advise that in v6 the new Six template supports sorting by multiple criteria, so one can Ctrl + Click the "Unpaid" and "Invoice Date" columns to sort by status and see the newest/oldest invoices.

Comments (2)

photo
1

Hi,

Thanks for taking the time to provide your feedback on this. I'm pleased to advise that in v6 the new Six template supports sorting by multiple criteria, so one can Ctrl + Click the "Unpaid" and "Invoice Date" columns to sort by status and see the newest/oldest invoices.

photo
1

in templates/template_name/clientareainvoices.tpl on line 7, I changed it to this:

table.order([4, 'desc'], [2, 'desc']);

Seems to work much better.