on 06-16-2016 5:06 AM
F-02 Entry:
TAX rate: 8%
POSTK | Account | Amount |
40 | 86120101 | 10 |
40 | 86120101 | 20 |
40 | 86120101 | 40 |
40 | 86120101 | 80 |
50 | 11110101 | 150 |
Simulate in GL:
POSTK | Account | Amount |
40 | 86120101 | 9 |
40 | 86120101 | 19 |
40 | 86120101 | 37 |
40 | 86120101 | 74 |
50 | 11110101 | 150 |
40 TAX | 13910101 | 11 |
TAX rate: 8%
M wondering how net amount calculate result is 9,19,37,74.......
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Go to FB00, select the check box "Calculate taxes on net amount', then it calculates the tax on net amount.
Regards,
Mukthar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
11 | |
11 | |
6 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.