Odoo Help

Welcome!

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.

0

Error validating Invoices

By
Simplify-ERP®
on 6/27/16, 11:47 AM 651 views

On Version 9.0e-20160617 (Enterprise Edition)

We haven't been able to validate invoices, due to this blocking error:

Error while validating constraint.

The selected account of your Journal Entry forces to provide a secondary currency. You should remove the secondary currency on the account. None

The Account concerned is Product Sales, and it actually has only 1 currency (EUR). Where can the above stated "secondary currency" be manipulated?

Thanks for a tip or two.

Regards, NEBIZ

1

Ermin Trevisan

--Ermin Trevisan--
3536
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 6/27/16, 12:04 PM

Check the currency definition of the corresponding journal itself or the currency definition of the contra-account defined in the journal.

An accounting entry (posting) assigns an amount to an account and simultaneously to a contra-account (offset account / "Gegenkonto" in german) .

Do not explicitely define currencies to accounts and journals, as long as you do not exactly know what you are doing and why it is needed (it is only needed in rare cases).

0
Simplify-ERP®
On 6/27/16, 1:47 PM

Without knowing what a "contra-account" is, we set all Accounts in the Journal to EUR, to no avail :(

One of the strange things is that Accounting > Settings don't save, instead throw following error.

File "/home/v9devblaze/odoo/openerp/addons/account/models/res_config.py", line 169, in onchange_company_id

self.default_sale_tax_id = isinstance(taxes_id, list) and taxes_id[0] or taxes_id

IndexError: list index out of range

Consequently the Accounting > Settings > Default Company Currency loads empty.

Update 1:

We managed to resolve the empty Default company currency issue, which seems to be unrelated to the invoice-validation problem, by removing the following user-default of taxes_id (from Settings > Technical > User-defined Default, in Dev-Mode):

Separately..

Going by this video from an older OpenERP version https://youtu.be/1EZ2HwJ7j80, there used to be such a field called Secondary Currency. Does the concept of Secondary Currency for Journal Accounts still exist in odoo9, especially for single-currency setups?

If this is the "Contra-Account" as Erwin Trevisan suggested, where can Contra-Accounts be manipulated?

Thank you in advance..

___

Update 2

Following Erwin's advise, we removed the mention of EUR currency on the related Accounts (specifically 3: 101200 Accounts Receivable, 111200 Current Liabilities, 200000 Product Sales). That got rid of the original error about "Secondary currency..".

Most probably yes. You should check your tax configuration. For the rest see my amended answer.

Ermin Trevisan
on 6/28/16, 1:41 AM

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

2 follower(s)

Stats

Asked: 6/27/16, 11:47 AM
Seen: 651 times
Last updated: 6/27/16, 1:47 PM