← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 684095] Re: installing l10n_ch: insert into "account_journal" violates unique constraint "account_journal_code_company_uniq"

 

This bug will be corrected on next release of l10n_ch. In next release
the vaud tax data file will not be present anymore. The l10n_ch version
on launchpad is deprecated. It does not take in account 20011 new taxes.
We will release next version ASAP.

Regards

Nicolas

** Changed in: openobject-addons
       Status: New => Invalid

** Changed in: openobject-addons
     Assignee: (unassigned) => Nicolas Bessi - Camptocamp (nbessi-c2c)

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/684095

Title:
  installing l10n_ch: insert into "account_journal" violates unique constraint "account_journal_code_company_uniq"

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  Steps:
 - install account
 - select Swiss chart of accounts

openobject-addons revno: 3948

When trying to generate l10n_ch chart of accounts, wizard produces the following error:

ERROR:db.cursor:bad query: insert into "account_journal" (id,"default_debit_account_id","update_posted","code","user_id","name","analytic_journal_id","view_id","group_invoice_lines","company_id","centralisation","sequence_id","refund_journal","allow_date","entry_posted","type","default_credit_account_id",create_uid,create_date) values (7,721,E'False',E'EXJ',1,E'Purchase Journal',NULL,4,E'False',1,E'False',9,E'False',E'False',E'False',E'purchase',721,1,now())
Traceback (most recent call last):
  File "/home/elbati/workspace/openerp/server/openobject-server/bin/sql_db.py", line 122, in execute
    res = self._obj.execute(query, params)
IntegrityError: duplicate key value violates unique constraint "account_journal_code_company_uniq"

due to the file vaudtax_data.xml
that creates journals (sale, purchase and refund) that should be created by wizard instead





References