I am very new to erpnext and i am trying to fetch item wise taxes in print format.
Already we are maintaining hsn wise and item wise taxes.
I really appreciate your help.
I am very new to erpnext and i am trying to fetch item wise taxes in print format.
Already we are maintaining hsn wise and item wise taxes.
I really appreciate your help.
Hello @Khaja_Kareem_Shaik
Currently it’s not available in default system(Item tax now available in html format). Either you can create a separate child table or add a new field in existing Items table for storing that information and call print format.
Thanks
Thanks for your reference Its working but it shows only 14% in CGST Rate and SGST Rate,even if the items have multiple taxes like 28% or 18%
After the latest India Compliance update, you can get the SGST/CGST/IGST rates and amount directly from the item table.
Hello @rtdany10
Do we need Indian compliance for that, or does the newest ERPNext handle it by default? Because we require a similar feature but outside of India. Thank you.
You can use this function: https://github.com/frappe/erpnext/blob/develop/erpnext/regional/united_arab_emirates/utils.py#L9 to get tax rate and amount in the item table. You will have to create the fields in the table and trigger this function on validate.
Thanks for your help.It is working but it shows only 14% in CGST Rate and SGST Rate,even if the items have different item_tax_templates.The Output is showing like this.Please give me any suggestion
Regards
Thanks
I use this
{% 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 -%}
Sr | Description | Tariff/HSN | Quantity | Rate | Amount | CGST Rate | CGST Amount | SGST Rate | SGST Amount | IGST Rate | IGST Amount |
---|---|---|---|---|---|---|---|---|---|---|---|
{{ row.idx }} | {% if row.item_code != row.item_name -%} {{ row.item_code}} {%- endif %} {{ row.item_name }} |
{{ row.gst_hsn_code }} | {{ row.uom or row.stock_uom }} {{ row.qty }} | {{ row.get_formatted(“rate”, doc) }} |
{{ row.get_formatted(“amount”, doc) }} |
{{ it_cgst_rate[0] }}% |
{{ “₹ {:,.2f}”.format(cgst_amt[0]) }} |
{{ it_sgst_rate[0] }}% |
{{ “₹ {:,.2f}”.format(sgst_amt[0]) }} |
{{ it_igst_rate[0] }}% |
{{ “₹ {:,.2f}”.format(igst_amt[0]) }} |
Total |
{{ grand_total[“qty”] }} | {{ “₹ {:,.2f}”.format(grand_total[“amount”]) }} |
{{ “₹ {:,.2f}”.format(grand_total[“cgst_amt”]) }} |
{{ “₹ {:,.2f}”.format(grand_total[“sgst_amt”]) }} |
{{ “₹ {:,.2f}”.format(grand_total[“igst_amt”]) }} |