Tax In sales Invoice Items Table

ERPNext
,
1

hello
I have many Items one of items have it’s own tax rate other item use the default tax rate

for example I have 15 % tax which is the default for all items and I do not need to choose it in every item
also I have one item use 5 % tax so I go to Item data from tax tab and make the tax 5%

I add column of tax to my Invoice format as showing in picture

tabletax
tabletax807×313 37.7 KB

so in invoice format I multiply total net amount * 0.15 to get the tax of item the default as showing in picture

multiply
multiply712×711 62.3 KB

Every things will work ok except if one of item in tables have it’s own different tax rate

What Can I do to resolve this problem ,please.

2

Add this condition for tax calculation,
{% if item.tax %}
{{ item.amount * item.tax}}
{%else%}
{{ item.amount * 0.15}}
{% endif %}

item.tax represents the default tax applicable for particular item.

3

Hi @Praveenkumar
The problem is there is no item.tax field in item table
From where i should take item tax value

4

@Hamza_Erpnext Add this condition for tax calculation,

{{ item.amount- item.taxable_value }}

5

@Meet
In sales invoice item table
The column amount is the total net without tax

We don’t have column in item table for amounts with tax so we can not do this
Also i try it but error showing

6

The item row have a Item Tax Template field. The taxes will be calculated and attached under the section of Tax Breakup and GST Breakup.