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

10|10000 characters needed characters exceeded

• 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

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?

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

Hi,

Thanks

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

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

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

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)

FILLF ANR

PCR2 should be like this

RTE=TKAU**

RTE*& DYSL

PCR3

XXXX(Gross wage type)

AMT=1

RTE= &ABSM

MULTI RAA

AMT= XXXX

AMT- &ABS1

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.