Leave conditions

[Former Member]

Hi Time Experts

We are implementing time for our client. Casual Leave condition is like this ,

• Quota – 12 days/yr on 1^st of Jan for both Executives and workers.
• For both workers and Executives CL quota of 12 days will be credited on Jan 1^st
• For first year ex. Employee joins in June then from June one day should get accumulated on each month till end of the year and from next year onwards 12 days should get on 1st Jan itself. Casual Leave not availed in any calendar year is credited to UCL (Unavailed Casual Leave).
• If Executive joined on june 9^th 2014 then till dec 2014 one day on each month will get credited, then in 2015 on jan 1^st 12 days will get credited  & on 2016 on jan 1^st 12 days will get credited and on 2017 jan 2014’s remaining quota should be lapsed for Executive.

UCL – Unavailed Casual Leave

After each year remaining CL leaves will get accumulated to UCL.

Note: In 2^nd yr  if any executive applies for leave, first years remaining quota should be deducted first. If employee applies for a leave in 3^rd yr, 1^st yrs quota should be deducted first then 2^nd yrs and then the current yrs quota. In 4^th yr, 1^st yrs remaining quota will get lapsed.

From fourth year onwards first year’s remaining leaves will get lapsed. Similarly 2nd yrs remaining leaves get lapsed in 5th year and so on. This 3 yrs concept is applicable only for executives but not for workmen. For workmen remaining leaves will get accumulated till his retirement.

Can any one provide the better solution for this.

Regards

Sai

[vianshu · Accepted solution]

Hi Sai,

You need to create one quota for casual leave(01) and 3 quotas for UCL (02,03,04).

For casual leave, your quota start will be accrual date and end date will be calendar year.

For UCL quotas, your quota start will be calendar year start and end date will 24 months from calendar year start in Table V_T559L.

In the deduction rule, you will maintain the four quotas as 02,03,04,01 with the valid from date as the highest priority followed by quota types as 2nd priority. Below is a schematic representation.

You will query if on 31-Dec-14, if quota 02 is present or not. If it is not present, you pass the carry forward values in 02. On 31-Dec-14, you will query 02 and you will find that quota 02 exists, so you will query quota 03 and it won't exist and hence, you will pass carry forward values to 03. Similarly on 31-Dec-16, you will query 02, 03 and they will exist and hence, you will pass value to 04 for carry forward casual leave. On 31-Dec-17, you will again query 02 and you will find that it doesn't exist and hence, you will pass the values to 02. Use HRS=FE02C, HRS?0 to check if quota was generated or not. If not generated, pass the value to 02. If generated, check for HRS=FE03C, and the same for HRS=FE04C.

Use the below documents to understand on quota generation and balance carry forward.

Configure your 01 quota with the base entitlement as 12 for calendar year. Ensure that your accrual as well as transfer is daily in Table V_T559L. Also, ensure that your rounding rule is 01 in accrual entitlement tab in V_T559L.

Write a PCR which adds HRS=1 day for each day of time evaluation run and pass it to a time type ZABC. Ensure that the time type is a yearly time type. Refer below document.

Write the below PCR for quota generation:

Z123

*

****

       VARSTCURMO

                            01

                             VARSTREDAY

                                                 01

                                                    HRS=1

                                                    ADDDBZ123   where Z123 will be called in accrual entitlement tab in V_T559L (refer my document)

                                                 **

                                                   GCY Z123A

                            **

                               GCY Z123A

A

  ****

       HRS=YDAA01                  where 01 is date of hire defined in IT0041

       HRS-MZABC

                *

                 VARSTREDAY

                                  01

                                     GCY Z123B

                                  **

                >

B

****

       VARSTCURMO

                           01

                           **

                               HRS=1

                               HRS/12

                               ADDDBZ123Z

Place this PCR before CUMBT function in your time schema.

Now, coming to your logic for balance quota transfer, the PCR for calculating the balance on 31-Dec will be like below:

Z234

       *

        ****

             VARSTCURMO

                                 **

                                 12

                                    VARSTREDAY

                                                       **

                                                       31

                                                          HRS=FR01C

                                                           ADDDBZ456 where Z456 is a daily time type

This balance now needs to be generate quota for your carry forward quota.

Use the below daily time types as base entitlement for them

ZC02              -           02

ZC03              -           03

ZC04              -           04

Then write this PCR Z345 as shown below. Place this PCR after QUOTA function and also place another CUMBT function after this PCR.

Z345

