/Wagetypes not generating for Tax Calculation for ...

Hi All,

The employee has a Monthly Gross salary of-38,350 ,Annual-460200.

I have done the Income tax confi & has maintained the table.

Payroll-India-Basic Settings>>PS/PSA Tax Grp,Assign Tax Grp, Maintained 40ECC as well.

Tax Liability on Reimbursements, Allowances and Perks>>Defined Tax Codes, Assigned Tax code Limits to wage types.

But when i run payroll , in the RT none of the Wage Types are getting generated for Tax.

annual tax -

/446 Tax payable

/447 Sec and Higher Educ Cess

/448 Surcharge payable

/449 Education Cess

/450 Tax payable and surcharge

For monthly tax -

/4ME Monthly Education cess

/4MH Monthly Higher Edu cess

/4MI Monthly Taxable Income

/4MS Monthly Surcharge

/4MT Monthly Tax payable

Is there any issue with the PRCL & CML in V_512W_D ???

Please guide on the same.!!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

Hi,

Is there any issue with the PRCL & CML in V_512W_D ???

Could you paste here, Processing class specification for info type 8 wage types.

Regards,

MVR

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Is /416 and /426 are generating in your RT .

Which month you are running the payroll and what is the date of hiring of the employee

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sujith,

Thanks for the update. yes the following wagetypes are getting generated.

/416 Gross Salar 460,200.00

/418 Balance 460,200.00

/422 Empmnt tax 2,400.00

/424 Aggrg Deduc 2,400.00

/426 Incm under 457,800.00

/430 Gross Tot I 457,800.00

/432 Agg of Chap 36,000.00

/434 Total Incom 421,800.00

The employee is hired on 0104.2011 & i am running the payroll for the same month.

Wheree can i get the details of INTAX,is it under ADDCU-Payroll LOG.

Please guide.

Is the employee's age is above 80

No..the employees DOB is 1983.

Have u check the gender of the employee in It-2 & tax slab for income tax calculation.

Does this is a problem for a single employee.

Check INTAX function is processing for that employee, check INTAX in payroll log ( use CTRL+F for find ), Check the processing node of INTAX.

Hi,

I think as snita said its happening due to Gender.

There is no option to maintain the gender infor mation in IT0002. i checked in MP0002-scereen2000- even there is no Gender Option available.

I tried maintaining the Feature P0002-MOLGA-40_Variable key 14, to have the gender out put..but still system is taking the Old screen,

How to ge about the same.should i make an entr of GESC-1 In Standard screen-2000, Feature P0002

Hi ,

I have maintained the employees gender-MALE.

Still the following Wagetypes are not getting generated.

Annual tax -

/446 Tax payable

/447 Sec and Higher Educ Cess

/448 Surcharge payable

/449 Education Cess

/450 Tax payable and surcharge

For monthly tax -

/4ME Monthly Education cess

/4MH Monthly Higher Edu cess

/4MI Monthly Taxable Income

/4MS Monthly Surcharge

/4MT Monthly Tax payable

I checked in INTAX- In Payroll Log, there also the wage types are not generated.What could be the possible reason behind this????

Please guide!!!

Hi all,

Requesting you to guide me on the same.

Thanks.

Hi,

Could you provide us INTAX processing in payroll log.

Experts already requested for Processing of INTAX in log, Still your not provided and expecting suggestions.

Request you provide input details in payroll log like below?

IT- internal table

Processing

IT-out put table after processing.

I am sorry, may be i di not realise that, here are the details.

