Error gross salary double in FORM 16

[Former Member]

Dear Experts,

Before Apr-2011, Income tax and gross salary are calculated correctly. Then Customer request me to update in SAP for the year 2011-2012 as below

For Males

Rupees 0 to 180000 - Nil ?

Rupees 180001 to 500000 - 10%

Rupees 500001 to 800000 - 20%

Rupees 800001 and above - 30%

Plus Education Cess @ 3% on income tax

For Females

Rupees 0 to 190000 - Nil ?

Rupees 190001 to 500000 - 10%

Rupees 500001 to 800000 - 20%

Rupees 800001 and above - 30%

Plus Education Cess @ 3% on income tax

Before change

V_T7INT1

ED01 Education cess rates 01.04.2004 31.12.9999

ED02 Education cess rates 01.04.2011 31.12.9999

SL16 Income tax rates for men 01.04.2010 31.12.9999

SL17 Income tax rates for women 01.04.2010 31.12.9999

SL18 Income tax rates for senior citizens 01.04.2010 31.12.9999

SL19 Income tax rates for employees without PAN 01.04.2010 31.12.9999

V_T7INT3

ED01 01 99,999,999.00 2.00 INR

ED02 01 99,999,999.00 3.00 INR

SL16 01 160,000.00 0.00 INR

SL16 02 500,000.00 10.00 INR

SL16 03 800,000.00 20.00 INR

SL16 04 99,999,999.00 30.00 INR

SL17 01 190,000.00 0.00 INR

SL17 02 500,000.00 10.00 INR

SL17 03 800,000.00 20.00 INR

SL17 04 99,999,999.00 30.00 INR

SL18 01 240,000.00 0.00 INR

SL18 02 500,000.00 10.00 INR

SL18 03 800,000.00 20.00 INR

SL18 04 99,999,999.00 30.00 INR

SL19 01 800,000.00 20.00 INR

SL19 02 99,999,999.00 30.00 INR

After change

V_T7INT1

ED01 Education cess rates 01.04.2004 31.03.2011

ED02 Education cess rates 01.04.2011 31.12.9999

SL16 Income tax rates for men 01.04.2010 31.03.2011

SL17 Income tax rates for women 01.04.2010 31.03.2011

SL18 Income tax rates for senior citizens 01.04.2010 31.03.2011

SL19 Income tax rates for employees without PAN 01.04.2010 31.03.2011

SL20 Income tax rates for men 01.04.2011 31.12.9999

SL21 Income tax rates for women 01.04.2011 31.12.9999

V_T7INT3

ED01 01 99,999,999.00 2.00 INR

ED02 01 99,999,999.00 3.00 INR

SL16 01 160,000.00 0.00 INR

SL16 02 500,000.00 10.00 INR

SL16 03 800,000.00 20.00 INR

SL16 04 99,999,999.00 30.00 INR

SL17 01 190,000.00 0.00 INR

SL17 02 500,000.00 10.00 INR

SL17 03 800,000.00 20.00 INR

SL17 04 99,999,999.00 30.00 INR

SL18 01 240,000.00 0.00 INR

SL18 02 500,000.00 10.00 INR

SL18 03 800,000.00 20.00 INR

SL18 04 99,999,999.00 30.00 INR

SL19 01 800,000.00 20.00 INR

SL19 02 99,999,999.00 30.00 INR

SL20 01 180,000.00 0.00 INR

SL20 02 500,000.00 10.00 INR

SL20 03 800,000.00 20.00 INR

SL20 04 99,999,999.00 30.00 INR

SL21 01 190,000.00 0.00 INR

SL21 02 500,000.00 10.00 INR

SL21 03 800,000.00 20.00 INR

SL21 04 99,999,999.00 30.00 INR

After change, gross salary accumulate year 2010-2011 to Apr-2011. it is no correct. It should be calculated only Apr-2011

Please let me know the configuration above is ok or not? I reuse Slab code ED02. What is confuse? should I create new Slab code ED03 to replace ED02 ? Please advise

