Skip to Content
Menu
This question has been flagged
1 Reply
5975 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 3.1.0.6. But I can't change it in Odoo beacause the account 111001 has many entries.

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

Thanks

Avatar
Discard
Author

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

Best Answer

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

Avatar
Discard
Author

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?

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.

Author

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.

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