This question has been deleted.

This question has been undeleted.

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**

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

0
Comments

## Add comment