Odoo Help


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


Change account code

Pascal Tremblay
on 12/1/14, 7:12 AM 846 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 - Neobis

--Ludo - Neobis--
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--


Ludo - Neobis
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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 12/1/14, 7:12 AM
Seen: 846 times
Last updated: 3/16/15, 8:10 AM