Skip to Content
avatar image
Former Member

Unpaid Absence deduction based on annual days

Dear Experts,

Here is my client's requirement. How can we incorporate this?

Note: PCRs deducted is based on calendar days

1) Gross Salary X 12 months / 365 days = 1 Day salary

2) 1 Day Salary X No. of unpaid leaves = Total amount of unpaid leaves to be deducted.

3) Gross salary - Total amount of unpaid leaves = Net salary.

Regards,

Zia

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 14, 2016 at 07:21 AM

    We can write a PCR but, can you explain in detail what is the reason behind this formula Gross salary*12/365 = 1 Day, There are no chances in change in Pay i.e change in pay in the middle of the month due to promotion, increment etc .

    Regards

    Venkatesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      to avoid this type of error I have added WT to this table (V_T554C)with basic pay split check. Am I right?

  • avatar image
    Former Member
    Nov 14, 2016 at 08:56 AM

    Hi,

    You should follow Std. PCR INP1. It can fulfill your requirement.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thank you so much Rabi.

      Your given solution is good but unfortunately not completely fulfilling our requirement.

      I think you are little confuse with my requirement.

      see my client wants every month's unpaid absence must be equally deducted as per the below example:

      Suppose, my salary is 100,000 this amount is first multiplied by 12 (no. of months in a year) then divided by 365 ( no. of days in a year). In returns, whether an employee takes unpaid absent in January or February will get same deducted amount for an unpaid leave.

      Formula: (100,000 X 12) / 365 = 3,288 a day deduction.

      Now 3,288 will be deducted from Gross salary

      100,000 - 3,288 = (96,712 Net Salary after one day absent deduction).

      Thanks again

      Regards,

      Zia

  • avatar image
    Former Member
    Nov 14, 2016 at 10:18 AM

    Dear Yadev,

    This requirement is my client specific. They want salary to be equally distributed in every months. Need your help I am new in PCR.

    standard formula is working fine but they want this specific formula.

    Regards,

    Zia

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      What we have to do Is Create a temporary variable which can be used to get Daily Salary.

      PCR1

      XXXX(Gross Wage type)

      AMT*12(Create a constant & Place it in the V_T511K XXXXX replace 12 with KXXXXX)

      AMT/365(Create a constant YYYYY replace 365 with KYYYYY)

      ADDWT &DYSL

      FILLF ANR

      ADDWT *

      PCR2 should be like this

      RTE=TKAU**

      RTE*& DYSL

      ADDWT &ABSM

      ADDWT *

      PCR3

      XXXX(Gross wage type)

      AMT=1

      RTE= &ABSM

      MULTI RAA

      ADDWT&ABS1

      AMT= XXXX

      AMT- &ABS1

      ADDWT *

      Regards

      Venkatesh

  • Nov 14, 2016 at 05:47 PM

    1 - What do you consider as "Gross Salary"? The sum of WTs in IT0008 or must other Amounts be included?

    Through a Cumulator WT (in the /190 to /199 range), or through an Information WT and a pcr, establish the "Gross Salary" per month;

    2 - Create a "Daily Rate" WT using a pcr to divide the Amount of Gross Salary by the Number of 365 days in order to establish the Rate

    (in the Rate field of the WT).

    3 - In Payroll, set-up all Unpaid Absences to be treated as if they were Paid Absences, but generating a distinct "Unpaid Absence WT",

    and create a pcr to multiply the Number of Unpaid Absences by the Rate of the Daily Rate WT.

    Add comment
    10|10000 characters needed characters exceeded