Skip to Content
0

Unpaid Absence deduction based on annual days

Nov 13, 2016 at 05:52 PM

111

avatar image
Former Member

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

avatar image
Former Member 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
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?

0
avatar image
Former Member 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
Former Member

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

0
Former Member
Former Member

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
Former Member
Former Member

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

0
Former Member
Former Member

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
Former Member
Former Member

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
Former Member
Former Member

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
avatar image
Former Member 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
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

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
Former Member

Thanks Mr. Remi.

Yes all the WTs which are included in IT0008.

I am trying this, will be back.

0