Skip to Content

SAP Business One Document Rounding Difference

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
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers