Multiple tax in one invoice Tax 0% and 7%

ERPNext
1

Hello everyone,

I am having a little problem on purchase invoice.

I have a two VAT on one invoice 7% and 0% but after set it from tutorial about taxes on youtube from Frappe on submit get error " Tax should be 7.0% of the base amount
Note: To correct base amount, fill in Tax Base Amount." Below my setup do i missing anything?

image
image474Ă—121 6.21 KB

image
image1089Ă—1296 87.1 KB

image
image1092Ă—544 40 KB

image
image1146Ă—429 33.8 KB

image
image1097Ă—431 33.7 KB

image
image1027Ă—458 52.3 KB

Hello everyone,

2 Likes
2

Hi Voltass
Please try the following either should work.
Method 1: Use “Tax Category” per item

  1. Go to your taxable items (7%) in the invoice and set Item Tax Template with 7% VAT.
  2. For zero-rated items (0%), set Item Tax Template with 0% VAT.
  3. In the Taxes table, make sure Charge Type = “On Net Total” and Based On = “Item Tax Template”.
  4. Remove any extra “Tax Base Amount” you typed in — let ERPNext calculate it.
  5. Save & Submit.

Method 2: Adjust “Tax Base Amount” manually

If you want to keep both VATs in the same invoice without templates:

  1. In the Taxes table, for the 7% VAT row, set Tax Base Amount = sum of base amounts of only those items that are taxable at 7%.
  2. For the 0% VAT row, set Tax Base Amount = sum of base amounts of items that are zero-rated.
  3. Make sure Tax Amount is exactly Base Amount Ă— 7% for the 7% row.

Extra checks

Ensure “Validate Tax Amount” setting in your Purchase Invoice DocType isn’t too strict. If you want some tolerance, go to:
Accounts Settings → Tax Calculation Rounding

and adjust.

  • Check that Item Tax Template matches Purchase Taxes and Charges Template.
1 Like
3

I use v15 version there is no option to select Based On or Tax Base Amount to set

4

Right — in Frappe/ERPNext v15, the “Based On” and “Tax Base Amount” fields you’ve seen in older tutorials no longer appear in the default Purchase Taxes and Charges UI.

ERPNext now automatically calculates the tax base amount from:

  • The items linked to the tax via Item Tax Template
  • The “Charge Type” and “Included In Print Rate” settings
  • The “Applicable On” (Net Total / Valuation / Total) field

So the fix for your two VAT rates (7% & 0%) problem in v15 is a bit different than in older versions.

How to do it in ERPNext v15 without Tax Base Amount field

1. Create two Item Tax Templates

  1. Go to: Accounts → Item Tax Template → New
  2. Name: VAT 7%
  • Tax Type: VAT
  • Tax Rate: 7.0
  1. Save.
  2. Create another template: VAT 0%
  • Tax Type: VAT
  • Tax Rate: 0.0

2. Assign the right tax template to items

  • Open each item in your Purchase Invoice and set the Item Tax Template:
    • Items with 7% VAT → VAT 7% template
    • Items with 0% VAT → VAT 0% template

3. Set up Purchase Taxes and Charges Template

  • Go to: Accounts → Purchase Taxes and Charges Template → New
  • Add a row:
    • Type: On Net Total
    • Account Head: VAT Payable
    • Rate: 7.0
  • Save.

(You don’t need to add 0% VAT here; ERPNext will calculate it as zero based on the template.)

4. Use the template in your Purchase Invoice

  • In the Purchase Invoice, select your Purchase Taxes and Charges Template.
  • ERPNext will:
    • Apply 7% VAT to items with the 7% template.
    • Apply 0% VAT to zero-rated items.
    • Calculate correct tax base amounts automatically in the backend.
1 Like
5

this is how i set it first but have this message anyway :

Message

Tax should be 7.0% of the base amount
Note: To correct base amount, fill in Tax Base Amount.

image
image820Ă—1140 56.2 KB

On tax Breakup it assign correct tax but on submit its complain, but if exactly same but with item only 7% is ok, and as well only 0% is ok too same setup