Skip to Content
0

Unpaid Absence deduction based on annual days

Nov 13, 2016 at 05:52 PM

107

avatar image

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 left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Venkatesh Yadav Nov 14, 2016 at 07:21 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Rabi R Nov 14, 2016 at 08:56 AM
0

Hi,

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

Thanks

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Thank Rabi. I am using XPP1 pcr, Am I wrong?

0

Hi,

Are you working with Indian payroll or International? Because if you are working with Indian payroll then you should use INP1 and for international payroll XPP1 can be use.

Thanks

0

Yes exactly I am using international and want to customize XPP1 as per my client requirement.

0

Hi,

As per your logic you can build PCR like below -

ZRULE1

RTE=TKSOLL

RTE-TKAU**

RTE*KGENAU

RTE/TKDIVI

ADDWT XXXX(Wagetype1)

AMT= XXXX (Monthly gross wage type)

AMT/TKSOLL

ADDWT XXXX(Wagetype2)

ZRULE2

RTE= XXXX(Wagetype1)

NUM= XXXX(Wagetype2)

MULTI RNN

ADDWT *

Thanks

0

Thanks Rabi. But this doesn't fulfill the requirement. As per this PCR Salary would change on the monthly bases.

for example: January 31- 2 days absence= 29

Feb 29-2 days absence=27

This formula does not carry every months with equal days.

Please check.

0

Hi,

Would you try that PCR in your system?

I've designed those as per the logic given by you.In ZPCR1, RTE=TKSOLL contain number of calendar days in a month (31,30,28 whatever it is). RTE-TKAU** deduct number of unpaid absence days from calendar days. finally number of unpaid absence days will store in wage type1 & 1day salary will store in wagetype2.

In ZPCR2, multiplication of RTE & AMT and value will store in wagetype3.

Test case :In the month of April, Employee's monthly gross is 10000 and have 2 days of unpaid leave. As per the ZPCR1 2days will store in Wagetype1 RTE field and 1 day salary 10000/30= 333.33 will store in wagetype2 AMT field.

In ZPCR2, 333.33 * 2 = 666.67 will store in Wagetype3

*Note if you using this you have to stop standard factoring method to get exact result.

Thanks

0
Show more comments
Zia-Ur Rehman Nov 14, 2016 at 10:18 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Rémi Corriveau Nov 14, 2016 at 05:47 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Mr. Remi.

Yes all the WTs which are included in IT0008.

I am trying this, will be back.

0