ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Items AND shipping include taxes


#1

Hi !

I’m in the situation in which I receive an invoice from a supplier, in which the total includes VAT. But when I say the total, I mean both the items listed are with a price that includes VAT, but also the shipping.

So I’ve got my l list of items, and then in the “Taxes and Charges” table, I’ve got both my shipping fees and my taxes:

I saw the option “Is this Tax included in Basic Rate?”. It works perfectly when I have no shipping fees, but as soon as I have shipping fees, I’m stuck.

Indeed, my shipping fees are added with the type “Actual”, as they do not depend on the net amount but on the location of the client, and VAT is the added as “On Previous Row”.

I’d like to be able to check “Is this Tax included in Basic Rate?” so that it adapts the shipping too and prints the value without VAT in the pdf, and then calculates the correct VAT value so that my grand total does not change.

How could I do this?

Thanks in advance for you help!


#2

Just work out what the shipping charge is excluding VAT, and set the “includes VAT” to yes


#3

Except that I can’t do that, since the I can’t set “includes VAT” to yes with the type “Actual”… and I can’t check it either in the second row as it says “For row 2 in Sales Taxes and Charges. To include On Previous Row Total in Item rate, rows 1 must also be included”