Thanks and Best regards

David Duc

[Former Member]

Hi David,

Following entries are missing in your system -

V_T7INT1

SL20 Income tax rates for men without PAN 01.04.2010 31.12.9999

SL21 Income tax rates for women without PAN 01.04.2010 31.12.9999

SL22 Income tax rates for senior citizens without PAN 01.04.2010 31.12.9999

V_T7INT3

SL20 01 160,000.00 0.00 INR

SL20 02 800,000.00 20.00 INR

SL20 03 99,999,999.00 30.00 INR

SL21 01 190,000.00 0.00 INR

SL21 02 800,000.00 20.00 INR

SL21 03 99,999,999.00 30.00 INR

SL22 01 240,000.00 0.00 INR

SL22 02 800,000.00 20.00 INR

SL22 03 99,999,999.00 30.00 INR

May be while updation these entries has been overwriten or some other issue with it.

Check the same and match with 2011 Budget Note.

- Praveen

[Former Member]

Dear Praveen,

Thank very much for your supports,

There are some problem needing your supports below:

Below is customer's requirement:

For Males

Rupees 0 to 180000 - Nil ?

Rupees 180001 to 500000 - 10%

Rupees 500001 to 800000 - 20%

Rupees 800001 and above - 30%

Plus Education Cess @ 3% on income tax

For Females

Rupees 0 to 190000 - Nil ?

Rupees 190001 to 500000 - 10%

Rupees 500001 to 800000 - 20%

Rupees 800001 and above - 30%

Plus Education Cess @ 3% on income tax

Base on customer's requirement, I think that we should apply only 3 Slab code For Males, For Females, Education Cess.

For Males, For Females, I have created 2 slab codes : SL20, SL21. However, for Education Cess, we reuse ED02 by way:

Before change:

ED01 Education cess rates 01.04.2004 31.12.9999

ED02 Education cess rates 01.04.2004 31.12.9999

After change:

ED01 Education cess rates 01.04.2004 31.03.2011

ED02 Education cess rates 01.04.2011 31.12.9999

In this case, If I create ED03 for Education cess rates with validate 01.04.2011 31.12.9999 and dilimit:

ED01 Education cess rates 01.04.2004 31.03.2011

ED02 Education cess rates 01.04.2004 31.03.2011

Please let me know whether this way is ok or not? please advise

[Former Member]

You can take reference of SAP Note 1568264 For it.

ED1 and ES1 you don't need to change as these 2 carry the percentage of education cess and higher education cess which has bnot been changed right from the time it has been released by Indian income tax deptt.

so these 2 entry will be as follows in table V_T7INT1 -

ED01 Education cess rates 01.04.2004 31.12.9999

ES01 Secondary & higher education cess rates 01.04.2007 31.12.9999

Every entry other than these 2 for ED1 and ES1 does n't make any sense. Note that there are no changes in Education cess and Secondary & higher education cess in budget 2011 hence no these will remain same.

other new entry for V_T7INT1 -

- Slab code 'SL16' delimited till 31.03.2011

- Slab code 'SL17' delimited till 31.03.2011

- Slab code 'SL18' delimited till 31.03.2011

-

---

Slab Code

Slab Type

FROM

TO

-

---

SL16

Income tax rates for men

01.04.2010

31.03.2011

-

---

SL17

Income tax rates for women

01.04.2010

31.03.2011

-

---

SL18

Income tax rates for Senior Citi

01.04.2010

31.03.2011

-

---

-

- New Slab code 'SL23' created from 01.04.2011

- New Slab code 'SL24' created from 01.04.2011

- New Slab code 'SL25' created from 01.04.2011

- New Slab code 'SL26' created from 01.04.2011

-

---

Slab Code

Slab Type

FROM

TO

-

---

SL23

Income tax rates for men

01.04.2011

31.12.9999

-

---

SL24

Income tax rates for women

01.04.2011