*

   ****

           VARSTCURMO

                                **

                                01

                                VARSTREDAY

                                                    **

                                                    01

                                                       HRS=FE02C

                                                       HRS?0

                                                                 *

                                                                  HRS=LZ456

                                                                  ADDDBZC02

                                                                 >

                                                                 GCY Z345A

A

  ****

       HRS=FE03C

       HRS?0

                 *

                  HRS=LZ456

                  ADDDBZC03

                 >

                   HRS=FE04C

                   HRS?0

                    *

                    HRS=LZ456

                    ADDDBZC04

                    >

Place this PCR before CUMBT & QUOTA function.

Call all PCRs using ACTIO.

I hope this will resolve your query. If you get stuck, I would request you to spend some effort in sending screenshots of all your configuration for my analysis.

Thanks and regards,

Vivek Barnwal

[Former Member · Accepted solution]

Hi Vivek

Thanks a lot for sending the reply.

I will check and will reply you.

Once again thanks a lot for your help as usual.

Regards

Sai

[Former Member · Accepted solution]

Hi Vivek,

There is a slight modification in the requirement as below-

Casual Leave

Quota – 12 days/yr on 1^st of Jan for both Officers and Workmen

Casual Leave shall be earned by an employee during the first calendar year of his service on a pro rata basis at the rate of one day for each completed month.

Employee joins in June then from June one day should get accumulated on each month till end of the year and from next year on wards 12 days should get on 1st Jan itself. Casual Leave not availed in any calendar year is credited to UCL.

1. If employee hired on June 9^th 2014 say both workmen and officer then till Dec 2014 one day on last day of each month will get credited then in 2015 on Jan 1^st 12 days will get credited & on 2016 on Jan 1^st 12 days will get credited and on 2017 Jan 2014’s remaining quota should be lapsed for officer.

UCL – Unavailed Casual Leave

After each year remaining CL leaves will get accumulated to UCL

Note: In 2^nd yr (employee hired on 9th June 2014 so 2015 will be the 2nd year)employee applies for leave, first years remaining quota should be deducted first. If employee applies for a leave in 3^rd yr, 1^st yrs quota should be deducted first then 2^nd yrs and then the current yrs quota. In 4^th yr, 1^st yrs remaining quota will get lapsed. – For officers only

From fourth year onwards first year’s remaining leaves will get lapsed. Similarly 2nd yrs remaining leaves get lapsed in 5th year and so on. This 3 yrs concept is applicable only for officers but not for workmen. For workmen remaining leaves will get accumulated till his retirement.

Regards,

Arun

[vianshu · Accepted solution]

Hi Arun,

You have pasted the entire text mentioning that here is a slight change in requirement. Can you please advise what is the slight change in requirement?

Thanks and regards,

Vivek Barnwal

[Former Member · Accepted solution]

Hi Vivek

Sorry for the late reply.

Casual leave is generating 12 days quota on 1st of January for those who are present from the beginning of the year, but for mid joinees it is not working. For Mid joinees at the end of the month it should generate 1 day quota each month.

As mentioned by you, I have inserted the following PCR.

ZCL1 time type is kept in generation rule in accrual entitlement tab.

Actully I did't understood the usage of MZABC time type. I have just created yearly time type ZABC and kept in this pcr. Should I have to do anything before this.Can you plz elaborate Part A and Part B in this PCR.

Also I have run time evaluation for the employee who has joined 01.02.2014.

on 01.02.2014 quota is not generated as shown below. Also I have given the PCR while processing.

Plz help.

Regards

Sai

[Former Member · Accepted solution]

Hi Vivek

great answer. Very well explained. Quota carry forward and Validity conditions are working fine.

Your inputs are very valuable for us. We are very lucky to have you in the SCN forum.

• 12 days of Quota is generating in the beginning of the year on 01.jan.2014 for those who are present from the beginning of the year. But on 02.Jan.2014 it is adding 1 day quota. again on 03.jan.2014 it is adding 1 day quota. Like this on 31.jan.2014 it is 42 days of quota.

      From Feb it is 42 days only. In DEC 31 quota is 42 days. only in the JAN month it is creating               12+30=42 days of quota. From Feb no generation.

• .If employee joins on 01.Feb.2014,  11 days of quota is generated . But for Mid joinee  1 day quota shoud get generated on each month.

I have inserted the PCR given by you.  plz help.

Regards

Sai

[Former Member · Accepted solution]

Hi Vivek

Can you plz reply.

Regards

Sai

[Former Member · Accepted solution]

Hi

can any one have solution for this.

Regards

sai

[Former Member]

Sai

With no doubts you have to use time evaluation for updating the quotas

