İçereği Atla
Bu soru işaretlendi
analyticreferencesorting
1 Cevapla
2691 Görünümler
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
Vazgeç
Avatar
Mahmoud Abdelwahid
En İyi Yanıt

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
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
related Many2One field Çözüldü
analytic timesheet reference related_fields
Avatar
Avatar
2
Eyl 22
2954
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
Nis 24
1247
Analytic Account Distribution Process
analytic
Avatar
0
Şub 23
3759
How to get the cost of products on analytic account? Çözüldü
analytic
Avatar
Avatar
Avatar
Avatar
Avatar
5
Kas 22
7996
How to sort Journal Entries by 'amount' column on tree_view?
sorting
Avatar
Avatar
1
Nis 16
3643