Skip to Content
This question has been flagged
2 Respostes
103 Vistes
Avatar
Sergio Díaz Arriaza

We are getting a validation error when trying to open or modify the Chart of Accounts.

Error message:

“You cannot have more than one account with 'Current Year Earnings' as type. (accounts: False, False, False, False, and False)”

Each company in our database has only one account of type equity_unaffected (“Undistributed Profits/Losses”).

We manually reviewed all companies and their Chart of Accounts, and there are no duplicate accounts of this type.

It seems that some internal properties (property_account_current_year_earnings_id) might still be referencing deleted or shared accounts, even though all accounts are now correctly separated by company.

We are using Odoo Online (SaaS 18), so we cannot access or edit ir.property through XML-RPC or Studio.

We already tried:

  • Changing and saving the “Current Year Earnings” account in each company’s accounting settings.
  • Deactivating and reactivating the accounts.
  • Verifying that all companies have their own equity_unaffected account.

The error still appears every time we try to open or edit any account, and it also prevents us from creating a new company (because Odoo tries to validate the “Current Year Earnings” property).

Could this be caused by an internal reference that still points to a deleted or shared account ID (like account.account,6909)?

If so, is there any way to reset or reassign those internal property_account_current_year_earnings_id entries without technical intervention on SaaS?

Avatar
Descartar
Avatar
Sergio Díaz Arriaza
Autor Best Answer

Thanks a lot for clarifying this!

It’s now clear that the issue can only be fixed by the Odoo support team, so I’ll contact them to get it resolved.

Avatar
Descartar
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,


This issue is caused by an internal inconsistency in Odoo’s accounting configuration, specifically, the property_account_current_year_earnings_id field, which defines the “Current Year Earnings” account for each company. Even though your Chart of Accounts appears correct and each company has only one “Undistributed Profits/Losses” (equity_unaffected) account, Odoo likely still has outdated or invalid property records in the ir.property table referencing deleted or shared account IDs.


Because Odoo Online (SaaS) restricts access to the database and the ir.property model, you can’t manually inspect or reset these references through Studio or XML-RPC. The steps you’ve already taken, changing the Current Year Earnings account in Accounting Settings, deactivating/reactivating accounts, and verifying account uniqueness per company, were correct, but they do not clean up orphaned ir.property records that may still point to non-existent account IDs.


The most likely cause is that an earlier account (perhaps with ID like account.account,6909) was deleted or shared across companies before multi-company separation was enforced. Odoo’s validation then detects multiple or inconsistent references, even if visually you see only one.


Since this is a SaaS (Online) instance, you cannot fix it yourself through direct SQL or developer tools. The correct solution is to submit a support ticket to Odoo via your customer portal. In your request, explain that there’s a corrupted or duplicate ir.property entry for property_account_current_year_earnings_id across companies and that you need it reset or reassigned. The Odoo technical support team can safely clean these records at the database level.


In summary, the issue stems from stale internal property references that must be corrected by Odoo’s support staff, as users on SaaS cannot access or modify these backend configurations.



Hope it helps

Avatar
Descartar