cancel
Showing results for 
Search instead for 
Did you mean: 

How net amount calculate when Calculate tax automatically

Former Member
0 Kudos

F-02 Entry:


TAX rate: 8%


POSTKAccountAmount
408612010110
408612010120
408612010140
408612010180
5011110101150

Simulate in GL:

POSTKAccountAmount
40861201019
408612010119
408612010137
408612010174
5011110101150
40 TAX1391010111

TAX rate: 8%

M wondering how net amount calculate result is 9,19,37,74.......

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Yunbin, I think the above logic provided is incorrect.

Let me try to explain the logic for you.

Please take a look at the SAP Note 84356.

It describes how tax is calculated in the case of several tax-relevant lines.

First, calculation of tax and tax base amount as described in Note 80977.

1. System takes the gross amount as base amount and considers it as a net amount. Auxiliary base amount:  RMB 150

2. It calculates the new gross amount (tax rounded according to rounding rule)

Auxiliary gross amount: RMB 150* 1.08 = RMB 162 

3. It interpolates straight-line what the base amount would be for the original gross amount of RMB 162  .

A commercial rounding is always made here as it is correct during an interpolation.

Aux. base amount: RMB 150*150/162 = 138.8888888888889 = 139

4. Tax calculation from the base amount (tax rounded according to rounding rule) base amount * tax rate = tax

Tax:    RMB 139 * 0.08 = 139*0.08 = 11.12 = 11 RMB  

Line 1 tax = 10* 11/150= 1 RMB  

Line 2 tax = 20* 11/150 = 1 RMB  

Line 3 tax = 40* 11/150 = 3 RMB  

Line 4 tax = 80* 11/150 = 6 RMB

Line 1 base amount = 10-1 = 9

Line 2 base amount = 20-1 = 19

Line 3 base amount = 40-3= 37

Line 4 base amount = 80-6= 74

So you got the following postings

40 86120101 9

40 86120101 19

40 86120101 37

40 86120101 74

50 11110101 150

40 TAX 13910101 11

Best Regards Zidane

former_member198650
Active Contributor
0 Kudos

Hi,

Go to FB00, select the check box "Calculate taxes on net amount', then it calculates the tax on net amount.

Regards,

Mukthar

Former Member
0 Kudos

Thx for your reply.

But I stll want to know how sap calculate these amount,,,

former_member198650
Active Contributor
0 Kudos

Hi,

(92/100)*10 =  9

(92/100)*20 = 19

(92/100)*40 = 37

(92/100)*80  = 74

The formula for above calculation is (100-tax rate/100)*gross value

Regards,

Mukthar

P.S: If your issue is resolved, please close it.