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

Incorrect calculations of Odoo with the taxes

By
Laura
on 4/6/16, 4:31 AM 417 views

Is it possible put price on product without tax and show it in the webshop with tax? (Odoo 8)

Because if you put price with tax on product the quotations calculations are incorrect.


EXAMPLE, first way and correct:


Product: Test , price: 2,55 (without tax)

Client: I want 4 Test products

Calculation: 2,55 * 4 = 10,2 --> with tax 10,2 * 1,21 = 12,342 (Rounded Total PRICE: 12,34 €) <----- CORRECT!!!!

This way it doesn't shows on ecommerce the price with tax... but it's the correct

---------------------

If you put price on product with TAX, What happens? This price you will put on the price product (with tax), on the backend you need to put on Accounting/Taxes/Taxes "Price included on the price". This way ecommerce shows product price with tax.... but....


Second WAY:


Product: Test , price: 2,55 * 1,21 = 3,0855 --> Rounded to 3,09 (with tax) 

Client: I want 4 Test products

Calculation that Odoo do: 3,09 / 1,21 = 2,55371900826446 * 4 = 10,21487603305784 * 1,21 = 12,35999999999999 (Rounded Total PRICE: 12,36 €) <--- (Odoo get all the decimals) WRONG!!!!!!!!!!!!!!!!!!!


What is the solution ??? Everybody have this problem but nobody have realized about it??? . I think that is important solve it.. 

0

Ermin Trevisan

--Ermin Trevisan--
3546
| 6 3 7
Walchwil, Switzerland
--Ermin Trevisan--


Ermin Trevisan
On 4/6/16, 8:46 AM

I can not see a problem. According to my understanding your price including VAT is EUR 3.09 and not 3.0855, because nobody knows anything else as long as you do publish prices with only 2 decimals. Either you are selling at a price of 2.55 excl. VAT or you are selling at a price of 3.09 incl. VAT, these are two different prices and have nothing to do with each other. You have also to use 2 different pricelists for this purpose.

The real problem is that I need to work without VAT and It only show the price with VAT in the webshop. Because the correct calculation is without VAT :S Is it possible? Do I need to do a module?

Laura
on 4/13/16, 2:27 AM

There is NO incorrect calculation, as I have mentioned, therefore that can NOT be the reason why you would want to show prices excl. VAT. If for any other reason you want to show prices excl. VAT, then you should set up an according pricelist.

Ermin Trevisan
on 4/13/16, 3:45 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

1 follower(s)

Stats

Asked: 4/6/16, 4:31 AM
Seen: 417 times
Last updated: 4/6/16, 8:46 AM