Validate payment invoice with voucher

[Federico Manuel Echeverri Choux]

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

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello echeverrifm,

I have checked your issue with latest update code with trunk but I didn't face any problem when I did validate

invoice. So would you please give your end scenario with related video so we can reproduce same at our end and

try again with updated code.

Thanks and waiting for your reply.

[Federico Manuel Echeverri Choux (echeverrifm)]

Hi, Vishal. I tried again, but all everthing ok.

I will test with other DB in my server, because in my laptop today work
fine.

I will write later my comments.

Thanks

2011/10/7 Vishal Parmar(Open ERP) <email address hidden>

> Hello echeverrifm,
>
> I have checked your issue with latest update code with trunk but I
> didn't face any problem when I did validate
>
> invoice. So would you please give your end scenario with related video
> so we can reproduce same at our end and
>
> try again with updated code.
>
> Thanks and waiting for your reply.
>
> ** Changed in: openobject-addons
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/868884
>
> Title:
> Validate payment invoice with voucher
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/868884/+subscriptions
>

[Vishal Parmar(Open ERP) (vpa-openerp)]

Hello,

According to comment #2 I am closing this issue if you have still faced problem then you can reopen this issue.

Thanks.

[Federico Manuel Echeverri Choux (echeverrifm)]

Hello. Ok

Thanks

Enviado desde Samsung tablet
Federico Manuel Echeverri Choux
Tel: [phone]
On Oct 11, 2011 7:52 AM, "Vishal Parmar(Open ERP)" <
<email address hidden>> wrote:

> Hello,
>
> According to comment #2 I am closing this issue if you have still faced
> problem then you can reopen this issue.
>
> Thanks.
>
> ** Changed in: openobject-addons
> Status: Incomplete => Invalid
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/868884
>
> Title:
> Validate payment invoice with voucher
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/openobject-addons/+bug/868884/+subscriptions
>