Skip to Content
This question has been flagged
analyticreferencesorting
1 Odpoveď
2930 Zobrazenia
Avatar
Hamza rana

Hey all, I've been trying to sort Analytic accounts, but they are sorting in a strange way, unlike the other things.

For EG: I want to sort: 1, 2, 3, 4, 5, 10, 20.
But on Analytic accounts, by using References, it is sorting up as: 1, 10, 2, 20, 3, 4, 5.


Screenshot attached for more guidance: 

http://imgur.com/a/lmTa0

http://tinypic.com/r/153tc0z/9


Any help would be much appreciated. Many Thanks.

Avatar
Zrušiť
Avatar
Mahmoud Abdelwahid
Best Answer

This because References field is char field, and ordering is different from integer field, must put all code with same digits number.

Example convert: 1, 2, 3, 4, 5, 10, 20

To:  01, 02, 03, 04, 05, 10, 20


Avatar
Zrušiť
Related Posts Replies Zobrazenia Aktivita
related Many2One field Solved
analytic timesheet reference related_fields
Avatar
Avatar
2
sep 22
3176
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
apr 24
1447
Analytic Account Distribution Process
analytic
Avatar
0
feb 23
3984
How to get the cost of products on analytic account? Solved
analytic
Avatar
Avatar
Avatar
Avatar
Avatar
5
nov 22
8229
How to sort Journal Entries by 'amount' column on tree_view?
sorting
Avatar
Avatar
1
apr 16
3822