installation of new german accounting chart fails

Asked by Thorsten Vocks ( on 2009-04-08

I would like to provide a new module l10n_chart_de_ikr.
Installation of chart template is ok, but if i process action "generate chart of accounts from a template"
i got the following error. I attached the module.

Traceback (most recent call last):
  File "/home/vockst/openerp/client/bin/widget/view/form_gtk/", line 117, in button_clicked
    [id], model.context_get()
  File "/home/vockst/openerp/client/bin/", line 169, in rpc_exec_auth
    return sock.exec_auth(method, *args)
  File "/home/vockst/openerp/client/bin/", line 112, in exec_auth
    res = self.execute(method, self._uid, self._passwd, *args)
  File "/home/vockst/openerp/client/bin/", line 118, in execute
    res = self._sock.myreceive()
  File "/home/vockst/openerp/client/bin/", line 80, in myreceive
    raise Myexception(str(res[0]), str(res[1]))
tiny_socket.Myexception: ('77', 'Traceback (most recent call last):\n File "/home/vockst/openerp/server/bin/", line 231, in dispatch\n result = LocalService(service_name)(method, *params)\n File "/home/vockst/openerp/server/bin/", line 74, in __call__\n return getattr(self, method)(*params)\n File "/home/vockst/openerp/server/bin/service/", line 481, in execute\n res = service.execute(db, uid, object, method, *args)\n File "/home/vockst/openerp/server/bin/osv/", line 59, in wrapper\n return f(self, dbname, *args, **kwargs)\n File "/home/vockst/openerp/server/bin/osv/", line 119, in execute\n res = pool.execute_cr(cr, uid, obj, method, *args, **kw)\n File "/home/vockst/openerp/server/bin/osv/", line 111, in execute_cr\n return getattr(object, method)(cr, uid, *args, **kw)\n File "/home/vockst/openerp/server/bin/addons/account/", line 2137, in action_create\n \'account_collected_id\': acc_template_ref[value[\'account_collected_id\']],\nKeyError: 77\n')

Question information

English Edit question
Odoo Addons (MOVED TO GITHUB) Edit question
No assignee Edit question
Solved by:
Thorsten Vocks (
Last query:
Last reply:

I am trying to figure out.

Hello Thorsten Vocks,

Your module is a good one.
At initial steps, I got the same error , I traced it back...

The recipe needs few changes for getting it ready for errorless installation.

1. Account code has to be unique .
 -- > Assign unique code to template which in turn are to be applied to account.account.

2. There should be only 1 root of the account.


Adding more particular detail,

There should be only one account template whose parent_id =False.

In your case, you have assigned 'Bilanz und GuV' to be the root account template for chart of template.

but, it has 31 other siblings which have parent_id =False.

If you feel they should be at the sme level as 'Bilanz und GuV', Assign one root account template 'Company chart' that is the parent of 'Bilanz und GuV' as well as the 31 orphans(they had no parents).

So, resultantly, There will be only one root and you assign it to chart of template 'Deutscher Kontenplan IKR' 's root account.

Rest is all yours.

Enjoy open ERP.

Thanks for your advices.
Indeed this advise solved my problem.
I will prepare a launchpad repository for the module
and documentation.