31.12.9999

-

---

SL25

Income tax rates for Senior Citi

01.04.2011

31.12.9999

-

---

SL26	Income tax rates for very senior	01.04.2011	31.12.9999

V_T7INT3 table will bein continuation in the next reply as i am not able to format in 1.

Edited by: praveen.hcm on May 16, 2011 3:46 PM

Edited by: praveen.hcm on May 16, 2011 3:46 PM

[Former Member]

In continuation of last reply -

Entries in V_T7INT3 -

New entries for V_T7INT3 -

Tax slabs maintained for slab codes SL23, SL24, SL25 and SL26

-

---

Slab code

TaxBkt

Slab range

Return value

Currency

-

---

SL23

01

180.000,00

0,00

INR

-

---

SL23

02

500.000,00

10,00

INR

-

---

SL23

03

800.000,00

20,00

INR

-

---

SL23

04

99.999.999,00

30,00

INR

-

---

SL24

01

190.000,00

0,00

INR

-

---

SL24

02

500.000,00

10,00

INR

-

---

SL24

03

800.000,00

20,00

INR

-

---

SL24

04

99.999.999,00

30,00

INR

-

---

SL25

01

250.000,00

0,00

INR

-

---

SL25

02

500.000,00

10,00

INR

-

---

SL25

03

800.000,00

20,00

INR

-

---

SL25

04

99.999.999,00

30,00

INR

-

---

SL26

01

500.000,00

0,00

INR

-

---

SL26

02

800.000,00

20,00

INR

-

---

SL26

03

99.999.999,00

30,00

INR

-

---

You can take reference of SAP Note 1568264 For it.

Edited by: praveen.hcm on May 16, 2011 3:49 PM

[Former Member]

Dear Praveen,

How are you today?

My customer said that they don't have problem with income tax slabs, only taxable income is calculating wrong.. ex.. gross salary, professional tax, etc.... So please let me know whether gross salary and professional tax are affected or not if income tax error.

By the way, Before Apr-2011, gross salary and professional tax was calculated correctly. However, after changing income tax slabs as per customer's requirement, gross salary and professional tax was calculated incorrectly. it was doubled, may be it carried forward from 2010-2012. Could you please let me know root cause?

We need to run payroll on 20.05.2011. Any helps would be appreciated!

[Former Member]

Well income tax error may hit on gross total income but professional tax will be computed inside professional tax calculation itself, hence atleast that will not be impacted.

Can you explain in details what exactly is the error/ issue in your scenarios. What is the customer expection and where it deviates etc etc

[Former Member]

Dear Praveen,

Follow the SAP document:

Gross Salary Wage Type (/416) = Ann Reg Income Wage Type (/410)

+ Ann Irr Income Wage Type (/411)

+ Annual Perk Wage Type (/413)

+ Prev Gross salary Wage Type (/4V1)

+ Val of perk u/s 17(2) Wage Type (/4VJ)

+ Profts wrt sal u/s 17(3) Wage Type (/4VK)

- Exm.under pro.to sec17(2) Wage Type (/414).

Ann Reg Income Wage Type (/410) =Value of Mon Reg Income Wage Type (/124) in the Cumulative Results Table from last month

+Value of Mon Reg Income Wage Type (/124) for the current period.

+Value of Mon Reg Income Wage Type (/124) for the current period, multiplied by the value of Projection Factor Wage Type (/401)

In short formula:

/410 = /124 in CRT last month + /124 in RT this month + ( /124 in RT this monthx/401 in RT this month)

/124 in CRT this month = /124 in CRT last month + /124 in RT this month

/124 in CRT could be accumulated by yearly, so that It can be used by yearly, and canu2019t be carried forward to next year.

2009 - 2010

Period 10 - 2009

Period 11 u2013 2009

CRT table:

/124 Mon Reg Income: 125840

Period 12-2009 (01/03/2010 u2013 31/03/2010)

RT table:

/124 Mon Reg Income: 12575

