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 995 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

¡Hola! Este foro tiene la finalidad de compartir con la comunidad de Odoo Argentina preguntas y respuestas funcionales y técnicas. Lea las directrices

Herramientas de las preguntas

51 seguidor(es)

Estadísticas

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