Tax Calculations based on Item Tax Template

ERPNext
,
1

Hello All,

I have a question regarding Tax Calculations.
I have an item with two Item Tax Templates defined: one for sales transactions and one for purchase transactions. However, when performing a transaction, ERPNext always fetches only the first Item Tax Template defined on the item.

I attempted to address this by adding two checkboxes on the Item Tax Template, Input and Output, and implementing a client script to select the Input template for purchase transactions and the Output template for sales transactions. However, this logic is being overridden by ERPNext’s standard functionality.

What is the recommended approach to handle this scenario?
Please note that within the same transaction, there can be both taxable and non-taxable items.

2

Try these 2 if they are similar to your situation: -

&

3

yeah it wont work , on our end we are creating an a custom app for that , l dont know if ERPNext deliberately made this error , because its actually a bug not a misconfigaration

4

@francis1 Did you put the 0% in the sales template IN ADDITION to the 15% in the item template?

5

yes l have another items which uses 0% and others uses 15%

6

@francis1 still i think there is misunderstanding between us
You need to create 2 item tax templates - one for 15% and one for 0%
AND You also need a sales tax template which has 0% in it (very important - i think you have missed this one)
I have done a video where it works for me (ERPNext Version 15.85.1) https://drive.google.com/file/d/10ak9ppDTToYCIWyZUGN4eSPfNMvBe7cz/view?usp=drive_link

I am still baffled why it does not work for you
If possible send me a video of yours and we can then connect on telegram

1 Like
7

Hi @francis1 @Ayesha

Tax Category can serve the purpose of filtration and bring relevant item tax templates on transaction level.

It can be easily set on item group level as following;

image
image1871×850 89 KB

@asieftejani

Please do not write irrelevant and chatgpt kind of posts as those are not serving any purpose and misleading users.

8

thank for the details video let me try that exactly and feedback you shortly

9

thanks man , this had worked , only one issue now , its dot allow price is inclusive of tax even though l have ticked the price is inclusive . but l wonder ERPNext did it like this , its like trick , its not logical

10

@francis1 - can you give me an example

11

below is the video link , so the issue is that if my selling prices are inclusive of VAT they should not increase prices when l do a sales invoice , for example if the selling price is $1 , when l am selling it its now putting $1.15 instead yet the normal procedure if l tick tax in inlcuded in sales tax template it should work

12

@francis1
So for this to work go to: -
Sales Taxes and Charges Template - > In each row enlarge for extra settings (small pencil on right) → click on “Is this Tax included in Basic Rate?”
Let me know if it works or you need a video

13

@francis1 - did it work?