Cgst & sgst missing on print format

1

Please help us to fix the my print format

The second item is not showing the cgst & sgst rate and amount

image
image940×312 7.89 KB

code is show below

{% set cgst_rate = [] -%} {% set sgst_rate = [] -%} {% set igst_rate = [] -%} {% set cgst_account_head = [] -%} {% set sgst_account_head = [] -%} {% set igst_account_head = [] -%} {% set tot_cgst_amount = [] %} {% set tot_sgst_amount = [] %} {% set grand_total = {"qty":0.0, "amount":0.0, "cgst_amt":0.0, "sgst_amt":0.0, "igst_amt":0.0} %} {%- for row in doc.taxes -%} {% if 'CGST' in row.account_head -%} {% set _ = cgst_account_head.append(row.account_head) %} {% set _ = cgst_rate.append(row.rate) %} {%- endif -%} {% if 'SGST' in row.account_head -%} {% set _ = sgst_account_head.append(row.account_head) %} {% set _ = sgst_rate.append(row.rate) %} {%- endif -%} {% if 'IGST' in row.account_head -%} {% set _ = igst_account_head.append(row.account_head) %} {% set _ = igst_rate.append(row.rate) %} {%- endif -%} {%- endfor -%} {%- for row in doc.items -%} {% set cgst_amt = [] -%} {% set sgst_amt = [] -%} {% set igst_amt = [] -%} {% set it_cgst_rate = [] -%} {% set it_sgst_rate = [] -%} {% set it_igst_rate = [] -%} {% set rate_found_item = 0 -%} {%- set item_record = frappe.get_doc("Item", row.item_code) -%} {% for item_tax in item_record.taxes %} {% if item_tax.tax_type == igst_account_head[0] %} {% set _ = it_igst_rate.append(item_tax.tax_rate) %} {% set _ = igst_amt.append(row.amount * it_igst_rate[0] / 100) -%} {% set rate_found_item = 1 -%} {% endif %} {% if item_tax.tax_type == sgst_account_head[0] %} 
		{% set _ = it_sgst_rate.append(item_tax.tax_rate) %}
		{% set _ = sgst_amt.append(row.amount * it_sgst_rate[0] / 100) -%}
		{% set rate_found_item = 1 -%}
	{% endif %}	
	{% if item_tax.tax_type == cgst_account_head[0] %}
		{% set _ = it_cgst_rate.append(item_tax.tax_rate) %}
		{% set _ = cgst_amt.append(row.amount * it_cgst_rate[0] / 100) -%}
		{% set rate_found_item = 1 -%}
	{% endif %}		
{% endfor %}	
{% if rate_found_item == 0 %}

	{% if cgst_rate[0] -%}
	   {% set _ = cgst_amt.append((row.amount * cgst_rate[0])/100) -%}
	   {% set _= it_cgst_rate.append(cgst_rate[0]) -%}
	   {% set rate_found_inv = 1 -%}
       	{%- endif -%}
	{% if sgst_rate[0] -%}
	   {% set _ = sgst_amt.append((row.amount * sgst_rate[0])/100) -%}
	   {% set _= it_sgst_rate.append(sgst_rate[0]) -%}
	   
       	{%- endif -%}
	{% if igst_rate[0] -%}
	   {% set _ = igst_amt.append((row.amount * igst_rate[0])/100) -%}
	   {% set _= it_igst_rate.append(igst_rate[0]) -%}
	   {% set rate_found_inv = 1 -%}
       	{%- endif -%}
{% endif %}
{% if not it_cgst_rate[0] %}
	{% set _ = it_cgst_rate.append(0) %}
	{% set _ = cgst_amt.append(0) %}
{% endif %}
{% if not it_sgst_rate[0] %}
	{% set _ = it_sgst_rate.append(0) %}
	{% set _ = sgst_amt.append(0) %}
{% endif %}
{% if not it_igst_rate[0] %}
	{% set _ = it_igst_rate.append(0) %}
	{% set _ = igst_amt.append(0) %}
{% endif %}
{% set temp_cgst_amt = grand_total["cgst_amt"] + cgst_amt[0] %}
{% set temp_sgst_amt = grand_total["sgst_amt"] + sgst_amt[0] %}
{% set temp_igst_amt = grand_total["igst_amt"] + igst_amt[0] %}
{% set temp_qty = grand_total["qty"] + row.qty %}
{% set temp_amount = grand_total["amount"] + row.amount %}
{% set check = grand_total.update({"qty": temp_qty, "amount": temp_amount, "cgst_amt":temp_cgst_amt, "sgst_amt":temp_sgst_amt, "igst_amt":temp_igst_amt}) %}

	<td style="width: 2%;"><font size = "1">{{ row.idx }}</font></td>
	<td style="width: 20%;"><font size = "1">
		{% if row.item_code != row.item_name -%}
		<b>{{ row.item_code}}</b><br>
		{%- endif %}
                        {{ row.item_name }}
	</font></td>
	<td style="width: 10%;"><font size = "1">{{ row.sac_code }}</font></td>
	<td style="width: 4%; text-align: left;"><font size = "1">{{ row.qty }}<br><small>{{ row.uom or row.stock_uom }}</small> </font></td>
	<td style="width: 10%; text-align: right;"><font size = "1">{{
		row.get_formatted("rate", doc) }}</font></td>
	<td style="width: 11%; text-align: right;"><font size = "1">{{
		"₹ {:,.2f}".format(cgst_amt[0])  }}<br><small>{{
		it_cgst_rate[0] }}%</small></font></td>
	<td style="width: 11%; text-align: right;"><font size = "1">{{
		"₹ {:,.2f}".format(sgst_amt[0])  }}<br><small>{{
		it_sgst_rate[0] }}%</small></font></td>
	<td style="width: 11%; text-align: right;"><font size = "1">{{
		"₹ {:,.2f}".format(igst_amt[0])  }}<br><small>{{
		it_igst_rate[0] }}%</small></font></td>
	<td style="width: 12%; text-align: right;"><font size = "1">{{
		row.get_formatted("amount", doc) }}</font></td>
{%- endfor -%}
Sr Product Details SAC Code Quantity Unit Rate CGST SGST IGST Taxable Amount
2

Perhaps tax rate in the item master was updated later it’s selected in the transaction. Please review tax details again in the Item master, and then reselect that item in the transaction.

3

same effect :frowning: