on 05-03-2016 6:12 AM
Hi Friends
I have following requirement
Total number of working days 30 out of that 22 days needs to pay Total salary and Remaining 8 days needs to pay Basic-> 50%, FDA->50% and VDA 50% and remaining wages need to calculate for 8 days .
Please help me for the solution .
Regards
1. As Shine said, the proc cl 10 can be set to a specific value say 9 only for these w/t's Basic, FDA, VDA - as the pay rules are same for these w/t's.
2. The pcr XPPF and its sub rules may be copied as Zxxx and customized as below.
Note wherever XPPF and its sub pcr's are calling say XPP0, XPP1, etc, change these lines to call ZPP0, ZPP1, etc.
3. In pcr ZPPF change as below
ESGG / W/t: * / /809
RTE=TKSOLL "calendar days of mth
RTE-TKSAP* " less all paid leave days
RTE-TKSAU* " less all unpaid leave
RTE/TKSOLL " divided by cal days of mth ->first part for working days
ZERO=&Z809 "set var Z809 to zero
ADDWT&Z809 "add temp results to var Z809
RTE=TKSOLL "cal days of mth
RTE-TASOLL " less work days in mth = free days
RTE*0.5 " multiply be 0.5
RTE/TKSOLL "divided by cal.days ->second part for off days
RTE+& Z809 "add 1st part from var
ADDWT * "factor to pay the w/t
Note there is a blank space before Z809 after & in the line
RTE+& Z809
The above should suffice.
.br JG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As mentioned above,
a)The wage types need to be changed in V_512W_D proc cl 10 to a value 9.
b)I would suggest you do not change the standard PCR's or schemas. Standard practice is to copy/create a customer PCR or schema with a Zxxx name. For example XPP2 is copied as ZPP2 and changed as required. When a pcr is changed, the schema which calls is is customized, then all the sub-schemas above and the main one.
The solution has been building up and lots of good work, This is an informative thread with a different kind of issue...
In case above is all working fine then you can avoid my suggestion...
Else,
Can we do as below assuming employee is going to apply an absence type the days he would be taking off.
We can define a daily work schedule variant for an Absence which is applied in case employee is taking off. Functionality wise, when the employee applies this absence type, the daily work schedule variant would be called with reduced hours say 50% and that ways the wage payment would automatically be taken care off with no work on PCR etc..
Just a plan B. Was trying to bring
Your thoughts guys
Regards,
Shine
My initial thoughts is to have PC10 with a common value say 2 for the three wage types which needs to be deducted at 50% and remaining all other wage types say 1. This itself would group the wage types and pave the way for the PCR to calculate them separately. To define the PCR, would require inputs to the above question? Also is the 8 days to be paid 50% end of the month or when is it coming say beginning of the month, mid, shifts etc?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sober,
Would this calculation logic be the same through out the year or for some months only?
Also to reconfirm for the 8 days other than basic, VDA and FDA all other wage types needs to be paid in full?
Regards,
Shine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I do not know how many months , client does not have the business , earlier they had 4 days weekly off Now this months onwards extra weekly of 8 days leave for all the employee means total working hours for week 4 days only .
Basic -Remaining 8 days need to calculate 50%
VDA->Remaining 8 days need to calculate 50%
FDA->Remaining 8 days need to calculate 50%
Conveyance
Edu Allowance
Washing Allowance
Open air allowance
Personal allowancw
Need to Calcualte any thing 8 days above components
Please provide the solution .
Regards
Hi,
Is this Layoff continuous one or specific date?
If it is specific date create two action one for layoff and another for end of layoff.
Write a PCR to check these two action. if it is lay off amount of the WT which needs to paid make it half and other make it zero..If action is end of layoff do not make any changes.
Incert the PCR in the schema after the payments & deductions.
John Cheriyan
Hi,
If that is the case you have to make change in the period work schedule, so that the employee has to work half day on the 8 days in the month.
Write a PCR to check the period work schedule to pay the amounts for other WT(WT which are not paying for 8 days) according to the requirement.
John cheriyan
I have given the same suggestion , They told me we do not require any other components in the same payslip
Suppose basic pay is there it has to calculate 22 days + 8 days it has to display only one header no other head is required .
I told them to calculate for 8 days and pay thru it 14 or 15
if possible if is display same header in will be workout , other guide me how to write pcr . Tmrw they need to run payroll , its very very urgent , please help me
Regrds
Hi,
Create one PCR to calculate the values for all the dummy WT.
Another PCR to subtract that amount from the original WTs.
after subtracting pass the last amount to the original WT to replace the actual value.
No need to make any changes in the payslip. the amount will be after subtracting the 8 days payment.
John cheriyan
Hi,
Thinking differently, can we work around the work schedules to solve this issue than a PCR. I am thinking like create a daily work schedule variant for saturday and sunday with reduced hours say 50%.
Then include the same in your currently using daily work schedule.
So working wise, when it comes to sat and sun, the variant daily work schedule would be called with reduced hours and this would naturally reduce the number of working hours for the day and the salary would be calculated accordingly. This way no need of playing with PCR.
Pls check if this would help your situation.
Thanks
Shine
Sunday is compulsory holiday , remaining 2 extra days They can take leave any days in a week
total working hours in weeks would be 4 days rest of three days leave . 22 days need to pay full pay and remaining 8 days need to pay 50% of basic for example basic is Rs 200 for 50% need to pay Rs 100 and some wage we need not pay for 8 days . This is very trick issue . I do know how to solve this issue
Regards
Ho Sober,
I think these 22 working day's could be vary based upon the month. If you are taking a example of three month like Feb, March and April. These three month having three different calendar day's then definitely your working day would be vary. And weekly off could be 4 day's or even 5day's in a month(like example May'16 and Feb'16).
Please check and let me know.
Regards,
Sankarsan
Oh ok. This part I understood now.
Now on those 2 days can you take any leave or there is a specific leave type for those 2 days and not earned leave. If there is specific leave days, then we can query the same use the function VARAB in the PCR and then process salary accordingly.
Shall try to work this out in the system and get back.
Hi,
Ok. Then could you tell me with below three scenario's that what would be your calculation process.
Suppose your Basic is 2000, FDA is 1000 and VDA is 1000.
1. Month of Feb'16
Where working day's 25 and 4 day's as Weekly Off.
2. Month of March'16
Where working day's 26 and 4 day's as Weekly Off
3. Month of April'16
Where working day's 26 and 4day's as Weekly Off.
You please add different number of absences for the month Feb, March and April and then share the details calculation which you are looking for.
Regards,
Sankarsan
Hi,
Then you please modify your factoring PCR like below.
Since your calculation based upon the working day's and after that absence day's with weekly off.
/808
RTE=TKAU**
RTE+TKAP**
RTE+TKAX**
RTE/2
ADDWT&101A
RTE=TASOLL
RTE+& 101A
RTE*KGENAU
RTE/TKDIVI
ADDWT *
Maintain PC10 as 8 for all the wage type for which this kind of calculation would be required.
Check and let me know.
Regards,
Sankarsan
Hi Sober,
I think in your excel sheet working day's would be 21 instead of 22day's. In the month of Feb total calendar day's are 29 and you have taken 8day's absence so that means actual working day's would 21 or your absence day's are wrong here in the excel sheet.
I think previous factoring part will be worked for 1st three wage type. You will add PC10 as 8 in V_T512W_D for these three wage types.
For HRA wage type you will give 0 for PC10.
For other wage type you will use 1 for PC10.
Hope so it will work.
Regards,
Sankarsan
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.