c2c-oerpscenario team mailing list archive

[Ilja Schumacher <700953@xxxxxxxxxxxxxxxxxx>]

1) Created Analytic Account "A - Summary" with no parent account
2) Created Analytic Account "B" with parent account "A-Summary"
3) Created Analytic Account "C" with parent account "A-Summary"
4) Created Analytic Plan "D" via "Multi Plans" consisting out of "B" and "C"
5) Created Analytic Journal "Analytic Purchase Journal" of the type Purchase
6) Assigned the "Analytic Purchase Journal" as Analytic Journal to the "Purchase Journal" in "Configuration > Financial Accounting > Journals > Journals"
7) Set the Value for "Reinvoiced Costs" to 100% in Analytic Accounts "B" and "C"
8) Created a new "Supplier Invoice to Receive" with "Journal: Purchase Journal"
9) Created a new "Invoice Line" with "Product: empty", "Quantity: 1", "Unit of Measure: PCS", "Unit Price: 812,12" "Description: Example Flight Booking", "Account: Some Account", "Company: MyTestCompany"
"Analytic Distribution" => Created new Distribution with "Model's Plan: A-Summary"
10) Added a Tax to the Invoice Line
11) Saved everything
12) Computed Tax
13) Entered "Total"
14) Saved Again
15) Clicked on "Approve"
16) Received the above error

No code customizing has been done.

-- 
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/700953

Title:
  Column account_journal_period.company_id missing

Status in OpenObject Addons Modules:
  Incomplete

Bug description:
  1)
Freshly installed the openobject-server 6.0 rc2 revision 3204, openobject-client-web 6.0 rc2 revision 4236, openobject-addons revision 4175
2) Created a new database
3) Tried to validate a expected incoming invoice
4) Recieved error stating that account_journal_period.company_id is missing in the database

Traceback (most recent call last):
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/netsvc.py", line 489, in dispatch
    result = ExportService.getService(service_name).dispatch(method, auth, params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/service/web_services.py", line 598, in dispatch
    res = fn(db, uid, *params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/audittrail/audittrail.py", line 538, in exec_workflow
    return super(audittrail_objects_proxy, self).exec_workflow(db, uid, model, method, *args, **argv)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 122, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 196, in exec_workflow
    res = self.exec_workflow_cr(cr, uid, obj, method, *args)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/osv.py", line 189, in exec_workflow_cr
    return wf_service.trg_validate(uid, obj, args[0], method, cr)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/wkf_service.py", line 80, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/instance.py", line 48, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 174, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 182, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 53, in process
    result = _execute(cr, workitem, activity, ident, stack)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/workitem.py", line 107, in _execute
    wkf_expr.execute(cr, ident, workitem, activity)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/wkf_expr.py", line 68, in execute
    return _eval_expr(cr, ident, workitem, activity['action'])
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/workflow/wkf_expr.py", line 58, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/tools/safe_eval.py", line 281, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 181, in <lambda>
    return lambda *args, **argv: attr(self._cr, self._uid, [self._id], *args, **argv)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/invoice.py", line 937, in action_move_create
    move_id = self.pool.get('account.move').create(cr, uid, move, context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 1265, in create
    result = super(account_move, self).create(cr, uid, vals, c)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3637, in create
    result += self._columns[field].set(cr, self, id_new, field, vals[field], user, rel_context) or []
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/fields.py", line 492, in set
    id_new = obj.create(cr, user, act[2], context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 1150, in create
    self._update_journal_check(cr, uid, context['journal_id'], context['period_id'], context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account_move_line.py", line 1109, in _update_journal_check
    'period_id': period.id
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/addons/account/account.py", line 988, in create
    return super(account_journal_period, self).create(cr, uid, vals, context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3602, in create
    self.check_access_rule(cr, user, [id_new], 'create', context=context)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/osv/orm.py", line 3163, in check_access_rule
    [sub_ids] + where_params)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python2.6/dist-packages/openerp-server/sql_db.py", line 129, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column account_journal_period.company_id does not exist
LINE 1: ...l_period.journal_id in (6,7,8,5,3,2,4,1))))  OR  (account_jo...
                                                             ^

Don't really know if this belongs to the server or to the accounting-module.

Thanks for your advise in advance.