This question has been flagged
2 Replies
6865 Views

I want to calculate a special tax on shipping costs.

Example:

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?

Avatar
Discard

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

Author

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.

Best Answer

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)

Avatar
Discard
Best Answer

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.

Avatar
Discard

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