Skip ke Konten
Pertanyaan ini telah diberikan tanda
analyticreferencesorting
1 Balas
2964 Tampilan
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
Buang
Avatar
Mahmoud Abdelwahid
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
related Many2One field Diselesaikan
analytic timesheet reference related_fields
Avatar
Avatar
2
Sep 22
3200
Replacing the analytic fields with Sales Order number
analytic
Avatar
0
Apr 24
1474
Analytic Account Distribution Process
analytic
Avatar
0
Feb 23
4012
How to get the cost of products on analytic account? Diselesaikan
analytic
Avatar
Avatar
Avatar
Avatar
Avatar
5
Nov 22
8252
How to sort Journal Entries by 'amount' column on tree_view?
sorting
Avatar
Avatar
1
Apr 16
3857