/401 Projection Factor: 0

/410 = 125840 + 12575 + 12575*0 = 138415

CRT table:

/124 Mon Reg Income: 138415

Period 01-2010 (01/04/2010 u2013 30/04/2010)

RT table:

/124 Mon Reg Income: 12575

/401 Projection Factor: 11

/410 = 0 + 12575 + 12575*11 = 150900

CRT table:

/124 Mon Reg Income: 12575

( = 0 + 12575)

2010 - 2011

Period 10-2010 (01/01/2011 u2013 31/01/2011)

RT table:

/124 Mon reg Income: 12575

/401 Projection Factor: 2

CRT table:

/124 Mon reg Income: 125141

Period 11-2010 (01/02/2011 u2013 28/02/2011)

RT table:

/124 Mon Reg Income: 12575

/401 Projection Factor: 1

410 = 125141 + 12575 + 12575*1 = 150291

CRT table:

/124 Mon reg Income: 137716

(=/124 CRT last month + /124 RT this month)

Period 12-2010 (01/03/2011 u2013 31/03/2011)

RT table:

/124 Mon Reg Income: 14661

/401 Projection Factor: 0

/410 = 137716 + 14661 + 14661*0 = 152377

CRT table:

/124 Mon Reg Income: 152377

Period 01-2011 (01/04/2011 u2013 30/04/2011)

RT table:

/124 Mon Reg Income: 14661

/401 Projection Factor: 11

/410 = 152377 + 14661 + 14661*11 = 328309 (Wrong Rs!)

It must be

/410 = 0 + 14661 + 14661*11 = 175932 (Correct Rs)

CRT table:

/124 Mon Reg Income: 167038 (Wrong Rs)

( = 152377 + 14661)

It must be

/124 Mon Reg Income: 14661 (Correct Rs)

( = 0 + 14661)

The error comes from Period 01-2011, there for the Value of /124 in CRT from last month must be 0 (End of last year & start new year), but the system still gets the value of CRT from last year.

[Former Member]

CRT processing controlled by table V_T54C3. Check there the entries should be as Y for wage type /124.

Also check V_T54C0, here for India entries should be as following -

Start of fiscal year, day - 01

Start of fiscal year, month - 04

Might be the problem occurs because of HRSP implementation.

[Former Member]

Dear Praveen,

Thanks for your answer,

I have just checked views: V_T54C0, V_T54C3 and configuration is OK, similar to your suggestion.

Please advise next action. We need to run payroll tomorrow.

Thanks and Best regards

DucTV.

[Former Member]

check the processing class 30 for /124, it should be 2.

Also if you are in ECC 6.04 then, check the tcode PC00_M40_SWCH and if switch 40AY is activated, deactivate it.

[Former Member]

Dear Praveen

,

Thanks for your answer,

I have checked processing class 30 for WT /124 and It's 2.

I tried to run tcode PC00_M40_SWCH but it does not exist in current system.

Please advise for next action. Thank very much

Thanks and best regards,

DucTV

[Former Member]

well i feel everything is in place now and not sure about the problem.... can you check out the processing of

ADDCU P30 Continue cumulation wage types CRT

in the Final processing subschema INE0. MAy be you will get some clue.

Also check the following tables -

V_T54C2, time unit should be 6 against Y.

VV_T54C4_01_AL0_07, here time unit 6 should be mapped to the cumulation type Y.

Edited by: praveen.hcm on May 17, 2011 5:00 PM

[Former Member]

Dear Praveen,

Thank a lot for your answer,

Schema INE0 is standard. we don't modify it. Before, income tax, professional tax and gross salary is ok. After Mar-2011, the system is showing error.

We have also checked V_T54C2, VV_T54C4_01_AL0_07 and the result is similar to your suggestion.

Recently, we only extend payroll period till year 2016 Because payroll only permit to run till 3-2011 before.

[Former Member]

