c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #13954
[Bug 707923] Re: [6.0 and 5] invoice tax - rounding issue
I first encountered that problem with a Lexware software.
There are two ways to calculate the tax:
- by columns (vertical)
- by lines (horizontal)
Lexware (and obviously OpenERP) use horizontal calculations, while the
most common usage is vertical.
So the totals are, while feeling wrong, actually correct.
(German link)
http://support.lexware.de/portal_support/00897-0000/supportProductFAQDetail?ID=000000000015732&searchTerms=&area=&version=2008&batchStart:int=40
In Germany, both ways are accepted by tax offices.
I don't know about other countries.
In you picture:
A * B = C
1,99 * 0,1 = 0,20
0,38 * 0,1 = 0,04
5,68 * 0,1 = 0,57
0,45 * 0,1 = 0,05
1,05 * 0,1 = 0,11
2,87 * 0,1 = 0,29
SUM(C) => 1,26
while
SUM(A) = 12,42
* 0,1 = 1,24
--
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/707923
Title:
[6.0 and 5] invoice tax - rounding issue
Status in OpenERP Modules (addons):
New
Bug description:
see attachment
due to rounding of the calculated tax for each position we get totals
which are wrong.
In Austria we usually group the basis per tax rate and calculate the
tax from this basis to avoid such errors.
in account/invoice.py
class account_invoice_tax -
def compute must be modified
actually only some lines of code to group the invoice lines before
calculating the tax
probably this has been discussed (but not solved) already
References