c2c-oerpscenario team mailing list archive

["Alberto Luengo Cabanillas \(Pexego\)" <alberto@xxxxxxxxx>]

Public bug reported:

Hi all, using following revisions:

server: 3247
gtk client: 1770
addons: 4033


and having done an "--update=all", every time I try to approve a supplier/customer invoice, I get following error:
(...)
File "/opt/openerp/6.0/trunk/server/bin/addons/account/account_move_line.py", line 1224, in create
    self._update_journal_check(cr, uid, context['journal_id'], context['period_id'], context)
  File "/opt/openerp/6.0/trunk/server/bin/addons/account/account_move_line.py", line 1183, in _update_journal_check
    'period_id': period.id
  File "/opt/openerp/6.0/trunk/server/bin/addons/account/account.py", line 988, in create
    return super(account_journal_period, self).create(cr, uid, vals, context)
  File "/opt/openerp/6.0/trunk/server/bin/osv/orm.py", line 3602, in create
    self.check_access_rule(cr, user, [id_new], 'create', context=context)
  File "/opt/openerp/6.0/trunk/server/bin/osv/orm.py", line 3163, in check_access_rule
    [sub_ids] + where_params)
  File "/opt/openerp/6.0/trunk/server/bin/sql_db.py", line 76, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/openerp/6.0/trunk/server/bin/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: ...iod.journal_id in (55,14,15,16,13,12,48))))  OR  (account_jo...

It seems that 'domain_get' method in 'osv/orm.py' (line 3157) adds automatically some 'company_id' related clauses in followup SQL queries that make invoices workflow fail. 
Just in case, 'multi_company_account' module adds a 'company_id' field to 'account_journal_period' but it still uses 'ir.rule.group' model'... 
This should be checked.
Best regards,

** Affects: openobject-addons
     Importance: Undecided
         Status: Invalid

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

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

Title:
  [6.0RC2][account] Can not validate a supplier invoice

Status in OpenObject Addons Modules:
  Invalid

Bug description:
  Hi all, using following revisions:

  server: 3247
  gtk client: 1770
  addons: 4033

  
  and having done an "--update=all", every time I try to approve a supplier/customer invoice, I get following error:
  (...)
  File "/opt/openerp/6.0/trunk/server/bin/addons/account/account_move_line.py", line 1224, in create
      self._update_journal_check(cr, uid, context['journal_id'], context['period_id'], context)
    File "/opt/openerp/6.0/trunk/server/bin/addons/account/account_move_line.py", line 1183, in _update_journal_check
      'period_id': period.id
    File "/opt/openerp/6.0/trunk/server/bin/addons/account/account.py", line 988, in create
      return super(account_journal_period, self).create(cr, uid, vals, context)
    File "/opt/openerp/6.0/trunk/server/bin/osv/orm.py", line 3602, in create
      self.check_access_rule(cr, user, [id_new], 'create', context=context)
    File "/opt/openerp/6.0/trunk/server/bin/osv/orm.py", line 3163, in check_access_rule
      [sub_ids] + where_params)
    File "/opt/openerp/6.0/trunk/server/bin/sql_db.py", line 76, in wrapper
      return f(self, *args, **kwargs)
    File "/opt/openerp/6.0/trunk/server/bin/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: ...iod.journal_id in (55,14,15,16,13,12,48))))  OR  (account_jo...

  It seems that 'domain_get' method in 'osv/orm.py' (line 3157) adds automatically some 'company_id' related clauses in followup SQL queries that make invoices workflow fail. 
  Just in case, 'multi_company_account' module adds a 'company_id' field to 'account_journal_period' but it still uses 'ir.rule.group' model'... 
  This should be checked.
  Best regards,