Odoo Help

Welcome!

This community 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.

0

complex tax calculation, how?

By
Tankgirl
on 2/24/14, 11:18 AM 1,048 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?

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.

Tankgirl
on 2/25/14, 4:42 AM
0

michel Guénard

--michel Guénard--
1033
| 5 5 8
VIROFLAY, France
--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)

0
a.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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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