I have a modified quotation report that works perfectly if theres only one product but when i add another it stops working. This is the for each expression i am using
This is the error it gives when trying to do the quotation with +1 items.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5129, in ensure_one
_id, = self._ids
ValueError: too many values to unpack (expected 1)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "", line 2068, in template_1643
File "", line 2050, in template_1643_content
File "", line 273, in template_1643_t_call_0
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2376, in _get_field
content = converter.record_to_html(record, field_name, field_options)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb_fields.py", line 198, in record_to_html
return super(FloatConverter, self).record_to_html(record, field_name, options)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb_fields.py", line 120, in record_to_html
value = record.with_context(**self.env.context)[field_name]
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5868, in __getitem__
return self._fields[key].__get__(self, type(self))
File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1153, in __get__
record.ensure_one()
File "/usr/lib/python3/dist-packages/odoo/models.py", line 5132, in ensure_one
raise ValueError("Expected singleton: %s" % self)
ValueError: Expected singleton: sale.order.line(51, 52)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1584, in _serve_db
return service_model.retrying(self._serve_ir_http, self.env)
File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
result = func()
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1611, in _serve_ir_http
response = self.dispatcher.dispatch(rule.endpoint, args)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 1815, in dispatch
result = self.request.registry['ir.http']._dispatch(endpoint)
File "/mnt/custom-addons/website/website_require_login/models/ir_http.py", line 17, in _dispatch
return super()._dispatch(endpoint)
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 235, in _dispatch
response = super()._dispatch(endpoint)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
result = endpoint(**request.params)
File "/usr/lib/python3/dist-packages/odoo/http.py", line 697, in route_wrapper
result = endpoint(self, *args, **params_ok)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 42, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 461, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "/usr/lib/python3/dist-packages/odoo/api.py", line 448, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 6502, in onchange
record._onchange_eval(name, field_onchange[name], result)
File "/usr/lib/python3/dist-packages/odoo/models.py", line 6213, in _onchange_eval
method_res = method(self)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 177, in _onchange_template_id_wrapper
values = self._onchange_template_id(self.template_id.id, self.composition_mode, self.model, self.res_id)['value']
File "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 589, in _onchange_template_id
values = self.generate_email_for_composer(
File "/usr/lib/python3/dist-packages/odoo/addons/mail/wizard/mail_compose_message.py", line 719, in generate_email_for_composer
template_values = self.env['mail.template'].with_context(tpl_partners_only=True).browse(template_id).generate_email(res_ids, fields)
File "/usr/lib/python3/dist-packages/odoo/addons/account_edi/models/mail_template.py", line 39, in generate_email
res = super().generate_email(res_ids, fields)
File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_template.py", line 286, in generate_email
result, report_format = self.env['ir.actions.report']._render_qweb_pdf(report, [res_id])
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/ir_actions_report.py", line 57, in _render_qweb_pdf
return super()._render_qweb_pdf(report_ref, res_ids=res_ids, data=data)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 807, in _render_qweb_pdf
collected_streams = self._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/usr/lib/python3/dist-packages/odoo/addons/account_edi_ubl_cii/models/ir_actions_report.py", line 58, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/usr/lib/python3/dist-packages/odoo/addons/account_edi/models/ir_actions_report.py", line 14, in _render_qweb_pdf_prepare_streams
collected_streams = super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/usr/lib/python3/dist-packages/odoo/addons/account/models/ir_actions_report.py", line 20, in _render_qweb_pdf_prepare_streams
return super()._render_qweb_pdf_prepare_streams(report_ref, data, res_ids=res_ids)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 708, in _render_qweb_pdf_prepare_streams
html = self.with_context(**additional_context)._render_qweb_html(report_ref, res_ids_wo_stream, data=data)[0]
File "/mnt/extra-addons/web_studio/models/ir_actions_report.py", line 19, in _render_qweb_html
return super(IrActionsReport, self)._render_qweb_html(report_ref, docids, data)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 884, in _render_qweb_html
return self._render_template(report.report_name, data), 'html'
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_actions_report.py", line 623, in _render_template
return view_obj._render_template(template, values).encode()
File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 418, in _render_template
return super()._render_template(template, values=values)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 2128, in _render_template
return self.env['ir.qweb']._render(template, values)
File "/usr/lib/python3/dist-packages/odoo/tools/profiler.py", line 292, in _tracked_method_render
return method_render(self, template, values, **options)
File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 580, in _render
result = ''.join(rendering)
File "", line 80, in template_1644
File "", line 62, in template_1644_content
File "", line 50, in template_1644_t_call_0
File "", line 2074, in template_1643
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
ValueError: Expected singleton: sale.order.line(51, 52)
Template: sale.report_saleorder_document
Path: /t/t/div/div[5]/div/span[2]/span
Node:
The above server error caused the following client error:
null
