How to calculate total amount based on doc items using jinja template

[yogendrasinh]

Hello All,

I want to calculate the total amount based on doc items of sales order I referred base erpnext code but can’t find any reference related to calculating the total.

I want to calculate total amount and show it in shopping cart Sales order.

Below is my code:

{%- set total_amount = 0.0 -%}
{%- for item in doc.items -%}
{{ total_amount + (item.price_list_rate * item.qty) }}
{% endfor %}

In my system, jinja version is: Jinja2 2.8
I am stuck here. Please help me if anyone has the idea about it.
Thanks in advance.

[adnan]

Its considering your variable as string.

Try someting total_amount += (item.price_list_rate*item.qty)

If above dosent work you can always try to pars result as float

[yogendrasinh]

Hello @adnan,
Thanks for the reply.

Sry, I forgot to mention it in my question.
I already try that but it was given the below error:

/frappe-bench/apps/erpnext/erpnext/./templates/includes/order/order_taxes.html", line 50, in template
{{ total_amount += (item.price_list_rate * item.qty) }}
TemplateSyntaxError: unexpected ‘=’

Also, Tryied below code but its also not give expected result:

{%- set total_amount = 0.0 -%}
{%- for item in doc.items -%}
{% set total_amount = total_amount + (item.price_list_rate * item.qty) %}
{% endfor %}

Is there another way to do it?

[adnan]

@yogendrasinh

{%- set total_amount = 0.0 -%}

{%- for item in doc.items -%}

{% set total_amount = total_amount + (item.price_list_rate * item.qty) %}

{% endfor %}

what’s the result of this code?

[yogendrasinh]

the result only shows the 0.0 or last item total not all items total.
that we initialize in the variable.
Means In the code below expression not working.

[yogendrasinh]

Hello All
Any other way for it?

[ashish-greycube]

    {% set total_amount = [] %}
    {%- for item in doc.items -%}
    {% if total_amount.append((item.price_list_rate * item.qty)) %}{% endif %}
    {% endfor %}
    {{_("{0}").format(total_amount | sum)}}

[lasalesi]

Or

{% set vars = {'total_amount': 0} %}
{% for item in doc.items %}
  {% if vars.update({'total_amount': vars.total_amount + item.amount }) %}{% endif %}
{% endfor %}
{{ vars.total_amount }}

[yasserelbana]

This code working very well, thank you

[sanjay]

See below :

[Tutorial] Jinja How To : Add and update dictionary for grouping

Other way : You can use below code to add and update dictionary for grouping and summing up value: {% set items = [ {'item_code':'item1', 'qty': 100, 'amount': 1000}, {'item_code':'item2', 'qty': 200, 'amount': 2000}, {'item_code':'item1', 'qty': 100, 'amount': 1000}, {'item_code':'item3', 'qty': 300, 'amount': 3000}, {'item_code':'item2', 'qty': 200, 'amount': 2000}, ] %} {%- set item_group= dict() -%} {%- for item in items -%} {%- set qty = item.qty + item_group.get(item.item_code, {}).…

[bella.zahar]

@ashish-greycube

  {% set total_amount = [] %}
    {%- for item in doc.items -%}
    {% if total_amount.append((item.price_list_rate * item.qty)) %}{% endif %}
    {% endfor %}
    {{_("{0}").format(total_amount | sum)}}

this code is very helpful. thank you very much.