Odoo Help


Change account code

Pascal Tremblay
on 12/1/14, 7:12 AM 1,670 views

Hello all,

What is the best way to change account code if there is already many journal entries in this account?

I want to change the account code 111001 to But I can't change it in Odoo beacause the account 111001 has many entries.

<img src="http://lapagept.com/images/odoo/account.png" />


I'm very sad. Impossible to put image on forum.

Pascal Tremblay
on 12/1/14, 7:15 AM

Ludo - 21South

--Ludo - 21South--
| 2 2 5
Zwijndrecht, Netherlands
--Ludo - 21South--


Ludo - 21South
On 12/1/14, 8:15 AM

The account code can be changed nonetheless, am I right? The underlying id of the record  is what creates the link from the analytic journal entries.

Only printed reports could be a problem, in comparisons.

Or are you talking about an entirely new account in your chart? In that case (in the Netherlands at least) you are stuck to creating moves to "correct" these lines in bookkeeping terms. Usually this is done manually using the "misc. journal". 

Do you mean that I could go in PGadmin, in the table account_account, and I could change value directly in the field « code character varying(64) » without problem?

Pascal Tremblay
on 12/1/14, 8:39 AM

I think you can do it from Odoo application itself without having to resort to PgAdmin. The accounts are identified by it's Database ID not the Code.

on 12/1/14, 8:16 PM

try to modify the code of an account within odoo admin. i can't change it within odoo if the account has at least one entry.

Pascal Tremblay
on 12/1/14, 9:19 PM

Sorry Pascal, you are right. Here are the comment on that part of the code. "For legal reason (forbiden to modify journal entries which belongs to a closed fy or period), Forbid to modify the code of an account if journal entries have been already posted on this account. This cannot be simply 'configurable' since it can lead to a lack of confidence in OpenERP and this is what we want to change."

on 12/1/14, 10:13 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

4 follower(s)


Asked: 12/1/14, 7:12 AM
Seen: 1670 times
Last updated: 3/18/18, 2:43 AM