Welcome!

This community is for professionals and enthusiasts of our products and services. Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

0

Error al validar Factura (Nro. ya existente) ValueError: "duplicate key value violates ...

por
Diego Requejo
en 16/11/16 20:06 691 vistas

Buenas tardes! los molesto para consultarles porque de golpe empezó a tirar este error de que tengo duplicada la factura cuando si busco en la lista de facturas realizadas no existe. Según AFIP el próximo número es el 44 y no me deja! pero inclusive probé con el Nro 45 y tampoco! Tengo Odoo con Docker según la instalación avanzada y hace poco para poder facturar tuve que modificar el módulo pyafipws... Gracias desde ya por su tiempo y su ayuda!

Traceback (most recent call last): File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 537, in _handle_exception return super(JsonRequest, self)._handle_exception(exception) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 574, in dispatch result = self._call_function(**self.params) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 310, in _call_function return checked_call(self.db, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 307, in checked_call return self.endpoint(*a, **kw) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 803, in __call__ return self.method(*args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 403, in response_wrap response = f(*args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 955, in exec_workflow return request.session.exec_workflow(model, id, signal) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1111, in exec_workflow r = self.proxy('object').exec_workflow(self.db, self.uid, self.password, model, signal, id) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 879, in proxy_method result = dispatch_rpc(self.service_name, method, args) File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 115, in dispatch_rpc result = dispatch(method, params) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 37, in dispatch res = fn(db, uid, *params) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 118, in wrapper return f(dbname, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 188, in exec_workflow return exec_workflow_cr(cr, uid, obj, signal, *args) File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 182, in exec_workflow_cr return execute_cr(cr, uid, obj, 'signal_workflow', [res_id], signal)[res_id] File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 164, in execute_cr return getattr(object, method)(cr, uid, *args, **kw) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 268, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3572, in signal_workflow result[res_id] = workflow.trg_validate(uid, self._name, res_id, signal, cr) File "/usr/lib/python2.7/dist-packages/openerp/workflow/__init__.py", line 85, in trg_validate return WorkflowService.new(cr, uid, res_type, res_id).validate(signal) File "/usr/lib/python2.7/dist-packages/openerp/workflow/service.py", line 91, in validate res2 = wi.validate(signal) File "/usr/lib/python2.7/dist-packages/openerp/workflow/instance.py", line 80, in validate wi.process(signal=signal, force_running=force_running, stack=stack) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 120, in process ok = self._split_test(activity['split_mode'], signal, stack) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 248, in _split_test self._join_test(t[0], t[1], stack) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 257, in _join_test WorkflowItem.create(self.session, self.record, activity, inst_id, stack=stack) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 95, in create workflow_item.process(stack=stack) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 116, in process if not self._execute(activity, stack): File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 162, in _execute returned_action = self.wkf_expr_execute(activity) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 313, in wkf_expr_execute return self.wkf_expr_eval_expr(activity['action']) File "/usr/lib/python2.7/dist-packages/openerp/workflow/workitem.py", line 291, in wkf_expr_eval_expr result = eval(line, env, nocopy=True) File "/usr/lib/python2.7/dist-packages/openerp/tools/safe_eval.py", line 314, in safe_eval return eval(c, globals_dict, locals_dict) File "", line 1, in <module> File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/mnt/extra-addons/odoo-argentina/l10n_ar_invoice/models/invoice.py", line 579, in action_move_create return super(account_invoice, self).action_move_create() File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account_invoice.py", line 930, in action_move_create move.post() File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 592, in new_api result = method(self._model, cr, uid, self.ids, *args, **old_kwargs) File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account.py", line 1336, in post self.write(cr, uid, [move.id], {'name':new_name}) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 268, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/addons/account/account.py", line 1377, in write result = super(account_move, self).write(cr, uid, ids, vals, c) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 268, in wrapper return old_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 399, in old_api result = method(recs, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3789, in write self._write(old_vals) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 592, in new_api result = method(self._model, cr, uid, self.ids, *args, **old_kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 4041, in _write recs.recompute() File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5760, in recompute rec._write(values) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 266, in wrapper return new_api(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 592, in new_api result = method(self._model, cr, uid, self.ids, *args, **old_kwargs) File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3900, in _write cr.execute(query, params + (sub_ids,)) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper return f(self, *args, **kwargs) File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute res = self._obj.execute(query, params) ValueError: "duplicate key value violates unique constraint "account_invoice_number_uniq" DETAIL: Key (number, company_id, journal_id, type)=(0002-00000045, 1, 12, out_invoice) already exists. " while evaluating u'action_move_create()'


1
Daniel Blanco
En 28/11/16 19:27

Lo que estás teniendo, es que por algún motivo se generó en odoo ese comprobante y no proviene de los webservices. Hiciste alguna configuración de los diarios y después la cambiaste? Fijate que el id del diario que te da problemas el el id=12. Fijate si tenés otro diario de ventas que pueda estar solapando facturas.


Mantener informado

Acerca de esta comunidad

Esta comunidad es para profesionales y entusiastas de nuestros productos y servicios, compartir los mejores contenidos y nuevas ideas de marketing, construir su perfil profesional y mejorar el mercado para todos. Lea las directrices

Herramientas de las preguntas

51 seguidor(es)

Estadísticas

Preguntado: 16/11/16 20:06
Visto: 691 veces
Última actualización: 14/4/18 12:41