Multiple Items with multiple tax rates in one purchase / sales invoice?

ERPNext India Compliance
1

How can we use multiple Items with multiple tax rates in one purchase / sales invoice?

2

Hi,

You can achieve the same with the Item Tax Template. Please read this: Item Tax Template

Thanks,

1 Like
3

Hi,
Any sample video link please.

4

Hi,

Please find the video link: ERPNext - Item Tax Template and Tax Category in version 12 - YouTube

Video is bit old but will work.

Thanks,

1 Like
5

hi,
You have to set item tax template in item master

6

but item tax template we can choose one ledger like input or output so example i choose input account with tax rate 5 then i enter purchase and sales both tax charges showing same ledger so entry is posing wrong

if i need post input and output tax separate but tax rate should be choose item level then how possible ?

7

Item Tax Template is used to determine mine the rate for taxes specified in the Transaction.

So in a transaction, if the item tax template is specified and the tax account specified in the transaction is in the Item Tax Template, then the rate will be used from the Item Tax Template; else it will be used from the tax row.

The India Compliance app already provides default templates.

GST Item Tax Template

image
image896×262 16.6 KB

8

Item tax template have this all tax rate then ones purchase select that item purchase tax template tax table will fill this all tax row right ?

My requirement is vat side input and out put post separately and 2 tax rate 5% and 15% how manage this we cant remove every time manually table tax template table side now what happen my side ones i select purchase tax template with 5% and 15% but invoice product only 15% that time tax table showing both tax row for 5 and 15% bcz of template have both so how to handle proper setup for vat accounting

9
  • Disable automatic taxes row fetching from item tax template.
  • Use Purchase/Sales Taxes and charges template with applicable taxes to fetch tax rows.
  • Sales Taxes and Charges Template

image
image1858×831 102 KB

10

yes that i can disable then i will choose tax template manually in tax table so suppose i have 2 item with in invocie 1 is 5% and 15% also so if i choose purchase tax template both ledger available then no issue but if invoice only 1 item with 15% tax then i choose same template i get 2 row with 5% tx also that is wrong i will manually remove from tax that is every time handle difficult and even we don’t know 100 item in one invoice so that also i can cover with purchase tax template tax rate 0 but that time i need to add multiple matching ledger with item tax template side so this all very complected i feel so i want confirm any other proper way or i am in right track or not

11

1 Like