Inicie sesión para poder revisar sus tickets
TICK-006039 - ERROR AL GENERAR FACTURA
Ticket Resuelto
Cliente:
Laboratorio Kasem Spa, Sandra Anguita
Equipo:
Nivel 1
Ejecutiv@:
Martín Baeza (OrionERP)
Fecha de creación:
22/10/2024 17:37:53
Email:
Teléfono:
Fecha de cierre:
24/10/2024 03:13:28
Categoría:
Reportar un error
Descripción:
Buenas tardes Sandra,
Agradeceré tu apoyo gestionando un ticket con Orion debido a que tuve un problema al momento de generar la FE asociada al PR2213. Me arroja el siguiente error:
Error:
Orion Server Error
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/tools/safe_eval.py", line 350, in safe_eval
return unsafe_eval(c, globals_dict, locals_dict)
File "", line 18, in <module>
File "/usr/lib/python3/dist-packages/odoo/addons/purchase/models/account_invoice.py", line 258, in write
result = result and super(AccountInvoice, invoice).write(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 283, in write
result = super(MailThread, self).write(values)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_activity.py", line 369, in write
return super(MailActivityMixin, self).write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3149, in write
self._write(old_vals)
File "/usr/lib/python3/dist-packages/odoo/addons/base_automation/models/base_automation.py", line 234, in _write
_write.origin(records, vals, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_invoice.py", line 502, in _write
res = super(AccountInvoice, self)._write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3252, in _write
cr.execute(query, params + (sub_ids,))
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "journal_id" violates not-null constraint
DETAIL: Failing row contains (4085, , PR2213, out_invoice, eb0c6814-4df1-4bdb-b338-6a7d374375cd, null, null, null, null, none, , draft, f, null, null, 5466, null, null, 4, null, 0, 0, 0, 0, 0, 0, 46, null, 1, t, null, 0, 0, 0, 81, null, 5466, null, null, null, 46, 2024-10-22 17:25:53.232706, 1, 2024-10-22 17:25:53.232706, 1, 5472, null, null, t, 15, 4, 33, null, null, f, null, 1, null, null, null, null, null, null, null, f, recibido, null, f, null, null, 0, 0, null, null, null, null, f, null, 1, null, null, null, null, null, null, t, null, null, 2, 1, null, null, null, null, null, null, null, null, f, 1).
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 653, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 312, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise
raise value
File "/usr/lib/python3/dist-packages/odoo/http.py", line 695, in dispatch
result = self._call_function(**self.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 344, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 337, in checked_call
result = self.endpoint(*a, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 939, in __call__
return self.method(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 517, in response_wrap
response = f(*args, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 938, in call_button
action = self._call_kw(model, method, args, {})
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 926, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 699, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 690, in call_kw_multi
result = method(recs, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/sale/wizard/sale_make_invoice_advance.py", line 132, in create_invoices
sale_orders.action_invoice_create()
File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/sale.py", line 429, in action_invoice_create
invoice = inv_obj.create(inv_data)
File "/usr/lib/python3/dist-packages/odoo/addons/base_automation/models/base_automation.py", line 207, in create
record = create.origin(self.with_env(actions.env), vals, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/purchase/models/account_invoice.py", line 246, in create
invoice = super(AccountInvoice, self).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_invoice.py", line 491, in create
invoice = super(AccountInvoice, self.with_context(mail_create_nolog=True)).create(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 237, in create
thread = super(MailThread, self).create(values)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3437, in create
record = self.browse(self._create(old_vals))
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3594, in _create
self.recompute()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 4990, in recompute
target._write(dict(vals))
File "/usr/lib/python3/dist-packages/odoo/addons/base_automation/models/base_automation.py", line 237, in _write
action._process(action._filter_post(pre[action]))
File "/usr/lib/python3/dist-packages/odoo/addons/base_automation/models/base_automation.py", line 184, in _process
self.action_server_id.with_context(**ctx).run()
File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_actions.py", line 557, in run
res = func(action, eval_context=eval_context)
File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_actions.py", line 433, in run_action_code_multi
safe_eval(action.sudo().code.strip(), eval_context, mode="exec", nocopy=True) # nocopy allows to return 'action'
File "/usr/lib/python3/dist-packages/odoo/tools/safe_eval.py", line 373, in safe_eval
pycompat.reraise(ValueError, ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)), exc_info[2])
File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 86, in reraise
raise value.with_traceback(tb)
File "/usr/lib/python3/dist-packages/odoo/tools/safe_eval.py", line 350, in safe_eval
return unsafe_eval(c, globals_dict, locals_dict)
File "", line 18, in <module>
File "/usr/lib/python3/dist-packages/odoo/addons/purchase/models/account_invoice.py", line 258, in write
result = result and super(AccountInvoice, invoice).write(vals)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 283, in write
result = super(MailThread, self).write(values)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_activity.py", line 369, in write
return super(MailActivityMixin, self).write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3149, in write
self._write(old_vals)
File "/usr/lib/python3/dist-packages/odoo/addons/base_automation/models/base_automation.py", line 234, in _write
_write.origin(records, vals, **kw)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/account_invoice.py", line 502, in _write
res = super(AccountInvoice, self)._write(vals)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 3252, in _write
cr.execute(query, params + (sub_ids,))
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
ValueError: <class 'psycopg2.errors.NotNullViolation'>: "null value in column "journal_id" violates not-null constraint
DETAIL: Failing row contains (4085, , PR2213, out_invoice, eb0c6814-4df1-4bdb-b338-6a7d374375cd, null, null, null, null, none, , draft, f, null, null, 5466, null, null, 4, null, 0, 0, 0, 0, 0, 0, 46, null, 1, t, null, 0, 0, 0, 81, null, 5466, null, null, null, 46, 2024-10-22 17:25:53.232706, 1, 2024-10-22 17:25:53.232706, 1, 5472, null, null, t, 15, 4, 33, null, null, f, null, 1, null, null, null, null, null, null, null, f, recibido, null, f, null, null, 0, 0, null, null, null, null, f, null, 1, null, null, null, null, null, null, t, null, null, 2, 1, null, null, null, null, null, null, null, null, f, 1).
" while evaluating
"# Available variables:\n# - env: Odoo Environment on which the action is triggered\n# - model: Odoo Model of the record on which the action is triggered; is a void recordset\n# - record: record on which the action is triggered; may be void\n# - records: recordset of all records on which the action is triggered in multi-mode; may be void\n# - time, datetime, dateutil, timezone: useful Python libraries\n# - log: log(message, level='info'): logging function to record debug information in ir.logging table\n# - Warning: Warning Exception to use with raise\n# To return an action, assign: action = {...}\n\ntype = False\nif record.type in ['out_invoice','out_refund']:\n type = 'sale'\n currency_id = record.currency_id.id if env.user.company_id.currency_id.id != record.currency_id.id else False\n diario = env['account.journal'].search([('company_id', '=', env.user.company_id.id),\n ('currency_id', '=', currency_id),\n ('type', '=', type)], limit=1)\n record.write({'journal_id': diario.id})"
Gracias por tu gestion.