c2c-oerpscenario team mailing list archive

Thread
Date
[Bug 868884] [NEW] Validate payment invoice with voucher

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: echeverrifm <echeverrifm@xxxxxxxxx>
Date: Thu, 06 Oct 2011 04:40:04 -0000
Reply-to: Bug 868884 <868884@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

1)

When i try pay some supplier or customer invoice, open ( pay invoice tab
), I put de payment method, but when a push button Validate, openerp
give me this error

2)
Traceback (most recent call last):
  File "/home/openerp/source/servers/openobject-server/openerp/service/netrpc_server.py", line 62, in run
    result = netsvc.dispatch_rpc(msg[0], msg[1], msg[2:])
  File "/home/openerp/source/servers/openobject-server/openerp/netsvc.py", line 325, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/openerp/source/servers/openobject-server/openerp/service/web_services.py", line 573, in dispatch
    res = fn(db, uid, *params)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 120, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 192, in exec_workflow
    res = self.exec_workflow_cr(cr, uid, obj, method, *args)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 185, in exec_workflow_cr
    return wf_service.trg_validate(uid, obj, args[0], method, cr)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_service.py", line 124, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/instance.py", line 48, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 174, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 182, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 53, in process
    result = _execute(cr, workitem, activity, ident, stack)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 107, in _execute
    wkf_expr.execute(cr, ident, workitem, activity)
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_expr.py", line 68, in execute
    return _eval_expr(cr, ident, workitem, activity['action'])
  File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/home/openerp/source/servers/openobject-server/openerp/tools/safe_eval.py", line 286, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 346, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/home/openerp/source/addons/addons_6.1/account_voucher/account_voucher.py", line 594, in proforma_voucher
    self.action_move_line_create(cr, uid, ids, context=context)
  File "/home/openerp/source/addons/addons_6.1/account_voucher/account_voucher.py", line 860, in action_move_line_create
    move_line_pool.reconcile_partial(cr, uid, rec_ids, writeoff_acc_id=inv.exchange_acc_id.id, writeoff_period_id=inv.period_id.id, writeoff_journal_id=inv.journal_id.id)
  File "/home/openerp/source/addons/addons_6.1/account/account_move_line.py", line 750, in reconcile_partial
    res = self.reconcile(cr, uid, merges+unmerge, context=context, writeoff_acc_id=writeoff_acc_id, writeoff_period_id=writeoff_period_id, writeoff_journal_id=writeoff_journal_id)
  File "/home/openerp/source/addons/addons_6.1/account/account_move_line.py", line 884, in reconcile
    'line_partial_ids': map(lambda x: (3, x, False), ids)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 3895, in create
    vals = self._add_missing_default_values(cr, user, vals, context)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 2297, in _add_missing_default_values
    defaults = self.default_get(cr, uid, missing_defaults, context)
  File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 1432, in default_get
    defaults[f] = self._defaults[f](self, cr, uid, context)
  File "/home/openerp/source/addons/addons_6.1/account/account.py", line 1580, in <lambda>
    'name': lambda self,cr,uid,ctx={}: self.pool.get('ir.sequence').get(cr, uid, 'account.reconcile') or '/',
  File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 238, in get
    return self.get_id(cr, uid, code, 'code', context)
  File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 230, in get_id
    return self.next_by_code(cr, uid, sequence_code_or_id, context)
  File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 216, in next_by_code
    return self._next(cr, uid, ids, context)
  File "/home/openerp/source/addons/addons_6.1/account/ir_sequence.py", line 55, in _next
    return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
  File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 194, in _next
    cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
  File "/home/openerp/source/servers/openobject-server/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/home/openerp/source/servers/openobject-server/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: does not exist «ir_sequence_016»
LÍNEA 1: SELECT nextval('ir_sequence_016')

3)

Validate payment

4) 
Linux Ubuntu 11.04 - the Natty Narwhal - released in April 2011

5)
Server    Trunk version - 6.1-dev revision 3733
Client     Trunk version - 6.1-dev revision 1966
Addons  Trunk Version - 6.1-dev revision 5299

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

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

Title:
  Validate payment invoice with voucher

Status in OpenERP Addons (modules):
  New

