Can anyone help me with an Odoo tax calculation issue?
I have a product listed in an invoice for NT$1440 with a 5% inclusive tax. Odoo calculates that as a cost price of NT$1368, with NT$32 tax. But actually simple math shows tax included at 5% should result in a cost price of NT$1371 and NT$29 tax.
This appears to be more than a simple rounding issue, as the difference is NT$3.
I've seen some mention in previous discussions of a bug/conflict occurring when tax included is used as well as global rounding, but I cannot find the global rounding option listed anywhere in my Odoo installation. I also would like tax to be rounded to whole numbers but I cannot find this option either.
Can anyone help?
Running Odoo 10.0-20170531 (Community Edition)
Does anyone have any kind of guidance - I can't be the only one facing this issue? Odoo is otherwise a fantastic tool, but if simple calculations can't work then I can't use it!
hi, problem is in sale order or invoice? the default tax rate is 5% or other? is there any product was setting with other tax rate?
Hi Fanha - the problem is in occurring in both sales orders and invoices. For instance if I look at a current sales order item, it is showing a total price of $1920 broken down as cost $1824/tax $96. The correct calculation is cost $1829/tax $91 (when rounded).
The default tax rate is 5% excluded, but for some clients they have negotiated an inclusive price. All items in the sales orders and invoices are taxed the same - 5% tax inclusive.