Skip to Content
Menu
This question has been flagged
2 Replies
10095 Views

Good evening. I would like to know if I can configure the order in which the taxes are assigned in the products, when adding them to the detail of a purchase invoice.

Example. I have a tax that is called VAT and another that is called fuel. Currently, Odoo assigns first VAT and underneath it places Petroleo, regardless of the fact that in the product file, this first fuel.

The objective is to place first fuel since not doing so, the calculations are not correct.


Thank you for your support.

Avatar
Discard
Best Answer

In order to create taxes, which depend on other taxes (tax on tax), you create tax groups first.

This is how it is done on Odoo 11.0 CE:

1. Create a tax group for application of fuel tax and VAT:
Go to "Invoicing/Configuration/Taxes". Add a tax group, name it "VAT on fuel" for example, create the tax scope, in your example "Purchases". Under "Tax Computation" select "Group of Taxes". Save the tax group.



2. Add the first tax to be applied (Add Children Taxes):
Edit the tax group again. Under "Add an item" add the first tax to be applied (create a new one, if necessary). Name it "Fuel Tax" for example, set the tax scope ("Purchases" in your example). Set the required tax computation method and amount.


Under the tab "Advanced Options" define the tax label on invoices ("Fuel 20%" for example), select an existing regular tax group and check "Affect Base of Subsequent Taxes".

3. Create the second child tax the same way, name it "VAT" for example:


Under the tab "Advanced Options" define the tax label ("VAT 10%" for example), select an existing regular tax group and do NOT check "Affect Base of Subsequent Taxes". Save & Close.

4. Check your tax group with the children taxes and save it.




5. Assign tax group "VAT on fuel" to a product:


6. Create a purchase order with the same product and check the correct taxes applied:



As you can easily see, first the Fuel Tax of 20% was applied to the purchase price of 1000, which results in a gross amount of 1200, and after that the VAT of 10% was applied to the gross amount, which results in 1200 + 120 = 1320.

Avatar
Discard

Tons of thanks Ermin

Best Answer

hi, some how this method is also not working for me in odoo 17, 

870,000.00 169650 1,039,650.00 155947.5 1,195,597.50
2,012,800.00 392496 2,405,296.00 360794.4 2,766,090.40
100,000.00 19500 119,500.00 119,500.00
4,081,187.90


i need these results but odoo is giving me someother results 

Avatar
Discard
Related Posts Replies Views Activity
6
Dec 24
12356
3
May 25
6391
1
Sep 22
2456
0
May 24
252