Skip to Content
This question has been flagged
analyticreferencesorting
1 Reply
2024 Views
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
Discard
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
Discard
Related Posts Replies Views Activity
related Many2One field Solved
analytic timesheet reference related_fields
Avatar
Avatar
2
Sep 22
1600
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
Apr 24
231
Analytic Account Distribution Process
analytic
Avatar
0
Feb 23
2629
How to get the cost of products on analytic account? Solved
analytic
Avatar
Avatar
Avatar
Avatar
Avatar
5
Nov 22
6906
How to sort Journal Entries by 'amount' column on tree_view?
sorting
Avatar
Avatar
1
Apr 16
2776