# How to display tax for each line in Report?

**URL:** <https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421>\
**Category:** User\
**Tags:** accounting\
**Created:** [March 6, 2020, 2:01am UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421 "2020-03-06T02:01:35Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![schokjohn](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/e8c25b/32.png) [@schokjohn](https://discuss.tryton.org/u/schokjohn)\
**Post date:** [March 6, 2020, 2:01am UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/1 "2020-03-06T02:01:35Z")

</div>

Hi community,

I have a question about sales and invoices. If I do the follow sale with two sale lines with tax defined (13%):

Line 1  
Price 100  
Tax 13  
Total amount 113

Line 2  
Price 200  
Tax 26  
Total amount 226

How do I show in the sales or invoice report only the tax each line ?

---

<div class="post-metadata">

**Author:** ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)\
**Post date:** [March 6, 2020, 6:52am UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/2 "2020-03-06T06:52:43Z")

</div>

The invoice report will show you grouped tax amounts for all lines with taxes.

If you want to show each tax line separately you should modify the invoice report.

---

<div class="post-metadata">

**Author:** ![schokjohn](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/e8c25b/32.png) [@schokjohn](https://discuss.tryton.org/u/schokjohn)\
**Post date:** [March 6, 2020, 7:33am UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/3 "2020-03-06T07:33:49Z")

</div>

> [@josesalvador](#):
>
> If you want to show each tax line separately you should modify the invoice report.

Hi josesalvador what field i need to add to show tax line separately on reports?

---

<div class="post-metadata">

**Author:** ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)\
**Post date:** [March 6, 2020, 9:55am UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/4 "2020-03-06T09:55:22Z")

</div>

> [@schokjohn](#):
>
> Hi josesalvador what field i need to add to show tax line separately on reports?

I guess you are looking for [this one](https://hg.tryton.org/modules/account_invoice/file/tip/invoice.py#l1716).

---

<div class="post-metadata">

**Author:** ![schokjohn](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/e8c25b/32.png) [@schokjohn](https://discuss.tryton.org/u/schokjohn)\
**Post date:** [March 6, 2020, 12:49pm UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/5 "2020-03-06T12:49:23Z")

</div>

> [@josesalvador](#):
>
> I guess you are looking for [this one](https://hg.tryton.org/modules/account_invoice/file/tip/invoice.py#l1716)

thanks for advice @josesalvador, **i used this field:**

`<format_currency(line.invoice_taxes, invoice.party.lang, currency=invoice.currency)>`

**but received this error:**

```
return eval(self.code, _globals, {' __data__': data})
  File "<string>", line 1182, in <Expression '__relatorio_escape_invalid_chars(format_currency(line.invoice_taxes, invoice.party.lang, currency=invoice.currency))'>
  File "/trytond/report/report.py", line 405, in format_currency
return lang.currency(value, currency, symbol, grouping)
  File "/trytond/ir/lang.py", line 441, in currency
'%%.%if' % digits, abs(val), grouping, monetary=True)
TypeError: bad operand type for abs(): 'tuple'

Fault: bad operand type for abs(): 'tuple'

```

**later i used this field with abs**

`<format_currency(abs(line.invoice_taxes), invoice.party.lang, currency=invoice.currency)>`

but i received this error:

```
Traceback (most recent call last):
  File "/trytond/wsgi.py", line 108, in dispatch_request
    return endpoint(request, **request.view_args)
  File "/trytond/protocols/dispatcher.py", line 48, in rpc
    request, database_name, *request.rpc_params)
  File "/trytond/wsgi.py", line 76, in auth_required
    return wrapped(*args, **kwargs)
  File "/trytond/protocols/wrappers.py", line 131, in wrapper
    return func(request, pool, *args, **kwargs)
  File "/trytond/protocols/dispatcher.py", line 186, in _dispatch
    result = rpc.result(meth(*c_args, **c_kwargs))
  File "/trytond/modules/account_invoice/invoice.py", line 2512, in execute
    result = super(InvoiceReport, cls).execute(ids, data)
  File "/trytond/report/report.py", line 195, in execute
    oext, content = cls._execute(records, data, action_report)
  File "/trytond/modules/account_invoice/invoice.py", line 2493, in _execute
    result = super(InvoiceReport, cls)._execute(records, data, action)
  File "/trytond/report/report.py", line 203, in _execute
    return cls.convert(action, cls.render(action, report_context))
  File "/trytond/report/report.py", line 302, in render
    data = rel_report(**report_context).render()
  File "/relatorio/templates/base.py", line 35, in render
    self.events, method=method, encoding=encoding, out=out)
  File "/relatorio/templates/opendocument.py", line 1169, in __call__
    self.xml_serializer(writer(stream)), encoding=encoding, out=writer)
  File "/genshi/output.py", line 58, in encode
    for chunk in iterator:
  File "/genshi/output.py", line 241, in __call__
    for kind, data, pos in stream:
  File "/genshi/output.py", line 671, in __call__
    for kind, data, pos in stream:
  File "/genshi/output.py", line 776, in __call__
    for kind, data, pos in chain(stream, [(None, None, None)]):
  File "/genshi/output.py", line 596, in __call__
    for ev in stream:
  File "/relatorio/templates/opendocument.py", line 1061, in __call__
    for kind, data, pos in stream:
  File "/genshi/core.py", line 292, in _ensure
    for event in stream:
  File "/genshi/filters/i18n.py", line 691, in __call__
    for kind, data, pos in stream:
  File "/genshi/template/base.py", line 638, in _include
    for event in stream:
  File "/genshi/template/markup.py", line 327, in _match
    for event in stream:
  File "/genshi/template/base.py", line 598, in _flatten
    result = _eval_expr(data, ctxt, vars)
  File "/genshi/template/base.py", line 289, in _eval_expr
    retval = expr.evaluate(ctxt)
  File "/genshi/template/eval.py", line 178, in evaluate
    return eval(self.code, _globals, {' __data__': data})
  File "<string>", line 1182, in <Expression '__relatorio_escape_invalid_chars(format_currency(abs(line.invoice_taxes), invoice.party.lang, currency=invoice.currency))'>
TypeError: bad operand type for abs(): 'tuple'

Fault: bad operand type for abs(): 'tuple'

```

**what am I doing wrong?**

thanks again

---

<div class="post-metadata">

**Author:** ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)\
**Post date:** [March 6, 2020, 12:52pm UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/6 "2020-03-06T12:52:44Z")

</div>

It is a list you will have to iterate.

You can take the [invoice report](https://hg.tryton.org/modules/account_invoice/file/tip/invoice.fodt) as a reference for that.

---

<div class="post-metadata">

**Author:** ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)\
**Post date:** [March 6, 2020, 12:58pm UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/7 "2020-03-06T12:58:49Z")

</div>

> [@josesalvador](#):
>
> I guess you are looking for [this one](https://hg.tryton.org/modules/account_invoice/file/tip/invoice.py#l1716).

Sorry, I think I was wrong, I guess you are looking for [this one](https://hg.tryton.org/modules/account_invoice/file/tip/invoice.py#l158). (InvoiceLine Taxes not InvoiceTaxes…)

Anyway you will have to iterate on the taxes in the same way. The solution probably will be the same.

---

<div class="post-metadata">

**Author:** ![schokjohn](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/s/e8c25b/32.png) [@schokjohn](https://discuss.tryton.org/u/schokjohn)\
**Post date:** [March 6, 2020, 1:54pm UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/8 "2020-03-06T13:54:05Z")

</div>

> [@josesalvador](#):
>
> Anyway you will have to iterate on the taxes in the same way. The solution probably will be the same.

thank you very much @josesalvador but i don’t understand “iterate on the taxes” im not programmer excuse my ignorance

---

<div class="post-metadata">

**Author:** ![josesalvador](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/josesalvador/32/602_2.png) [@josesalvador](https://discuss.tryton.org/u/josesalvador)\
**Post date:** [March 6, 2020, 7:18pm UTC](https://discuss.tryton.org/t/how-to-display-tax-for-each-line-in-report/2421/9 "2020-03-06T19:18:02Z")

</div>

You will obtain a list of taxes so you will have to iterate (one by one) all the taxes per product if you want to show them.

I guess that if you feel this is a task for a developer maybe you will have to look for a partner who helps you to customize the report.

The documentation you will need to know to accomplish this task is placed [here](https://relatorio.readthedocs.io/en/latest/index.html).
