Items AND shipping include taxes

Frappe Framework Customization
#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:

image
image940×750 16.6 KB

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”

#4

I believe it’s pretty common practice to create an Item called “shipping charges”, or “freight costs”. Set it as not tracked in the inventory and make sure it goes against the freight account head. I could be wrong, but I’m pretty sure I’ve noticed a few companies I’ve worked for doing it that way with a few different systems.

#5

Hello

Did you find a solution?