Skip to Content
This question has been flagged
2 Replies
1836 Views
Avatar
Amal ben aissa

Hello everyone,

My tax rounding in odoo is wrong

i'm applying a tax of 20% on my products , this tax is based on the price of the product (amount_type=percent) an it is included in the price.

but for a total amount_untaxed =  11194.19, odoo calculates an amount_tax =  2 238,8 and a amount_total = 13 433,00 

But in reallity,  11194.19*0.20 =  2238.838 =  2238.84 and the total amount is supposed to be   13433.03

I've tried to change my rounding methode to global in the accounting configuration but the results are the same in both rounding methods

Any ideas please ?

Thank you

Avatar
Discard
Avatar
Amal ben aissa
Author Best Answer

Hello  Ray, 

Thank you for your response except that i'm in a much complicted situaition,

In fact the prices are retrived through a specific pricelist i don't define the prices on the product.

and my sale order have more than 40 sale order lines with different products , i noticed that if i do calculations on some lines the tax amount is actually 19.9983...

eg : a line with 20units of a product with the TTC unit price =14.50 wich gives me a TTC total for the line = 290.00, and a subtotal computed by odoo = 241.67000000

the tax_amount computed by odoo in this case is 290-241.67 = 48.330000 if i vérify the tax rate according to these amounts by : (48.33/241.67)*100 =  19.9983448504

and this "issue" appears in multiple line and since I have a lot of lines in my invoice i guess it adds up and gives me remarkable difference in total price 

my tax is confgured exactly the same way as you adviced me except for the "Affect base of subsequent taxes" which i checked and still get the same results

thank you

Avatar
Discard
Avatar
Ray Carnes (ray)
Best Answer

Create your Tax like this:


Then your Product like this:


Sales Orders will then look like this:


Invoices will then look like this:


Avatar
Discard