Odoo Help


problem with included tax calculation.

on 3/22/14, 8:42 AM 1,401 views

Hi. I face a problem with included tax calculation. eg: in the invoice line i select a product with unit price value 3000 then

Unit price = 3000
tax = 5% (included in price=True)
Qty = 1
Amount = 2857.14

Subtotal = 2857.14
Tax  = 142.86

Grand total = 3000

. I need the value 2857.14 in the unit price column instead of 3000 in my invoice report. if i select the included tax in the invoice line . . Any way to display this in my invoice report..

in the case of excluded tax (product with unit price 3000) i need these values in my report

Unit price = 3000
    tax = 5% (excluded tax)
    Qty = 1
    Amount = 3000

Subtotal = 3000
Tax  = 150
Grand total= 3150

Now this work fine in my report.

But how to display the value 2857.14 in the unit price column in the invoice report in case of the included tax . And also I need to display 3000 in unit price column if the i select excluded tax . I need both values in the same report . Is it possible .?

try replacing the unit price field with your field using xpath.

on 3/23/14, 9:30 PM

hi silvi, i have updated the question.plz check and answer me

on 3/24/14, 2:05 AM

Are you using a functional field for this ?

on 4/2/14, 1:33 AM

Do you get any solution with this? I have the same problem I would like to work with prices_tax_included because I want to see this kind of price in product form and POS but the invoice should use the price_unit without taxes. Any help is welcome.

on 3/27/15, 7:33 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: 3/22/14, 8:42 AM
Seen: 1401 times
Last updated: 3/27/15, 6:18 PM