Skip to Content
Dette spørgsmål er blevet anmeldt
analyticreferencesorting
1 Svar
2721 Visninger
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
Kassér
Avatar
Mahmoud Abdelwahid
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
related Many2One field Løst
analytic timesheet reference related_fields
Avatar
Avatar
2
sep. 22
2962
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
apr. 24
1252
Analytic Account Distribution Process
analytic
Avatar
0
feb. 23
3769
How to get the cost of products on analytic account? Løst
analytic
Avatar
Avatar
Avatar
Avatar
Avatar
5
nov. 22
8004
How to sort Journal Entries by 'amount' column on tree_view?
sorting
Avatar
Avatar
1
apr. 16
3650