Dear SAP-Audience,
first of all i dont know, if this problem just applies to the german area. I will describe my problem as best as i can, please bear with me.
My Testsystem is on 9.3 PL 6.
I've encountered the following problem:
I've got an invoices with three itemlines (DocTotal is 77,70€, with VatPercent 19%). If i add the first line like this:
Line = 1
PriceAfterVat = 13.95€
Quantity = 2
VatCode = A2=19%
So PriceBeforeVat for line 1 is: 13.95 * 2 = 27,9 / 119 * 100 = 23,44567 (round to 2 decimals) = 23,45 (correct)
If I add now the other two lines:
Line = 2
PriceAfterVat = 11.95€
Quantity = 2
VatCode = A2=19%
Line = 3
PriceAfterVat = 12.95€
Quantity = 2
VatCode = A2=19%
The following happens:
- PriceBeforeVat for line 1 now is: 13.95 * 2 = 27,9 / 119 * 100 = 23,44567 (round to 2 decimals) = 23,44€(wrong)
- PriceBeforeVat for line 2 now is: 11.95 * 2 = 23,9 / 119 * 100 = 20,08403 (round to 2 decimals) = 20,08€(correct)
- PriceBeforeVat for line 3 now is: 12.95 * 2 = 25,9 / 119 * 100 = 21,76470 (round to 2 decimals) = 21,77€(wrong)
It should be:
PriceBeforeVat for line 1: 23,45€
PriceBeforeVat for line 2: 20,08€
PriceBeforeVat for line 3: 21,76€
The Doctotal without VAT is still correct:
77,70€ / 119 * 100 = 65,29 €
If i add up the way SAP does = 23,44€ + 20,08€ + 21,77€ = 65,29 €
If i add up the way i would calculate the taxes = 23,45€ + 20,08€ + 21,76€ = 65,29€
It seems like there is somewhere a rounding difference, and SAP B1 compensates it with adding one cent to the last item line (and/or subtracting one from the first line). Or is the problem somewhere in the calculation of the tax-values itself?
I hope you can understand the problem im facing. Can someone explain to me if this is correct behaviour?
Because if i think of working with reports, that would show a false value on the Invoices that are printed.
Im pretty sure its not explicitly wrong(DocTotal is still correct), but i want to understand the logic behind the scenes.
Thanks in advance
Add comment