Skip to Content
This question has been flagged
invoiceqwebtax_codetax_nameodooV8
2 Replies
7778 Views
Avatar
E.M.

Hi, I am trying to modify one field in invoice reports.

			<div class="row" t-if="o.tax_line">
				<div class="col-xs-6">
					<table class="table table-condensed">
						<thead>
							<tr>
								<th>Invoice detail</th>
								<th class="text-right">Base</th>
								<th class="text-right">Amount</th>
							</tr>
						</thead>
						<tbody>
							<tr t-foreach="o.tax_line" t-as="t">
							        <td><span t-field="t.name"/></td>
								<td class="text-right">
									<span t-field="t.base" t-field-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: &quot;o.currency_id&quot;}"/>
								</td>
								<td class="text-right">
									<span t-field="t.amount" t-field-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: &quot;o.currency_id&quot;}"/>
								</td>
							</tr>
						</tbody>
					</table>
				</div>
			</div>

Instead of tax name (<td><span t-field="t.name"/></td>) I would like to use tax description, but unfortunately description is not available in t object.

Is it possible to look for tax description from tax name? How and where should I start looking?

Thanks 

################################### EDITED AFTER AXEL'S ANSWER

Following Axel's answer (thanks a lot, that it is a really comprehensive answer which really helps to understand how to write a parser), I am trying to fully understand and adapt the code to my specific case as I guess it is a not so unusual need. 


My report is being defined in a custom module with the following structure (so far, so good):

custom_reports
¦
¦___    __init__.py
¦
¦___    __openerp__.py
¦
¦___    xml
        ¦
        ¦___  custom_reports.xml


In custom_reports.xml I define the new custom invoice report (again, so far, so good):

...
        <report
            id="report_invoice_custom"
            model="account.invoice"
            string="Custom invoice report"
            report_type="qweb-pdf"
            name="custom_reports.invoice_custom"
            attachment_use="False"
            file="custom_reports.invoice_custom"
                attachment = "(object.state in ('open','paid')) and ('F_'+(object.number or '').replace('/','')+'.pdf')"
        />
...


I am adding the new parser to this module (which makes sense to have everything in the same module) and specifying the proper import in __init__,py so invoice_parser is read:

custom_reports
¦
¦___    __init__.py
¦
¦___    __openerp__.py
¦
¦___    invoice_parser.py  <<-- NEW PARSER
¦
¦___    xml
        ¦
        ¦___  custom_reports.xml

 