/101 Total gross 38,350.00
/115 COA/CLA Bas01 38,350.00
/117 Superannuat 25,000.00
/121 Nom. ExGrat 100000.00 25,000.00
/124 Mon Reg Inc01 38,350.00
/129 Voluntary R01 25,000.00
/138 Form 217 2( 38,350.00
/3F1 Ee PF contr0101 3,000.00
/3F3 Er PF contr0101 2,459.00
/3F4 Er Pension 0101 541.00
/3F5 Ee Mon PF c 3,000.00
/3F6 Ee Ann PF c 36,000.00
/3F7 EDLI contri0101 3,250,000.00
/3F8 EDLI adm ch0101 65,000.00
/3F9 PF adm chrg0101 27,500,000.00
/3FA PF basis fo0101 25,000.00
/3FB PF Basis fo0101 25,000.00
/3FC Pension Bas0101 6,500.00
/3FJ VPF basis f0101 25,000.00
/3FL PF Basis fo0101 6,500.00
/3I1 Deduction u 36,000.00
/3I2 Gross amoun 36,000.00
/3P1 Prof Tax - 01130106 I 200.00
/3P2 Professiona01130106 38,350.00
/3P3 Prof Tax - 200.00
/3Q1 HRA calcula 02 120,000.00
/3Q1 HRA calcula 03 30,000.00
/3R2 Non-metro H 10,000.00
/3R4 Non-metro H 25,000.00
/401 Projection 11.00
/422 Empmnt tax 2,400.00

3 /111 EPF Basis 01 25,000.00

3 /112 ESI Basis 01 38,350.00

3 /113 ESI Basis N01 100000.00 37,550.00

3 /114 HRA Basis 01 25,000.00

3 /116 Gratuity Ba01 25,000.00

3 /118 PTax Basis 01 38,350.00

3 /119 PTax Basis 01 100000.00 38,350.00

3 /120 Nom. ExGrat 100000.00 25,000.00

3 /128 Leave Encas01 25,000.00

3 /134 Annual Non-01 1,250.00

3 /136 1DSD Basis 01 25,000.00

3 /137 1DSD Basis 01 25,000.00

3 /139 VPF Basis 01 25,000.00

3 /140 LWF Basis 01 25,500.00

3 1001 Child EduAl01 800.00

3 1002 Uniform All01 500.00

3 1003 Medical amo01 1,250.00

3 1004 Conveyance 01 800.00

3 1005 House Rent 01 10,000.00

******Projection of Annual Regular Income on Actual Basis*****

Income tax rates

Long gain normal income tax rate

20.00

Long gain special income tax rate

10.00

Short gain income tax rate

15.00

Other income tax rate

30.00

average rate of tax

0.00

***Total income = normal income + long gain normal income + long gain special income + Short gain income + other income

Normal income Long gain norm.income Long gain sp. income Short gain income Other income Total income

421,800.00 0.00 0.00 0.00 0.00 421,800.00

***Total income tax = normal income tax+ long gain normal income tax+ long gain special income tax+ Short gain IT+ other income tax

Normal income tax Long gain normal tax Long gain special tax Short gain Income tax Other income tax Total income tax

0.00 0.00 0.00 0.00 0.00 0.00

***If Income under head salaries (/426) is less than the first Income slab limit (not-taxable) then the remaining amount of this

limit is adjusted against the relevant components of Income from Other Sources in the descending order of their tax rates.

If no PAN available for the Ee and average rate of tax is less than the rate maintained in T511K, tax calculations will happen

based on rate maintained in T511K. Also, no cess will be calculated for such Ee.

/101 Total gross 38,350.00
/115 COA/CLA Bas01 38,350.00
/117 Superannuat 25,000.00
/121 Nom. ExGrat 100000.00 25,000.00
/124 Mon Reg Inc01 38,350.00
/129 Voluntary R01 25,000.00
/138 Form 217 2( 38,350.00
/3F1 Ee PF contr0101 3,000.00
/3F3 Er PF contr0101 2,459.00
/3F4 Er Pension 0101 541.00
/3F5 Ee Mon PF c 3,000.00
/3F6 Ee Ann PF c 36,000.00
/3F7 EDLI contri0101 3,250,000.00
/3F8 EDLI adm ch0101 65,000.00
/3F9 PF adm chrg0101 27,500,000.00
/3FA PF basis fo0101 25,000.00
/3FB PF Basis fo0101 25,000.00
/3FC Pension Bas0101 6,500.00
/3FJ VPF basis f0101 25,000.00
/3FL PF Basis fo0101 6,500.00
/3I1 Deduction u 36,000.00
/3I2 Gross amoun 36,000.00
/3R4 Non-metro H 25,000.00
/401 Projection 11.00
/422 Empmnt tax 2,400.00

3 /111 EPF Basis 01 25,000.00

3 /112 ESI Basis 01 38,350.00

3 /113 ESI Basis N01 100000.00 37,550.00

3 /114 HRA Basis 01 25,000.00

3 /116 Gratuity Ba01 25,000.00

3 /118 PTax Basis 01 38,350.00

3 /119 PTax Basis 01 100000.00 38,350.00

3 /120 Nom. ExGrat 100000.00 25,000.00

3 /128 Leave Encas01 25,000.00

3 /134 Annual Non-01 1,250.00

3 /136 1DSD Basis 01 25,000.00

3 /137 1DSD Basis 01 25,000.00

3 /139 VPF Basis 01 25,000.00

3 /140 LWF Basis 01 25,500.00

3 1001 Child EduAl01 800.00

3 1002 Uniform All01 500.00

3 1003 Medical amo01 1,250.00

3 1004 Conveyance 01 800.00

3 1005 House Rent 01 10,000.00

/410 Ann Reg Inc 460,200.00
/416 Gross Salar 460,200.00
/418 Balance 460,200.00
/424 Aggrg Deduc 2,400.00
/426 Incm under 457,800.00
/430 Gross Tot I 457,800.00
/432 Agg of Chap 36,000.00
/434 Total Incom 421,800.00
/4MI Monthly Tax 35,150.00
/403 Marginal ta
/4T1 Income Tax 0109 421,800.00
/3P1 Prof Tax - 01130106 I 200.00
/3P2 Professiona01130106 38,350.00
/3P3 Prof Tax - 200.00
/3Q1 HRA calcula 02 120,000.00
/3Q1 HRA calcula 03 30,000.00
/3R2 Non-metro H 10,000.00
/3R4 Non-metro H 25,000.00
/401 Projection 11.00
/422 Empmnt tax 2,400.00

3 /111 EPF Basis 01 25,000.00

3 /112 ESI Basis 01 38,350.00

3 /113 ESI Basis N01 100000.00 37,550.00

3 /114 HRA Basis 01 25,000.00

3 /116 Gratuity Ba01 25,000.00

3 /118 PTax Basis 01 38,350.00

3 /119 PTax Basis 01 100000.00 38,350.00

3 /120 Nom. ExGrat 100000.00 25,000.00

3 /128 Leave Encas01 25,000.00

3 /134 Annual Non-01 1,250.00

3 /136 1DSD Basis 01 25,000.00

3 /137 1DSD Basis 01 25,000.00

3 /139 VPF Basis 01 25,000.00

3 /140 LWF Basis 01 25,500.00

3 1001 Child EduAl01 800.00

3 1002 Uniform All01 500.00

3 1003 Medical amo01 1,250.00

3 1004 Conveyance 01 800.00

3 1005 House Rent 01 10,000.00

/410 Ann Reg Inc 460,200.00
/416 Gross Salar 460,200.00
/418 Balance 460,200.00
/424 Aggrg Deduc 2,400.00
/426 Incm under 457,800.00
/430 Gross Tot I 457,800.00
/432 Agg of Chap 36,000.00
/434 Total Incom 421,800.00
/4MI Monthly Tax 35,150.00
/403 Marginal ta
/4T1 Income Tax 0109 421,800.00

Here in this post /4MI is generating right.

/4MI Monthly Tax 35,150.00

Hi,

What you maintain value for PSG for Tax in table"V_7IN0P_TAX"..? or you have taken you are own grouping other than SAP grouping?

Hi ERP,

Thanks for the reaponse. Yes /4MI is created but the amount is not coming Under Amount Row , Its olnty available Under

AMT/UNT field.

Secondly i had taken the grouping as 9 in place of 1 & 2.

What is the significance of 1 & 2.

Please guide.

All programs associated with the TAX are written with grouping of 1/2 for India Specific settings, It is advantageous to go with standard groupings

Raghu

Hi,

I have made the changes into 1 in place of 9 what should be the ideal 1 or 2, do i need to assign the Payee Key to Tax GRP-1.

Please guide.

Even now i have changed it to 1 & run the payroll in test mode.

/101 Total gross 38,350.00
/115 COA/CLA Bas01 38,350.00
/117 Superannuat 25,000.00
/121 Nom. ExGrat 100000.00 25,000.00
/124 Mon Reg Inc01 38,350.00
/129 Voluntary R01 25,000.00
/138 Form 217 2( 38,350.00
/3F1 Ee PF contr0101 3,000.00
/3F3 Er PF contr0101 2,459.00
/3F4 Er Pension 0101 541.00
/3F5 Ee Mon PF c 3,000.00
/3F6 Ee Ann PF c 36,000.00
/3F7 EDLI contri0101 3,250,000.00
/3F8 EDLI adm ch0101 65,000.00
/3F9 PF adm chrg0101 27,500,000.00
/3FA PF basis fo0101 25,000.00
/3FB PF Basis fo0101 25,000.00
/3FC Pension Bas0101 6,500.00
/3FJ VPF basis f0101 25,000.00
/3FL PF Basis fo0101 6,500.00
/3I1 Deduction u 36,000.00
/3I2 Gross amoun 36,000.00
/3P1 Prof Tax - 01130106 I 200.00
/3P2 Professiona01130106 38,350.00
/3P3 Prof Tax - 200.00
/3Q1 HRA calcula 02 120,000.00
/3Q1 HRA calcula 03 30,000.00
/3R2 Non-metro H 10,000.00

/3R4 Non-metro H 25,000.00

/401 Projection 11.00

/422 Empmnt tax 2,400.00

/111 EPF Basis 01 25,000.00

/112 ESI Basis 01 38,350.00

/113 ESI Basis N01 100000.00 37,550.00

/114 HRA Basis 01 25,000.00

/116 Gratuity Ba01 25,000.00

/118 PTax Basis 01 38,350.00

/119 PTax Basis 01 100000.00 38,350.00

/120 Nom. ExGrat 100000.00 25,000.00

/128 Leave Encas01 25,000.00

/134 Annual Non-01 1,250.00

/136 1DSD Basis 01 25,000.00

/137 1DSD Basis 01 25,000.00

/139 VPF Basis 01 25,000.00

/140 LWF Basis 01 25,500.00

1001 Child EduAl01 800.00

1002 Uniform All01 500.00

1003 Medical amo01 1,250.00

1004 Conveyance 01 800.00

1005 House Rent 01 10,000.00

Hi,

Try with "1" instead of "9".. then run payroll process.

Even now i have changed it to 1 & run the payroll in test mode. but /446,/447,/448,/449 are not getting generated.

/101 Total gross 38,350.00
/115 COA/CLA Bas01 38,350.00
/117 Superannuat 25,000.00
/121 Nom. ExGrat 100000.00 25,000.00
/124 Mon Reg Inc01 38,350.00
/129 Voluntary R01 25,000.00
/138 Form 217 2( 38,350.00
/3F1 Ee PF contr0101 3,000.00
/3F3 Er PF contr0101 2,459.00
/3F4 Er Pension 0101 541.00
/3F5 Ee Mon PF c 3,000.00
/3F6 Ee Ann PF c 36,000.00
/3F7 EDLI contri0101 3,250,000.00
/3F8 EDLI adm ch0101 65,000.00
/3F9 PF adm chrg0101 27,500,000.00
/3FA PF basis fo0101 25,000.00
/3FB PF Basis fo0101 25,000.00
/3FC Pension Bas0101 6,500.00
/3FJ VPF basis f0101 25,000.00
/3FL PF Basis fo0101 6,500.00
/3I1 Deduction u 36,000.00
/3I2 Gross amoun 36,000.00
/3P1 Prof Tax - 01130106 I 200.00
/3P2 Professiona01130106 38,350.00
/3P3 Prof Tax - 200.00
/3Q1 HRA calcula 02 120,000.00
/3Q1 HRA calcula 03 30,000.00
/3R2 Non-metro H 10,000.00

/3R4 Non-metro H 25,000.00

/401 Projection 11.00

/422 Empmnt tax 2,400.00

/111 EPF Basis 01 25,000.00

/112 ESI Basis 01 38,350.00

/113 ESI Basis N01 100000.00 37,550.00

/114 HRA Basis 01 25,000.00

/116 Gratuity Ba01 25,000.00

/118 PTax Basis 01 38,350.00

/119 PTax Basis 01 100000.00 38,350.00

/120 Nom. ExGrat 100000.00 25,000.00

/128 Leave Encas01 25,000.00

/134 Annual Non-01 1,250.00

/136 1DSD Basis 01 25,000.00

/137 1DSD Basis 01 25,000.00

/139 VPF Basis 01 25,000.00

/140 LWF Basis 01 25,500.00

1001 Child EduAl01 800.00

1002 Uniform All01 500.00

1003 Medical amo01 1,250.00

1004 Conveyance 01 800.00

1005 House Rent 01 10,000.00

Hi,

Projection is coming "11" months means you are running April month salary of which year?

Have you selected Cummulation classes 24 for It0008 wage types or not, if not select the 24 cummulation class then try the payroll.

Even In come tax not calculated need to check configuration and the following also.

Have you maintain IT0582, IT0585, IT0586?

And employee joining date?

Is this first payroll of employee? what is the period and year your processing payroll.

Employee having old pay results? if yes check Old pay results also.

Are you getting only one employee or all the employees? are you getting same issue for one PSA or All the PSAs?

Payroll is done for the month of April 2011.Employee hired in 01.04.2011.

Cummulation CL-24 is already marked for all the wagetypes but yes have not maintained , IT0585, IT0586 yet.

Confi looks fine T7INT1 & T3 is automaintained duto application of notes.

After guidance have redone the grouping into 1.

what else.

At least it should give me the Tax Payable.

Hi All,

After maintaing the Tax GRP on -1 Also the following wagetypes are not getting generated.

/446 Tax payable

/447 Sec and Higher Educ Cess

/448 Surcharge payable

/449 Education Cess

/450 Tax payable and surcharge

Please guide ...i have checked the costumizing as well , things seems to be in place, have maintained his 0582-data, 0185 is also maintained, gender is also maintained.!!!!

Since /434 is coming so i feel wage types customization are correct else it could not be generated. I would suggest you to check the tax slabs maintained, mainly validations as per the gender slabs.. most probably there is something missing

Hi Praveen,

The slabs are maintained as follows. i had to apply the note to get the slabs as these were missing, Details from T7INT1

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 citizens 01.04.2011 31.12.9999

T7INT3

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.0030.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.0030.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.0030.00 INR

Regarding table V_512W_D.

All the basic pay wagetype PCL-70-Cummulation & Storage into RT is kept as Blank.

Could it be a possible reason for this as i believe PCL-70 deals with Taxes.

Please guide.

What you pasted here is from your system?

If yes then these table configurations are correct

Hi Sujith,

You are right , the posted tables are from the system But is it happening due to applicaion of the NOTE.Now even i tried maintaing PCL-70 with 0 & 1 .

But no improvement...the payroll result is same.

which schema you are using standard IN00 or any customised one

Hi Sujith,

There is something want to share 1st, before Applying the note i created entry for men in T7INT1, although system created a work bench request but the entry for MEN was not reflecting in T7INT1, i am not able to locate it, now the Note is applied & the entries are present.but i want to delet the manually created entry.

SL23 Income tax rates for men 01.04.2011 31.12.9999

I believe system is not able to read the slab properly as there are 2 slabs with same charectristics.i want to delete the manully created entry, where can i locate it as it is not present in T7INT1.

In that case probably you can delete the entries and try to re-create for Men.

Also i would suggest that ask your abaper to debug the payroll function INTAX and see if the Slabs have been licked up correctly.

is there any other table to locate the mannualy created enty.

Praveen if i delet the entry that means i have to delete the entry which was update through the NOTE, i dont think if i create it mannualy its going to work fine as i had tried to check the taxes when i created the entries mannualy no taxes were deducted.

After the note was updated the entries are reflecting.

There have been some inconsistency as created table entry manually or via Note doesn't make any difference. Also note that SAP Note don't create table entry, have you implemented HR support package for the same? If yes, then you should not delete the entries..

I would still suggest you to check with some abaper if possible to debug the program and see if this is the only problem.

Hi Praveen,

SAP note 1568264 Budget Changes 2011.

This is the note applied to get the Tax Slab.

The support pack level is 44.

Now when i chenge the gender of the employee to Female- All the Tax wage types are getting generated.

Please guide.

Please check one more time the table V_T7INT3 and V_T7INT1 is there any duplicated please try to delete as what suggested by Praveen

As you said for female it is working so its very clear now that table entries are the problem most likly..Let me know the ERP release you are currently...for which you have mentioned the support package. IF you are in ECC 6.04 then this support package should have overwrite the manual value and this problem should not come. But if you are talking about ECC 6.0 then let me know...

I am currently in 6.04.

Hi,

Under which slab employee salary processing you can find in payroll log. Function "INTAX" will provide you tax rates in Payroll log. Based on log change your configuration settings or input data (master data) for employee.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count