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.

1

problem with included tax calculation.

By
Ashmsh.M
on 3/22/14, 8:42 AM 1,006 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.

silvi
on 3/23/14, 9:30 PM

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

Ashmsh.M
on 3/24/14, 2:05 AM

Are you using a functional field for this ?

silvi
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.

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