Need to Hold 1month of transport allowaces wagetype for new join employee

[Former Member]

Dear Experts,

Need your Suggestions on my client requirement.. Now we need to Hold 1month of Transport allowances wagetypes like 1400, 1401 nd 1402 for 3 payroll areas ex LA, LN, LU for only new join employees from current month. For Ln the transport allowances is 150, LA is 200 and LU is 250. If they join in mid month also the remaining amount should deduct in next month payroll until it tally to 1month allowance..Once the employee is confirm using infotype 41. the amount which is withhold while joining should repay them.

Experts , I requested you to please give some suggestions regarding my issue.How should i write PCR for this..Do i need to create a different wagetypes to store amts..

Highly rewarded and appreciated for ur valuable suggestions.

Thanks & Regards

Vicky

Edited by: vicky267 on May 24, 2011 10:59 AM

[Former Member]

1 possible way is -

You compare the end date of the current period with IT0041 date.

If end date is less than IT0041 then

Pass 1400, 1401 and 1402 wage type to RT directly be before processing of subchema INAL (Period factoring and storage). Also cumulate these wage type into CRT by setting processing class 30.

Else (end date is greater or equal to end date)

Pass these wage type to another wage type lets say 1500 (may be you can use the same wage type as well but make sure that CRT is not creating an issue for this. Hence probably creating a new wage type is less risky). Now add CRT value of 1400 to 1500 and pass it to the output table for the further processing. Also check into which cumulation wage type, you want to cumulate and set 1500 characteristics accordingly.

Hence you are dealing with only 1 wage type for all the cases. Also you can use the same wage type i.e. 1500 for all payroll area as employee will hold only 1 at a time.

Probably you can achieve this by the PCR. Also not that this PCR should be placed before subschema INAL.

[Former Member]

Dear Praveen,

Thanks for ur immediate response.Appreciate for ur suggestions. Im very new to handle Schemas and very much puzzled to write new PCR. Previously they use to Hold 10days salary, transport allowances only for new join employess..now they want to hold 1month of transport allowance for new join staff.

Previous the PCR was like this .. It is in subschema ZAL0 (Monthly factoring and storage) In this there are few PCRs like

PIT ZNH9 GEN NOAB Calculate new hire w/h factor

PIT ZNJA P99 NOAB Cumulate new hire WH WTs

PIT ZNJB GEN NOAB Valuate WH amount

which is configured to hold 10days salary and allowances.

1.) PIT ZNH9 GEN NOAB Calculate new hire w/h factor

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

D ZNH ENTRY IN MONTH

• D ADDWT * WGTYP?

• ****

• 1000 Z ZERO= A NUM=CU9F0DGCY ZNH4 CASE PREV MTH <10 DAYS WH

1 D ADDWT * WGTYP?

1 ****

1 1000 Z GCY ZNH2

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

D NUM?0

• Z NUM*-1 NUM+10 ADDWT 9F0DGCY ZNH3

= CASE OF OLD EMPL WITH NO WH

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

0 D WPALL?LAST

0 N

0 Y D NUM=TKSOLLNUM?10 WORK DAYS IN MTH

0 Y < AMT=TKDIVINUM*KGENAUDIVID NAR NEXTR A

0 Y < A ZERO= AN ADDWT 9F00NUM=TKSOLLZERO= R ADDWT 9F0D

0 Y = NUM=10 AMT=TKDIVINUM*KGENAUDIVID NAR NEXTR B

0 Y = B ZERO= AN ADDWT 9F00NUM=10 ZERO= R ADDWT 9F0D

0 Y > NUM=10 AMT=TKDIVINUM*KGENAUDIVID NAR NEXTR C

0 Y > C ZERO= AN ADDWT 9F00NUM=10 ZERO= R ADDWT 9F0D

2) PIT ZNJA P99 NOAB Cumulate new hire WH WTs

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

D VWTCL 99 CHECK PCL 99

• ADDWT *

1 ADDWT * ZERO= NR ADDWT 9F00

3) PIT ZNJB GEN NOAB Valuate WH amount

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

D OUTWPPERSG EXCLUDE TEMP (T)

• D WGTYP?

• **** ADDWT *

• 9F00 RTE>& 9F0 MULTI RAA AMT/KGENAUADDWT * ZERO= RN NEXTR 1

• 9F00 1 AMT*-1 ADDWT 9F0W

T ADDWT *

4) ACTIO ZST2 GEN Reimburse confirm

Var.Key CL T Operation Operation Operation Operation Operation Operation *

-

---

----

---

--

---

+

---

+

---

+

---

+--

---

+

D ZD CUSTOM OPER FOR WESTPORT

• NORMAL - NO CHANGE

1 NEW HIRE - NO CHANGE

2 AMT=CU9F0WAMT*-1 ADDWTI9F0P CONFIRM - PAY WITHHELD AMT

Here is the Payslip how it appears for 10days salary and allowances holding.

Basic Salary (Monthly) 2,125.16 E.P.F. (Employee) 348.00

AL, Transport (EX) 174.19 S.O.C.S.O. (Employee) 6.25

New Join Withholding 843.29-

Now can we use the same schema and Pcr to hold only 1month transport allowances..Please suggest me . Need your helpful tips ...

Thanks & Regards

Vicky