In 2nd yr  if any executive applies for leave, first years remaining quota should be deducted first.

For the above you can set the priority for quota deduction

This 3 yrs concept is applicable only for executives but not forworkmen

This you can quer employee group in custom pcr

Hope this clarifies

BR

Anil

[Former Member]

Hi Anil

Thxs for the reply.

• If employee joins mid year then only every month 1 day quota should accrue, if employee is present for the whole year then in the beginning of the year  Jan1  Quota has to be generated.

• UCL – Unavailed Casual Leave

After each year remaining CL leaves will get accumulated to UCL.

Note: In 2nd yr  if any executive applies for leave, first years remaining quota should be deducted first. If employee applies for a leave in 3rd yr, 1st yrs quota should be deducted first then 2nd yrs and then the current yrs quota. In 4th yr, 1st yrs remaining quota will get lapsed.

From fourth year onwards first year’s remaining leaves will get lapsed. Similarly 2nd yrs remaining leaves get lapsed in 5th year and so on.

To give the priority we need to have different quota's for every year for the above requirement. Also after 3 yrs if any balance is there in  CL it has to be lapsed. this check should happen for every year's quota.

How we can do this.

regards

sai

[Former Member]

Hi Sai

If employee joins mid year then only every month 1 day quota should accrue, if employee is present for the whole year then in the beginning of the year  Jan1  Quota has to be generated.

Custom PCR should be place for mid year joinee and employee presence in the whole year PCR should be customized with Attendance check condition

In 2nd yr  if any executive applies for leave, first years remaining quota should be deducted first. If employee applies for a leave in 3rd yr, 1st yrs quota should be deducted first then 2nd yrs and then the current yrs quota. In 4th yr, 1st yrs remaining quota will get lapsed.

From fourth year onwards first year’s remaining leaves will get lapsed. Similarly 2nd yrs remaining leaves get lapsed in 5th year and so on.

You can control the same via deduction priority ( first which quota to be consumed) the year applicability to be controlled by custom pcr

after 3 yrs if any balance is there in  CL it has to be lapsed

The said req can be controlled via pcr itself ( eliminate the quota after 3 years)

Anyways Sai..excellent req..you will have  a good play around with the same and please keep us posted on the updates

Thanks and Regards

Anil

[Former Member]

Hi 

Can any one provide the exact solution who has faced the similar issue.

Regards

sai

[leelamohan_kavali]

Dear Sai,

I think so below link may help to you

Ur's Mohan

[Former Member]

Hi Mohan

Thank you for giving this link which is really useful.

But here for my requirement if employee joins in the middle of the year every month 1 day quota has to be generated or else  12 days of quota has to be given in the beginning of the year.

And  validity of leaves as mentioned above also should be considered.

Hi Vivek Barnwal

Can you help me.

Regards

sai

[leelamohan_kavali]

Dear Sai,

As per your client requirement SAP can't be supported because quota will be generated at the time of every last day of month for more clarification you can find it in time log tree.

Just explain to the client if he won't listen raise to SAP support team and get the answer from them then show to your client where he can understand.

Ur's Mohan

[Former Member]

Thanks Mohan,

I will try to explain client.

Is there any solution for the below requirement.

• If Executive joined on june 9th 2014 then till dec 2014 one day on each month will get credited, then in 2015 on jan 1st 12 days will get credited  & on 2016 on jan 1st 12 days will get credited and on 2017 jan 2014’s remaining quota should be lapsed for Executive.

regards

sai

[leelamohan_kavali]

Dear Sai,

This scenario we will go with Custom PCR but quota can't be generate 1st day of every month.

Ur's Mohan

[Former Member]

Hi Mohan

Can you please help me to write the custom PCR  for lapsing the quota after 3 years as given below.

• If Executive joined on june 9th 2014 then till dec 2014 one day on each month will get credited, then in 2015 on jan 1st 12 days will get credited  & on 2016 on jan 1st 12 days will get credited and on 2017 jan 2014’s remaining quota should be lapsed for Executive.

Regards

Sai

[leelamohan_kavali]

Dear Sai,

Have you tried there is one table validity period....? because I've written such PCR's...!

Ur's Mohan

[leelamohan_kavali]

i think below link is it may help to you

Absence Quota for mid joinees - ERP Human Capital Management - SCN Wiki

[Former Member]

Hi Mohan

Thank you for sharing the good links.

Can you plz share your PCR's  which is written by you to control the validity.

Regards

Sai

[Former Member]

Hi Mohan

Can you plz share the PCR's written by you to control the validity.

Regards

sai