Chart of Analytic Accounts Weird Sorting

Question

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.

Mahmoud Abdelwahid · 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

相關帖文	回覆	瀏覽次數
related Many2One field 已解決 analytic timesheet reference related_fields	2 9月 22	2962
Replacing the analytic fields with Sales Order number analytic	0 4月 24	1252
Analytic Account Distribution Process analytic	0 2月 23	3769
How to get the cost of products on analytic account? 已解決 analytic	5 11月 22	8004
How to sort Journal Entries by 'amount' column on tree_view? sorting	1 4月 16	3648

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！