Reference Number Sorting (Again)

[Sanif_Sentosa]

Hi, i’m using Server version 23.3.19.729, and still I have problem in the Reference Number sorting in various module: Sales Invoice, Purchase Invoice, etc.

[lubos]

Should be fixed in the latest version (23.3.30)

[ibadlon]

hi, i think something is wrong here.

The sorting is messed up.

[ibadlon]

I posted similar to this but it was fine. But what happened now is too messed up.

Default Sorting by User

Hi @Tut, thank you for the reply. But maybe the developer can check on this one. We have now edit columns, now just asking if possible to add feature on putting the default sorting inside this window. Also, I found something for @lubos . I understand that some field are alphanumeric, but can this be solved? [image] I was sorting the reference in descending order but it showed like this. FZR-149 should have been the last invoice in this reference format (FZR-###.d-mm-yy) - as I have different …

[Joe91]

How is it messed up - it is sorted in descending order alphabetically

[Tut]

@ibadlon, your references are not numerical.

[ibadlon]

the sorting is indeed descending order. however, as you see from 149 it jumped to 136 and 135 jumped to 119. there are invoices in between which are sorted somewhere else.

[ibadlon]

understood, but does is not suppose to be sorted alphanumerical?

[lubos]

@ibadlon in this case you will need to adopt DD-MM-YY date format. Not just D-MM-YY. Then your sorting will work properly.

[eko]

@ibadlon

is not suppose to be sorted alphanumerical?

References are not numerical as some people prefer to include text in the reference box.

[ibadlon]

thank you. solved.