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...

المنشورات ذات الصلة	الردود	أدوات العرض
Accounts types does not appear accounts account	0 مارس 15	3306
Problems importing accounts import accounts account	0 ديسمبر 16	3183
User-Defined Filters does not remember Sort Order تم الحل filter sort sorting 10	2 فبراير 19	6389
Automatic creation of account when create a partner partner code creation account	2 يونيو 17	6597
How to add 2 fields in column account_invoice_line ??? invoice accounts account odoo8	3 ديسمبر 15	5177

لقد تم الإبلاغ عن هذا السؤال

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

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!