Item Tax Template Invalid

We are still looking for some assistance with a very troubling issue which is preventing us from billing and processing invoices for certain items. Since we upgraded to V12, there is an issue with using the Item Tax Templates. This was never an issue before but now when we try to add an item to an order which has some non-taxable items it throws as error message when we try to post any entries (purchase receipts, Purchase invoice or sales invoices). We are effectively stuck as we cannot process any invoices in or out.

Here is the error message we are presented with. This affects our labor items which are non-taxable in the US.

Does anyone know how to resolve this? This Item Tax Template settings a new feature and it is not in the documentation that I can find. We wished that they left the item tax settings under the ITEM itself like it used to be rather than controlled under a tax template.

We are facing same issue.
Anyone found a fix for this?

Stay tuned - note this recently identified in develop branch that may relate to your case
https://github.com/frappe/erpnext/issues/21616

edit: You have referred to the docs, and can suggest what changes are needed? Item Tax Template

Hi John,
Thanks for your response.

In my case there was some data issue.
I had Tax Category defined on Customer/Supplier and on Addresses, whereas I was not using Tax Category to fetch Sales Tax and Charges Templates, due to this when I removed the Tax Category (fetched from Master) in Sales Invoice, there was a validation error “Item Tax Template Invalid”

I was able to resolve the issue by removing Tax Category mapping from all Masters and making sure my Tax configs are correct.

@AV8 if you look at the way your taxes are configured, you might be able to solve this error.
Let me know if you need help.

1 Like

Thanks John & Manan,

I was also able to proceed by removing the Item Tax Template from the item. This new feature, while clearly intended to improve the taxation flow does not seem to work as intended. We are not on the develop branch and we are experiencing issues with this stable release so I think there is still some bugs to work out.

For now we have a work around of removing the item tax template, but we hope there is an effort to address this new feature as it was very difficult to setup and use, especially since there is not much documentation on using the item tax templates.

Good so you found a fix.

Depending on the issue, resources and so on, I believe bug fixes applied to develop may be back ported to version-12 production branch…

I’m facing the same issue when I’m trying to create a credit note with a sales invoice reference.
I don’t get this issue when I’m creating the Sales Invoice.

I’m presently in
ERPNext: v13.3.1 (version-13) Frappe Framework: v13.3.0 (version-13)

image

This is becoming a very big problem in our operations, can someone help me out here?
Thank You

I found the solution for my case, When I deep dived into the erpnext code I found that tax category which comes from my item taxes table should match with tax category in the customer, previously tax category field in the customer field was empty, then I replaced it with the same tax category and then gawwd!!! it worked!!!

The below one is in customer

The below one was in my item

I have started to get the same issue.

All my products are uploaded in a same excel so i do not have any doubt in master data.

I have also checked all the sales tax documents like sales tax template, item tax template, sales order and sales invoice. All have same words for the tax names and still it is throwing this error.

On top of this, some items I am able to make invoice and sales order without any issue but some items its throwing this error.

Will have to look into the codes.

Update: I tried removing the tax template then it would take the tax from sales tax template in sales invoice and order.
Now I am not able to remove the item tax template from around 1000+ items in bulk import, removing adding blank field is not being accepted.