Well everything looks fine so not sure wht is going wrong. But ya as you said you have extended the payroll period till 2016 recently check if the year you have changed during the genaration of payroll periods. That may cause the issue as well if you have n't defined the April as first period in 2011.

Problem is because of recent 1 change that is for sure as it was wrking till last year perfectly. Hence try to cross check all your recent changes.

Edited by: praveen.hcm on May 17, 2011 5:23 PM

[Former Member]

Dear Praveen,

Thanks for your support,

Please let me know what concrete error will occur when we generate payroll period. Because, we only extend payroll period without changing anything in Indian payroll.

Please advise for next action. Thank you very much.

Best regards,

DucTV.

[Former Member]

see when you are trying to generate the payroll periods that time 1st period should be April that is 4th period. Now if have made it 1st period as 1st period that is jan or something then it will create the issue. Can you also let me know what is the value of wage type /401 in the RT table.

[Former Member]

Dear Praveen,

How are you today?

Thanks for your response,

Value of WT (/401) is coming correct.

However, after checking again cumulation of India I saw that There are some confusion about below configuration 3, 4 :

1. Calendar Type

Cululation type Name Description Time Unit Unit of time text

C 1 Monthly

Y Annually YTD 6 Annually

2. Cumulation Periods:

Cal type Month Cumulation year No. of Month

C 10 2000 12

Y Annually 1 1994 12

3. Code wage types for cumulation (Form annual values) /124

Processing class

PC Name of Processing Class P Name of Spec. of Proc. Class

30 Cumulation update 2 AMT of wage type to be cumulated in current year

Cumulations

CN Cumulation WT C

No check

4. Cululations of WT

WT Cumulation Type Name calendar type Start date End date Number cumulation Amount cumulation

/124 Y Annually 01.01.1998 31.12.9999 X

Please let me know Whether the configuration above is OK or not?

Thanks and Best regards

DucTV

[Former Member]

Dear Praveen,

Below is payroll periods in year 2011:

Period parameter Payroll year Payroll period Prev. payroll year Prev. payroll period start date end date

67 2010 10 2010 9 01.01.2011 31.01.2011

67 2010 11 2010 10 01.02.2011 28.02.2011

67 2010 12 2010 11 01.03.2011 31.03.2011

67 2011 1 2010 12 01.04.2011 30.04.2011

67 2011 2 2011 1 01.05.2011 31.05.2011

67 2011 3 2011 2 01.06.2011 30.06.2011

67 2011 4 2011 3 01.07.2011 31.07.2011

67 2011 5 2011 4 01.08.2011 31.08.2011

67 2011 6 2011 5 01.09.2011 30.09.2011

67 2011 7 2011 6 01.10.2011 31.10.2011

67 2011 8 2011 7 01.11.2011 30.11.2011

67 2011 9 2011 8 01.12.2011 31.12.2011

67 2011 10 2011 9 01.01.2012 31.01.2012

67 2011 11 2011 10 01.02.2012 28.02.2012

67 2011 12 2011 11 01.03.2012 31.03.2012

67 2012 1 2011 12 01.04.2012 30.04.2012

Please advise about payroll periods generation above and please suggest the solution on this.

Any helps would be appreciated!

DucTV1.

[Former Member]

This is fine as per my understanding. No idea, probably you should raise the OSS as may be it is happening because of some code issue or standard delivery

[Former Member]

Hi,

Is it resolved. ??

Check for the table entry in V_T54C1 and maintain the interval field as 1 for the cumulation type Y and the period parameter you are using.

Entries should be maintain as -

Payroll Year Period Cum. year Cum. interval

2011 01 2011 01

2011 02 2011 01

2011 03 2011 01

2011 04 2011 01

2011 05 2011 01

2011 06 2011 01

2011 07 2011 01

2011 08 2011 01

2011 09 2011 01

2011 10 2011 01

2011 11 2011 01

2011 12 2011 01

Edited by: Praveen Tiwari on May 20, 2011 4:06 PM

[Former Member]

David,

Is it resolved now.