Skip to Content

Business Scenario:

Deducting one day salary from employees for various contributions like national calamities, PM’s Fund, etc.  The contribution should be deducted after taking consent of the employee.

Detailed configuration steps with screen shots are given below for One day Salary deduction as per Business Requirement.

1. Create custom wage type for the base amount.

Create a Wage Type to generate the base amount for the one day salary deduction

2. Create custom processing class 99.

SPRO Payroll Payroll India Basic Settings Environment of wage type maintenance Processing classes & Evaluation classes Maintain Processing classes & their specifications.

3. Create a PCR to cumulate the base amount to the custom Wage type

4. Create a deduction wage type to make the deduction.

5. Maintain the table V_512w_d for the custom Wage type

 

 

6. Create a PCR to generate the exact amount for One Day Salary.

TKDIVI→ Number of calendar days in the period.

OPIND→ Multiplies amount, number & rate (or) all by -1,If the wage type is a deduction wage type.

7. Create a schema and insert the PCR

Copy the standard sub schema INAP as ZNAP & deactivate INAP. We need to insert the PCR at the right place in the Schema. In the present scenario we are processing one day salary deduction through Infotype 14. So insert the PCR’s in ZNAP subschema.

8. Restriction for Retro

As it is generated from the cumulation of Wage types, when there is a change in the base Wage types which is used to cumulate base amount also will change. So, it is need to restrict from retro. To do that create a New PCR and insert in a new Sub-schema, and insert after the PCR to generate the Base amount.

The PCR is

Below is the Sub-schema

Insert the sub-schema in INAP schema as shown below,

Select the Processing class 99 & specification class 1 for all the wage types which are to be cumulated for one day salary deduction in the table V_512W_D.

John Cheriyan

To report this post you need to login first.

32 Comments

