PF Calculation for mid joinee employee comes wrong from sap

[Former Member]

Dear Guru's,

The PF amt for mid joinee emp. comes wrong in sap. The scenario is as such

Employee joins in 15.04. 2013. His basic is Rs. 10100.After payroll run his /111 is

/111 EPF Basis  01                                                   5,387.00. The PF should be 646.

But system considers the value

/3FA PF basis fo0101                                                 3,467.00

/3FJ VPF basis f0101                                                 3,467.00

/3FB PF Basis fo0101                                                3,467.00

/3FL PF Basis fo0101                                                 3,467.00

/3FC Pension Bas0101                                               3,467.00

/3F1 Ee PF contr0101                                                   416.00

/3F3 Er PF contr0101                                                   127.00

/3F4 Er Pension 0101                                                   289.00

/3F5 Ee Mon PF c                                                       416.00

Plz guide me....

Thanks,

Santosh

[Sanky · Accepted solution]

Dear Santosh,

You can do the query of PF basis wage type that is /111 in your PCR.

Hope so it will work.

Regards,

sankarsan

[Former Member · Accepted solution]

Dear Sankarsan,

Thanks for the support. The issue resolved.

Thanks,

Santosh

[former_member645325 · Accepted solution]

Hey Santosh,

This is Ragini Nikam, I am facing the same issue for PF as were are having, can you tell me what PCR's you wrote.

Please help me.

Regards

Ragini Nikam

SAP HR Consultant

[Former Member · Accepted solution]

Hi,

I am facing same problem here. Could you please send the logic to my mail id

viju.14kate@gmail.com.

Regards,

Vijay

[Sanky · Accepted solution]

Hi Vijay,

You raisethis as a new issue with details about this.

We are here to help you out.

Regards,

Sankarsan

[Former Member · Accepted solution]

Hi,

Sorry, I did not get you..

Regards,

Vijay

[Former Member · Accepted solution]

Hi Santhosh,

Can you please share me the inputs,  how you resolved the issue.

Regards,

Prasad

[Sanky · Accepted solution]

Hi Prasad,

It's already a closed thread. Open your own new thread and would be helpful to others.

Regards,

Sankarsan

[Former Member]

Hi Santosh,

Your Prorated basic is 5387.

/3fa is calculated based on prorated of 6500 for 16 days of which the amount is 3467.So system will compare and consider least among them. 12% of 3467 is 416 which is correct.

If you want to calculate /3f1 on 5387 change IT0587 as PF basis.

regards,

Narendra

[Former Member]

Dear santhosh,

         Maintain "PF Basic in 0587 info type for both employee and employer, then it will calculate based upon basic salary prorated amount.

         Then Write one custom PCR to reduce the amounts to 780(/3f1) and 238.55(/3f3), if prorated amount is greater than 6500 and put this PCR after INEPF function in your schema.

Find out the attachment for PCR which is for only '/3F1', Add remaining wage types in PCR according to your requirement.  

This suggestion might helpful for you.

Regards,

Ramu velaga.   

[Former Member]

Dear Santosh,

It is selected "Eligible pay or PF Basis whichever is less" in IT0587: It means PF CAP amount is 6500 (Eligible pay-Since employee joined on 15.04.2013 the PF Base gets prorated i.e 6500/30 (No.of.calendar days) =216.67*16 (No.of.work days) =3467  ) and PF Basis (In your case the PF basis for 16 Days Basic wage type payment i.e from 15.04.2013 to 30.04.2012) is 5387, now as per condition "Eligible pay or PF Basis whichever is less" the amount is 3467, so 3467*12/100= 416,

If you choose another radio button in IT0587 "PF Basis" then system will take your PF Basis amount i.e 5387*12/100=646 will come but remember it will not check any PF CAP amount as it straight away takes PF basis amount (Basic+DA) and take employee contribution 12% on that.

Best Regards,

Devendra Reddy D.

[Former Member]

Dear Dev,

If the amt is less than 6500 then its ok but if the prorated basic is greater than 6500 then pf will exceed 780. Client don't want that.Pf amt shouldn't exceed 780 in all scenario.

I wrote a pcr for the above scenario but unfortunately I'm not getting the pf details like /3f1, /3f3 and /3f4 in RT.

Plz guide me where did I make the mistake....

In v_t511k, I define ZPFAA as 780.

Plz guide...

Thanks,

Santosh

[Former Member]

Hi,

    To calculate the PF amount on prorated basic pay you have to choose the radio button as PF Basis in IT0587.

[Former Member]

Dear Reddy,

This option I tested already but it won't work. As per the client req. the /3f1 shouldn't exceed 780 that means the pf basis will be 6500 for all cases. But for mid joinees the pf basis will be prorated basic that may be less than 6500 or may be more than 6500. If the prorated basic is more than 6500 then /3f1 exceeds 780 which client don't want like this.

Dear guru's please help me out...

Thanks,

Santosh

[Former Member]

Hi,

The PF is calculating on the basis of /3FA. Check is der any LWP in those period?

Regards,

Vijay

[Former Member]

Hi

He joins 15th Apr. 2013. Mid joinee. For all the emplyoee the pf basis is 6500 so for every month the pf should be 780.

[sikindar_a]

6500 will gets prorated right , so in that case how can it be 780

[Former Member]

Dear Sikandar,

You are right. But my system's pf basis is Rs. 6500 and it works fine for all employees. But client want to calculate the pf basis on the basis of actual basic

for ex: Emp basic is 10000 and he join's 15th of the month, so now pf is calculating on (6500/30)*15=3250= pf basis and pf is 12 % of 3250= 390 but client want to ve the pf as (10000/30)*15=5000 will be pf basis and pf is 600.

Is it possible to map in system...

plz guide...

Thanks,

Santosh

[Former Member]

Hi,

can you please check the cumulation class 11 for each custom WT? i think the base amount for the calculation is getting from some other WT not from BASIC.

John

[Former Member]

Dear John,

If this is the case then how it's ok for rest employees. For mid joiners the issue is there for pf only and i provide the reason also but client want the pf should be calculated on the basis of prorated basic.

Thanks,

Santosh

[Former Member]

Dear Guru's,

Any updates please....

Thanks,

Santosh

[Former Member]

Hi,

System is calculating correctly, but we need to analyze properly okay.

No of days is 16 and No of days in a month is 30.

split month factor = No of days/ No of days in a month.

This split month factor will get multiply with 6500(PF basis).

In your case = 6500 * 16/30 = 34666.666 ~=3467(/3FA).

PF amount is calculating on this basis.

Now since your basic pay is 5387 greater than prorated pf eligible pay which is 3467 .

It considers the lesser amount for PF Calculation.

If you change basis for contribution in IT0587 to PF basis your PF will calculate on basic pay.

Regards,

Vijay Kumar

[Former Member]

Hi,

Send me the screen shot of IT 0587.

Regards,

vijay

[Former Member]

Hi,

How much the Basic amount is coming? and check the processing class 10. for basic.

John

[Former Member]

Basic is 5,387.00. It's ok. only concern is Pf amts.

[Former Member]

The pf basis got calculated as (6500/30(Calendar days for Apr))*16(Working days or presents days)=3467. but it should consider the prorated basic amt i.e. 5387

[Former Member]