Bug description:
  1)

  When i try pay some supplier or customer invoice, open ( pay invoice
  tab ), I put de payment method, but when a push button Validate,
  openerp give me this error

  2)
  Traceback (most recent call last):
    File "/home/openerp/source/servers/openobject-server/openerp/service/netrpc_server.py", line 62, in run
      result = netsvc.dispatch_rpc(msg[0], msg[1], msg[2:])
    File "/home/openerp/source/servers/openobject-server/openerp/netsvc.py", line 325, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/openerp/source/servers/openobject-server/openerp/service/web_services.py", line 573, in dispatch
      res = fn(db, uid, *params)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 120, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 192, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/osv.py", line 185, in exec_workflow_cr
      return wf_service.trg_validate(uid, obj, args[0], method, cr)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 174, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 182, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/workitem.py", line 107, in _execute
      wkf_expr.execute(cr, ident, workitem, activity)
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/home/openerp/source/servers/openobject-server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/home/openerp/source/servers/openobject-server/openerp/tools/safe_eval.py", line 286, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 346, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/home/openerp/source/addons/addons_6.1/account_voucher/account_voucher.py", line 594, in proforma_voucher
      self.action_move_line_create(cr, uid, ids, context=context)
    File "/home/openerp/source/addons/addons_6.1/account_voucher/account_voucher.py", line 860, in action_move_line_create
      move_line_pool.reconcile_partial(cr, uid, rec_ids, writeoff_acc_id=inv.exchange_acc_id.id, writeoff_period_id=inv.period_id.id, writeoff_journal_id=inv.journal_id.id)
    File "/home/openerp/source/addons/addons_6.1/account/account_move_line.py", line 750, in reconcile_partial
      res = self.reconcile(cr, uid, merges+unmerge, context=context, writeoff_acc_id=writeoff_acc_id, writeoff_period_id=writeoff_period_id, writeoff_journal_id=writeoff_journal_id)
    File "/home/openerp/source/addons/addons_6.1/account/account_move_line.py", line 884, in reconcile
      'line_partial_ids': map(lambda x: (3, x, False), ids)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 3895, in create
      vals = self._add_missing_default_values(cr, user, vals, context)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 2297, in _add_missing_default_values
      defaults = self.default_get(cr, uid, missing_defaults, context)
    File "/home/openerp/source/servers/openobject-server/openerp/osv/orm.py", line 1432, in default_get
      defaults[f] = self._defaults[f](self, cr, uid, context)
    File "/home/openerp/source/addons/addons_6.1/account/account.py", line 1580, in <lambda>
      'name': lambda self,cr,uid,ctx={}: self.pool.get('ir.sequence').get(cr, uid, 'account.reconcile') or '/',
    File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 238, in get
      return self.get_id(cr, uid, code, 'code', context)
    File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 230, in get_id
      return self.next_by_code(cr, uid, sequence_code_or_id, context)
    File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 216, in next_by_code
      return self._next(cr, uid, ids, context)
    File "/home/openerp/source/addons/addons_6.1/account/ir_sequence.py", line 55, in _next
      return super(ir_sequence, self)._next(cr, uid, seq_ids, context)
    File "/home/openerp/source/addons/addons_6.1/base/ir/ir_sequence.py", line 194, in _next
      cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id'])
    File "/home/openerp/source/servers/openobject-server/openerp/sql_db.py", line 153, in wrapper
      return f(self, *args, **kwargs)
    File "/home/openerp/source/servers/openobject-server/openerp/sql_db.py", line 215, in execute
      res = self._obj.execute(query, params)
  ProgrammingError: does not exist «ir_sequence_016»
  LÍNEA 1: SELECT nextval('ir_sequence_016')

  3)

  Validate payment

  4) 
  Linux Ubuntu 11.04 - the Natty Narwhal - released in April 2011

  5)
  Server    Trunk version - 6.1-dev revision 3733
  Client     Trunk version - 6.1-dev revision 1966
  Addons  Trunk Version - 6.1-dev revision 5299

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/868884/+subscriptions
Follow ups

[Bug 868884] Re: Validate payment invoice with voucher
From: Vishal Parmar(Open ERP), 2011-10-11
[Bug 868884] Re: Validate payment invoice with voucher
From: Vishal Parmar(Open ERP), 2011-10-07
[Bug 868884] [NEW] Validate payment invoice with voucher
From: echeverrifm, 2011-10-06
References

[Bug 868884] [NEW] Validate payment invoice with voucher
From: echeverrifm, 2011-10-06