You must be Logged on to comment or reply to a post.

  1. Leela Mohan

    Hi,

    Could you let me know which sub schema you have copied for ZNOB, At the same time please can you maintain all steps like upto getting payslip result.

    because I’ve followed your steps I’ve followed your steps not getting accurate result.

    Ur’s

    Mohan

    (0) 
    1. John Cheriyan Post author

      Hi,

      ZNOB is the new sub schema which i made for the calculation.

      you have to maintain the PC for WTs which you want to add for the calculation. Put the WT for the one day basic in the Payslip through the PE51 as deduction, it will reflect in the payslip.

      Regards,

      John

      (0) 
  2. Priya Gupta

    Hi john,

    I tried your scenario but the wage type is not appearing on payslip nor in RT Table.

    After giving 1 day in 4100 Deduction wagetype. The 9GRS amount should add to total that is what the scenario states but is not displaying please help me out.

    Confused about processing classes Above screen is that correct

    I didnt try Retro Once I get an output i will try that too 😐

    (0) 
  3. Priya Gupta

    This is what it shows after following above screens . it should deduct one day basic pay but it is adding Basic Pay Total and One Day Basic 250 to Net Pay This is wrong. Could you please correct where it went wrong in above screens 

    1.JPG

    2.JPG

    (0) 
      1. Priya Gupta

        No Iam not running payroll twice

        According to scenario There should be deduction of one day basic pay So Basic Pay is 7500 that is 7500/30 days = 250 that is one day basic pay but it is not deducting 250 it is adding to net pay along with professional tax and retro 7500 whenever there is a change in basic pay there is retro so it is adding 7500+7500+250+ Professional Tax that shouldn’t be the case.

        The net pay should come 7500-250= 7250 that should store in 9GRS wagetype and should show on payslip

        I need to try retro that is from 8th step

        Iam bit confused on 8th step where i need to insert ZNOB???

        (0) 
    1. Sankarsan Dey

      Hi Priya,

      I think you want to display in payslips earning head.

      Do the following way,

      Insert the 9GRS wage type in Windows & Cummulation Id’s in PE51. It will come .

      Regards,

      Sankarsan

      (0) 
      1. Priya Gupta

        According to scenario There should be deduction of one day basic pay So Basic Pay is 7500 that is 7500/30 days = 250 that is one day basic pay but it is not deducting 250 it is adding to net pay along with professional tax and retro 7500 whenever there is a change in basic pay there is retro so it is adding 7500+7500+250+ Professional Tax that shouldn’t be the case.

        The net pay should come 7500-250= 7250 that should store in 9GRS wagetype and should show on payslip

        I need to try retro that is from 8th step

        Iam bit confused on 8th step where i need to insert ZNOB???

        (0) 
  4. Priya Gupta

    After I found above thread Interesting and started to work on scenario The same I was trying to implement for my client but it is not working according to scenario There should be deduction of one day of basic pay for employees in case of any natural calamities After doing till 7th step this is what i found below screens. The Basic Pay maintained was 7500 but it is adding 7500 +7500+250+200

    One Day Salary Deduction-Indian payroll (With Restriction for the Retro)

    7500 is Basic Pay

    7500 is retro as there is change in basic pay

    250 that is basic pay divided by 30 days which is correct

    200 is professional It exceeding more than 10,000 Net pay so there is professional tax All figures are coming correct but All components are adding to net pay below is the screenshot According to scenario it should deduct only 250 from 7500 that is 7250. The net pay should show as 7250 Instead of 7250 it is showing 14,550 (7500 +7500+250+200)

    Below is the rule I have written according to post

    1.JPG

    2.JPG

    Placed in schema

    2.JPG

    Executed Payslip The wrong values are stored

    1.JPG

    2.JPG

    Following 8th step to stop retro There is syntax error

    1.JPG

    So removed 9GRS Just kept AMT=0 to avoid error

    Placed schema

    Since it is retro so i added in INNR Schema

    2.JPG

    Executed payslip Still there is no change

    2.JPG

    (0) 
    1. bapu mohapatra

      Hi John,

      I tried this thread. But this is not working for HRA. (INVAL-B). While i am takeing all component of IT8.

      100A-Basic-15000

      100B-HRA-7500

      100C-400

      100D-801

      100E-1250

      Total = 24951

      24951/31=804.87

      but Its comeing-563

      Its not takeing HRA amount.

      ScreenHunter_02 Jul. 08 17.24.gif

      Thanks & Regards

      Bapu.

      (0) 
      1. John Cheriyan Post author

        Hi,

        It is calculating for the all component, if you add the both 9ODD values you will get the total amount. to avoid this you have to put “ELMI*” after “AMT=9ODD” in PCR ZON1. I think this will solve the problem.

        John

        (0) 
            1. bapu mohapatra

              Hi Priya,

              As per John’s thred. I was doing the config. but HRA allowance Inval B. it was not calculating. As per Santosh’s thred i modify the PCR ZON1. Now its working fine.

              (0) 
    2. Priya Gupta

      The problem is resolved now.


      In 9GRS wage type we have to remove tick mark in CC1. The scenario is The basic pay amount should store in  9GRS wagtype it will mutiply by 30 days to get one day basic pay. The 9GRS Wagetype amount is added to Total Take Home Pay that is wrong. To restrict that amount we have to remove tick mark in CC1 and it is resolved.


      Thank you Iam closing the thread 


      (0) 
  5. Priya Gupta

    Hi john

    Why it is required 8th step please let me know 😕 😕 😕 😕 😕 😕 😕 😕 😕 😕 😕 😕

    We just need to remove tick mark in CC1 to restrict the amount of 9GRS ❗ 1.JPG

    (0) 
    1. John Cheriyan Post author

      Hi Priya,

      If the base amount is changed, e.g. Basic,  with effect from the previous month, the one day deduction  will also change. As per the concept it should not change. To restrict that we need the step 8

      John cheriyan

      (0) 
      1. Priya Gupta

        Hi John,

        Could you please be more clear why there will be change in basic pay.  According to scenario we created 4100 wagetype that is deduction wagetype one day basic will store in that wagetype and will show in deduction column. The basic pay remains same. If you see above screen I have maintained 7500 in 8 infotype the same reflecting on payslip

        The basic pay wont change anywhere…

        please help me to understand

        (0) 
          1. Priya Gupta

            Hi Bhagyasree,

            I just tried for Basic Pay It is working fine not all components . i didnt understand the 8th step . Could you please clarify

            I will try for other components.

            Thank you

            (0) 
            1. bapu mohapatra

              Hii Priya. I have tried for all component. Its working fine after modify by Santosh. I have attached the screen shot. and the 8th step also i am not understanding.

              Thanks

              (0) 
        1. John Cheriyan Post author

          Hi

          You have deducted one day basic for a month. in the next month the company decided to increase the salary of the employees with effect from previous month. so it will increase the salary in IT0008, including the basic pay.

          In the next month payroll, the system will go for a retro. so it will recalculate all the WT amounts in the previous month including the one day basic. the system will calculate the one day basic for the difference amount of basic.  the concept is to deduct the one day basic only for one month. so it is not necessary to recalculate the amount for one day basic.

          to avoid the retro for the one day basic the step 8 is required. in this step the schema ZNOB will check whether it is a retro or not. if it is retro it will trigger the PCR ZON2 which will make the 9grs to  zero.  so the one day basic will not calculate.

          John Cheriyan

          (0) 

Leave a Reply