How to sort account by code in chart of account?

Question

Hello there,
In the chart of accounts and in the accounts list, we want to sort accounts by CODE.
For example, In the parent account 3, we would want to sort accounts like 3.1, 3.2, 3.3, etc.
Actually, the account_account class is defined like this in Odoo 8 :
class account_account(osv.osv):
_order = "parent_left"
_parent_order = "code"
_name = "account.account"
_description = "Account"
_parent_store = True
How to override this class account_account to sort by CODE in each parent?
Thanks to help

Pascal Tremblay · Answer

I have tried many combinationsfor _order and _parent_order of account_account class. Always get the same error.
For example, If I tried to change _order directly in the original account.py file like this :
class account_account(osv.osv):
_order = "code asc" ###instead of _order = "parent_left"
_parent_order = "code"
_name = "account.account"
_description = "Account"
_parent_store = True For all combinations I have tried, I got this error :
File "/home/odoo-iv/odoo-8.0-20170119/openerp/addons/acc

ayman mohammed adam · Answer

dear Pascal

Try to make order like this
_order = 'field1 asc, field2 asc'  Field1: the first to field  Field2: the second to field
I hope I helped you...

Powiązane posty	Odpowiedzi	Widoki
Accounts types does not appear accounts account	0 mar 15	3294
Problems importing accounts import accounts account	0 gru 16	3175
User-Defined Filters does not remember Sort Order Rozwiązane filter sort sorting 10	2 lut 19	6379
Automatic creation of account when create a partner partner code creation account	2 cze 17	6578
How to add 2 fields in column account_invoice_line ??? invoice accounts account odoo8	3 gru 15	5154

To pytanie dostało ostrzeżenie

In image (what we actually have) :

So, I have decided to change 'parent_left' and 'parent_right' field values for accounts in account.account database's table. I did it manually directly in the database.

_order = 'field1 asc, field2 asc'

Field1: the first to field

Field2: the second to field

Podoba Ci się ta dyskusja? Dołącz do niej!