Odoo Help


complex tax calculation, how?

on 2/24/14, 11:18 AM 1,547 views

I want to calculate a special tax on shipping costs.


Someone purchased two products: one product with 6% taxes and one with 21%

  • Product one is 7,50 with 6% tax included
  • Product two is 2,50 with 21% tax included

Total amount is 10.00 euro with tax included

  • So 75% of the products are taxed with 6% tax
  • and 25% of the producs are taxed with 21% tax

Shipping costs are 3,50 with tax included, but: 75% of 3,50 needs to be taxed with 6% tax and 25% of 3,50 with 21%tax

How do I do this?

Hi; Which accounting system are you using (Which Country) ?

Med Said BARA
on 2/24/14, 11:57 AM

I'm using Openerp 7.0, Dutch language (The Netherlands). I already have the 6% tax and 21% tax configured, but I want a special tax for shipping-costs. The amount of Tax on shipping-costs depends on what kind of products are being purchased.

on 2/25/14, 4:42 AM

michel Guénard

--michel Guénard--

| 5 5 8
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard
On 6/18/14, 12:45 PM

Create a tax code (new and specific to your case) where the calculation will result from a python formula

Code Python (TVA Incl)

result = ((price_unit*0.75*0.06) + (price_unit*0.25*0.21))

where price_unit is the price of the product "Shipping to be invoiced" (to be created in your system)

André Schenkels
On 2/25/14, 5:30 PM

The easiest way would be to just create 2 shipping cost products 1 with 6% and one with 21%

But this will not be easy to fix. You will need to build a small module for this.

I think, the solution maybe in " Price List".

Med Said BARA
on 2/26/14, 4:34 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 2/24/14, 11:18 AM
Seen: 1547 times
Last updated: 3/16/15, 8:10 AM