cancel
Showing results for 
Search instead for 
Did you mean: 

Deduction due to Overconsumed Leave

Former Member
0 Kudos

Hi Gurus,

An employee has resigned and overconsumed his leave by 5.5 days. We need to deduct the 5.5days from his last pay.

The current practice is that the annual leave in IT2001 was converted to unpaid leave. However it was noted that the formula for calculating unpaid leave and overconsumed leave is different.

Formula for NPL deduction:

July - 23 work days, Aug - 21 work days

(3.5/23 * 2400) + (2/21 * 2400) = 593.79

Formula for overconsumed leave deduction:

(12 * 2400)/260 * 5.5 = 609.23

There is a difference of $15.44

It was also noted that changing the annual leave to NPL was not right. Can anyone please advise how can payroll deduct the amount of $609.23?

Angela

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

We are not using time evaluation. Is there any other way? For example to calculate the overconsumed leave in the payroll schema?

Former Member
0 Kudos

How do you capture it? Is negative deduction activated for your absence quota? E.g. If the employee has quota = 5 days, he can still apply for leave of 6 days?

Former Member
0 Kudos

If employee has quota of 5 days, he cannot apply for 6 days of leave.

However if his quota for 1 year is 5 days and he consume all 5 days in Jan and then quit in Feb, system needs to calculate the overconsumed leave (eg: 4.5 days) and clawback the amount from the staff. My issue now is how can system calculate the overconsumed leave of 4.5days for payroll to pick up and deduct the amount accordingly.

Current practice is that, the 4.5 days was calculated manually in excel, convert the 4.5days from annual leave to NPL in IT2001, then payroll schema picks up in R015 for deduction. But such manipulation of data does not seem correct.

Former Member
0 Kudos

If you can arrive at some logic for the system to calculate overconsumed leave, then you can create a Z function to calculate the no. of days.

You can call this Z function in the payroll program prior to the place where R015 (or its copy with the new formula for dedn due to Overconsumed leave). This will then be an input to R015 or its copy for the calculation of the deduction.

Former Member
0 Kudos

Thank you Tania. Ok I will try this out. I think this might just work.

So there isn't any standard SAP way of calculating this but we got to customize it on our end. Your responses are so helpful. Really appreciate it.

Former Member
0 Kudos

You're welcome Angela!

Former Member
0 Kudos

Along with the example, could you explain the formulae with variables, as we may misunderstand what 2400,260 etc. mean.

Once we understand what the expected calculation is, we can arrive at a solution.

Former Member
0 Kudos

Hi Tania,

2400 is the employee's salary. 260 (52 * 5) is the total working days for the year.

Former Member
0 Kudos

Okay,and for the NPL deduction, are you doing it through a PCR?

Former Member
0 Kudos

Hi Tania,

Yes, it is going through the PCR R015.

Does this mean that standard SAP does not calculate overconsumed leave but we need to customize it in the payroll schema?

Former Member
0 Kudos

I am not familiar with Payroll Singapore, but it seems logical that you could:

1) Create a new absence type Overconsumed leave

2) Customize v_t510s to link this absence type to a new wage type as per your requirement

3) Copy R015 to a new PCR, say, Z015 and make the necessary changes as per your formula for Overconsumed leave. These changes would be processed only if the wage type is that derived from step 2, if not the existing logic as per PCR Z015 would apply.

Former Member
0 Kudos

Hi Tania

Thank you very much.

It seems like a possible solution. I have 1 question. Is it possible for the system to auto-compute the overconsumed leave? Instead of the HR administrator calculating it themselves and creating the overconsumed leave manually in IT2001?

Angela

Former Member
0 Kudos

Hi experts,

I am also following this.  i know the logic of r015 valuation of time wagetypes  but how the overconsumed leaves will be calculated by using this pcr.  I am also very much interested to know about it.

Regards,

Aruna.

Former Member
0 Kudos

It should be feasible if you are using time evaluation. If you are, let me know which schema you use in PT60.