Skip to Content

PF Calculation for mid joinee employee comes wrong from sap

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Jul 25, 2013 at 01:10 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2013 at 11:42 AM

    Hi,

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

    John

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2013 at 11:54 AM

    Hi,

    Send me the screen shot of IT 0587.

    Regards,

    vijay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2013 at 12:38 PM

    Hi,

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

    Regards,

    Vijay

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Babu Kolkata

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2013 at 02:52 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2013 at 06:46 AM

    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.


    EPF.JPG (16.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2013 at 07:00 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.