I add the code from Axel, restart server and upgrade module but still select_value can't be evaluated:


Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/controllers/main.py", line 121, in report_download
    response = self.report_routes(reportname, docids=docids, converter='pdf')
  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/report/controllers/main.py", line 65, in report_routes
    pdf = report_obj.get_pdf(cr, uid, docids, reportname, data=options_data, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 191, in get_pdf
    html = self.get_html(cr, uid, ids, report_name, data=data, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 176, in get_html
    return self.render(cr, uid, [], report.report_name, docargs, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 152, in render
    return view_obj.render(cr, uid, template, values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_ui_view.py", line 1029, in render
    return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 261, in render
    return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 436, in render_tag_call
    d[0] = self.render_element(element, template_attributes, generated_attributes, d)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 422, in render_tag_foreach
    ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 367, in render_tag_raw
    inner = self.eval_str(template_attributes["raw"], qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 213, in eval_str
    val = self.eval(expr, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 205, in eval
    raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 202, in eval
    return qwebcontext.safe_eval(expr)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 88, in safe_eval
    return eval(expr, None, locals_dict, nocopy=True, locals_builtins=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/addons/report/models/report.py", line 135, in translate_doc
    return self.translate_doc(cr, uid, doc_id, model, lang_field, template, values, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/report/models/report.py", line 115, in translate_doc
    return self.pool['ir.ui.view'].render(cr, uid, template, qcontext, context=ctx)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_ui_view.py", line 1029, in render
    return self.pool[engine].render(cr, uid, id_or_xml_id, qcontext, loader=loader, context=context)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 261, in render
    return self.render_node(self.get_template(id_or_xml_id, qwebcontext), qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 431, in render_tag_if
    return self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 422, in render_tag_foreach
    ru.append(self.render_element(element, template_attributes, generated_attributes, copy_qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 300, in render_node
    result = self.render_element(element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 321, in render_element
    g_inner.append(self.render_node(current_node, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 298, in render_node
    result = self._render_tag[t_render](self, element, template_attributes, generated_attributes, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 373, in render_tag_esc
    inner = widget.format(template_attributes['esc'], options, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 992, in format
    return escape(self._format(inner, options, qwebcontext))
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 989, in _format
    return self.pool['ir.qweb'].eval_str(inner, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 213, in eval_str
    val = self.eval(expr, qwebcontext)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 205, in eval
    raise_qweb_exception(message="Could not evaluate expression %r" % expr, expression=expr, template=template)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 202, in eval
    return qwebcontext.safe_eval(expr)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_qweb.py", line 88, in safe_eval
    return eval(expr, None, locals_dict, nocopy=True, locals_builtins=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>
QWebException: ""'NoneType' object is not callable" while evaluating
'select_value(t.name)'" while evaluating
"translate_doc(doc_id, doc_model, 'partner_id.lang', 'custom_reports.invoice_custom_document')"

 


Avatar
Discard
Axel Mendoza

Your parser is not be used by Odoo.
Check the answer of https://www.odoo.com/nl_NL/forum/help-1/question/how-to-register-a-parser-for-a-qweb-report-91416
To see how you can define it to be picked

E.M.
Author

Done! thanks Axel!

Avatar
Axel Mendoza
Best Answer

Hi E.M

At first glance you couldn't because the field that you wan't is at the model account.tax but the model that you are iterating is account.invoice.tax and the code that compute the values for create the invoice taxes don't use that field.

To do it you have two options:

You could create a parser to find the original account.tax record used to create your account.invoice.tax and return the description

Or you could extend in account.invoice.tax model:

 @api.v8
 def compute(self, invoice):

to copy your field. This efforts seem to much for the result ... evaluate yourself

=============================================================

How to create a parser method to allow you to search the original tax description

=============================================================

from openerp.report import report_sxw
from openerp.osv import osv
from openerp import api

class invoice_parser(report_sxw.rml_parse):

    def __init__(self, cr, uid, name, context):
        super(invoice_parser, self).__init__(cr, uid, name, context=context)
        self.localcontext.update({
            'select_value': self._selection_value,
        })
    
    def _selection_value(self, value):
        if value:
            tax_pool = self.pool.get('account.tax')
            tax_ids = tax_pool.search(self.cr, self.uid, [('name', '=', value)])
            if tax_ids:
                tax_id = tax_pool.browse(self.cr, self.uid, tax_ids[0])
                return self._translate(tax_id.description)
        return value
    
class report_custom_invoice_parser(osv.AbstractModel):
    _name = 'report.module.invoice.wrapper'
    _inherit = 'report.abstract_report'
    _template = 'module.invoice_template'
    _wrapped_report_class = invoice_parser

note that you need to change the name of the report template module.invoice_template

next in your report template you could do this:

<td><span t-esc="select_value(t.name)"></td>



Avatar
Discard
E.M.
Author

I think I get the idea on extending account.invoice.tax model, but I am not sure on what do you mean with "create a parser to find the original account.tax record and return the description". The result/benefit might not be obvious but unfortunately Spanish Chart of Accounts are configured so description is the right field to use.

Axel Mendoza

The idea of the parser is to used in the report, to search for the value of the tax description on account.tax based on the invoice tax value you have, something like a translator for your case, but used directly in the report without change any other behavior or create any other field to store the tax description

E.M.
Author

Is it difficult to achieve it? Could you point a basic example or basic steps? If I have understood it properly is something that you do in the QWeb report code.

Axel Mendoza

It's not qweb code, in qweb you only invoke a function in the parser(python class registered for the specific report) passing the t.name and in that function you search for the original account.tax with that value and return the corresponding description field value

E.M.
Author

Thanks Axel, could you please help me with an example of function call from the QWeb report?. I can manage the python part, but not sure on how to call that parsing function from the report. Thank you very much indeed.

Axel Mendoza

example in the edited answer

Axel Mendoza 
solved?
already?
E.M.
Author

Thanks a lot for such comprehensive answer, I do really appreacite your time and knowledge sharing. I have spent quality time to understand your code but still miss how to import my custom report so the parser can find it. See my edited initial answer for details in case you can help further. Thanks.

Axel Mendoza

If, it was good, could you upvote?

E.M.
Author

I finally manage to understand that the only thing to be modified in your code (correct me if I am wrong) is: _template = 'module.invoice_template'. I have tried with all the templates that apply to my custom report, but Odoo can not find the parser: QWebException: ""'NoneType' object is not callable" while evaluating 'select_value(t.name)'" while evaluating "translate_doc(doc_id, doc_model, 'partner_id.lang', 'custom_reports.invoice_custom_document')"

Avatar
Parikshit Vaghasiya
Best Answer

Hello  E.M,

you can change this name to Description like this :

<td><span t-field="t.description"/></td>

hope this will help you !!

Avatar
Discard
E.M.
Author

No, that does not work, as t has no description value.

Parikshit Vaghasiya

i have doing this in my local . its working fine. its take description value . t has object of account.tax so it take description value.

E.M.
Author

t is not account.tax -see Axel's comment-. In invoice report, there is another region where you can use t.description, but it is not the case here.

Related Posts Replies Views Activity
Invoice Odoo 8 - How to have the subtotal with taxe in Invoice report
invoice qweb odooV8
Avatar
0
Aug 16
3465
How to remove the Tax Code label in the invoice?
invoice tax_code odooV8
Avatar
0
Jul 15
5238
printing "sale.order" fields in account.invoice pdf (qweb) Solved
pdf invoice qweb odooV8
Avatar
Avatar
3
Jan 21
7800
Edit invoice template in Odoo 8 Solved
invoice qweb edit odooV8
Avatar
Avatar
Avatar
Avatar
Avatar
10
May 18
56514
how we design custom report in odoov8.0
invoice qweb reports odooV8
Avatar
Avatar
1
Oct 15
5345