Sorting invoices based on numbers
When there are invoices more than 1000 and tried to sort invoices by invoice number, it's not sorted properly.
There are some invoices whose numbers are INV-1000, INV-1001, INV-1002 etc.
However, when they are sorted by descending order, INV-999 is listed on the top. It's sorted as INV-999,INV-998,INV-997,....,INV-1000
Hope these are sorted based on numbers.
Anonymous
shared this idea
-
Dmitry
commented
The sorting simply sucks! Such a simple function is missing and make me crazy already. You cannot just sort by invoice number e.g. 1 ... 10 11 ... 20 results in 1 10 etc I wonder what kind of "geniuses" are programming the system...
-
Anonymous
commented
This is really broken and needs fixing!
-
Lis Soderberg
commented
Whether or not you keep the INV- prefix, to properly sort your invoices you will have to change invoice numbers so that they have the same number of digits using zeros as placeholders (i.e. INV-0999 instead of INV-999).
Spaces in the field will also affect your search, e.g. a space before or after the dash.
I just did a test using numbers only, but unfortunately it looks like the invoice field in Zoho sorts by the first digit (I used 33, 999 and 1000 for my test), a text search rather than a number search.
Changing the numbers to 0033, 0999 and 1000 sorted them properly.
So ... even if you decide to use numbers only in your invoices, to be properly sorted the numbers need to have the same amount of digits—using zeros as placeholders—until Zoho addresses this.