New PF logic Configuration as per System?

As per govt rule currently we have built in different logics in our System

Normal New pf  logic

• a) If Earned Basic is greater than 15000 then pf will deduct on Earned Basic flat 12% 

• b) If Earned Basic is less than 15000 then will add gross payheads earned value, If the Addition of Earned Basic & Earned value of Gross payheads is greater than 15000  then the system will restrict the amount to 15000 and will capture as 15000 PF base.

• c) If Earned basic is less than 15000 then will add gross payheads earned value If the Addition of Earned Basic & Earned value of Gross payheads is less than 15000 then the system will Deduct on Sum of Earned Basic & Earned value of Gross payheads.

To Set the Above logic would need the configuration to be done in system 

• 1) Make “PFAPP “ true on Basic+gross payhead through Compensation & Benefits Screen / Payhead Master Template.  
• 2) Make “Exempt App” true on  Basic payhead 
• 3) Map “HRA BasicDA Exemption” through Payhead Master Template  

Note :- Basic payhead Exempt App-True and Exempt Section =“HRA BasicDA Exemption” are mandatory

• Ø Additional requirement as per few client requirements we need Basic + another payhead to check limit 15000 on first step

For which you need make Exempt App-True and map Exempt Section =“HRA BasicDA Exemption” so that 15000 limit is checked (Earning basic+Another payhead)

Example :-

Basic Rate 20000

• 1. Days worked -30/31

Basic > 15000  Then Basic*12%

20000>15000  Then  20000*20/100 =2400

• 2. Days worked =25

Basic <15000  then  adding  gross payhead Basic + Da +spl + training 

Basic < 15000  and Basic + Da +spl + training > 15000 then restrict 15000 else 

Basic + Da +spl + training

13333 <15000 Then 13333 +2000+1000+6000

13000 < 15000  and 22333 > 15000 Then 15000  PF = 1800

• 3. Days worked =10

6666<15000 Then 6666+1000+500+3000

13000 < 15000  and 11666 > 15000 Then 15000 Else 11666  PF = 1339

 Normal logic But check basic actual value

• l If Actual Basic is greater than 15000 then pf will deduct on Earned Basic flat 12% 
• l If Actual Basic is less than 15000 then will add Earned Gross Payhead on which Basic+Gross is greater than 15000 then system will restrict 15000 and update only  15000 as pf base.
• l If  Actual basic is less than 15000 then will add Earned Gross Payhead on which Basic+Gross is less than 15000 then system will deduct on basic+gross as PF Base.
• l If Actual basic above 15000 but due to LOP Earned basic is less than 15000 then Pf will deduct on Earned Basic *12%

For Above logic configuration required in the system 

First make “PFAPP “ true on Basic+gross payhead from compensation & benefits screen / payhead master template.

Make “Exempt App” true on  Basic payhead and map “HRA BasicDA Exemption” this is to be done from payhead master template.

Note :- Basic payhead  Exempt App-True and Exempt Section =“HRA BasicDA Exemption” are mandatory

One more additional requirement some client need Basic + Another payhead to check limit 15000 on first step

For which please make Exempt App-True and map Exempt Section =“HRA BasicDA Exemption” so that will check 15000 limit on Earned basic+Another payheads

Note: You need raise query to activate pf base with actual basic configuration 

Example :-

Basic Rate 20000

• 4. Days worked -30/31

Act Basic > 15000  Then Basic*12%

20000>15000  Then  20000*20/100 =2400

• 5. Days worked =30/31 

Act Basic <15000  then  adding  gross payhead Basic + Da +spl + training 

Act Basic < 15000  and Basic + Da +spl + training > 15000 then restrict 15000 else 

Basic + Da +spl + training

13333 > 15000 Then 13333 +2000+1000+6000

13000 < 15000  and 22333 > 15000 Then 15000  PF = 1800

• 6. Days worked =10

20000 > 15000 Then 6666 *12/100 PF=799

• l PF logic with pf calculation prorate basis

In this logic for employee need to be set pfbaselimit as 15000 for prorate 

Rest all configuration logic will not change.

• l If Actual Basic is greater than 15000 then pf is deducted on Earned Basic flat 12% 
• l If Actual basic is less than 15000 then will add Gross Earned Value,If Basic+Gross is greater than 15000 then system will restricted 15000 and update only 15000 pf base.
• l If  Actual basic is less than 15000 then will add Gross Earned Value,If Basic+Gross is less than 15000 then system will deduct on basic+gross as PF base
• l If Actual basic above 15000 but due to lop earning basic is less than 15000 then pf will deduct on Earning basic *12%

Note: You need raise query to activate PFcalculationprorate Configuration

For Above logic configuration required in system 

First make “PFAPP “ true on Basic+gross payhead from compensation & benefits screen / payhead master template

Make “Exempt App” true on  Basic payhead then  map “HRA BasicDA Exemption” this exemption from payhead master template  

Days worked :-30/31

Basic =25000

Pfbaselimit =15000

Pf ded =1800

Days worked =20

Act Basic =25000

Pfbaselimit=15000

Earning Basic :-16666

PF ded=1800/30*20 =1200