tea deduction scenario

[Former Member]

Hi Experts,

I have a scenario wherein client deducts 0.20 paisa per day as tea deduction amount from employees. This amount is deducted only on present days and not deducted for overtime days. I have added this as deduction wage type in 0014 but i think i am not able to figure out how to get the calculation in payroll, can someone please help on this.

Thanks in advance.

Regards,

Jyoti

[Former Member]

Hi,

Create a z program and update IT 0015

Calculate the deduction amount inside the program

Count days = Total days - off days - holidays - absence days in IT2001

Deduction amount = Count day's * .20

Execuite the z pgm last of the month for batch of employees

Regards,

Siva

[sikindar_a]

Please try to create a Z specification for the PRCL 47 and Place the PCR for that Z specification for PCR X011 and assign this specification for only that wage type so that only that wage type wil get effected

[Former Member]

Hi ,

Can you elaborate on your point little more because i dn't know how to stop the impact on other wage types assigned in 0014, as earlier stated it is impacting all the wage types, Let me give you detail of how i am doing the schema and pcr

PE01

IN00 (ZN00)> INAP(ZNAP)> X011(Commented) ( Z011 )

PE02

Z011

*

4TEA

AMT = BETRG

NUM= ANZHL

RTE=TASOLL

MULTI ARA

AMT/100

ADDWT 4TEA

AMT= BETRG

NUM= ANZHL

VAKEYZEINH

(then regular pcr)

But by doing this 4TEA calculation is not getting reflected in payroll....pls help.

Regards,

Jyoti

[former_member193210]

What are the values entered for WT 4TEA in IT0014 ?

A number of days, an amount per day ?

Are you using function P0014 in your Payroll Schema ?

If so, what are the PCRs associated with that function, and what processing is happening to WT 4TEA ?

What are the values of WT 4TEA in the Input Table after processing through function P0014 ?

What function is used to call PCR Z011 ?

If the rate for the "Tea Deduction" can change in the future, it would be preferable to use a constant in V_T511K to hold it's value since it is easy to delimit the change and minimizes the potential for input mistakes.

[Former Member]

Hi Remi,

I am using amount in amount field of 0014 (0.20), i have tried constant option also it is working

Post that i have created a Z in INAP(ZNAP)--> X011(Commented) ( Z011 ) and then modified standard PCR

But the problem is the PCR i have created is not multiplying AMT * TASOLL if i use 4TEA seperately but is doing calculation in case i use the PCR under ****

But in case i use PCR under **** all the WT entered in 0014 are also getting multiplied by TASOLL i.e. taking logic of 4TEA.

Please check the following

PE02

Z011

*

4TEA

AMT = BETRG

NUM= ANZHL

RTE=TASOLL

MULTI ARA

AMT/100

ADDWT 4TEA

AMT= BETRG

NUM= ANZHL

VAKEYZEINH

(then regular pcr)

Thanks

jyoti

[former_member193210]

Then try starting with a decision using operation WGTYP?, as in:

Z011 * ****

D WGTYP?

• AMT= BETRG NUM= ANZHL VAKEYZEINH

4TEA AMT = BETRG NUM= ANZHL RTE=TASOLL MULTI ARA AMT/100 ADDWT 4TEA

[Former Member]

Hi Remi,

I tried it but it is giving error D WGTYP ? is nto a valid operation.

Pls suggest.

regards,

Jyoti

[Former Member]

Hi Sikindar/Sujith,

Can you elaborate on your point little more because i dn't know how to stop the impact on other wage types assigned in 0014, as earlier stated it is impacting all the wage types, Let me give you detail of how i am doing the schema and pcr

PE01

IN00 (ZN00)> INAP(ZNAP)> X011(Commented) ( Z011 )

PE02

Z011

*

4TEA

AMT = BETRG

NUM= ANZHL

RTE=TASOLL

MULTI ARA

AMT/100

ADDWT 4TEA

AMT= BETRG

NUM= ANZHL

VAKEYZEINH

(then regular pcr)

But by doing this 4TEA calculation is not getting reflected in payroll....pls help.

Regards,

Jyoti

[Former Member]

Hi Remi,

thanks for the help extended with your suggestion i tried with the solution and now it is working . I rewrote the PCR and incorporated all the other conditions . It is working, thanks and i have awarded you points for great help.

Thanks a lot

Jyoti

[Former Member]

Hi,

Please use the following processing classe for your wage type property for tea deduction.

01 - 0

03 - 6

04 - 6

05 - 9

06 - 0

10- 5

15 - blank

17-blank

18-blank

20-1

24-blank

25-blank

30-0

31-0

35-blank

41-8

46-blank

47-1

50-blank

70-blank

71-(all blank)

72-

76-

77-

90-

91-

Cumulation Class

1-

10- tick mark

11-

12-

13-

14-

15-

16-

17-

18-

19-

20-

21-

24-

25-

27-

28-

29-

30-

31-

32-

33-

34-

35-

36-

37-

38-

39-

40-

41-

42-

Evaulation Class

1-

2- print from without sepcific assignment

3-

4-

5-

& all should be blank

Try the wage code property. Your problem will solve.

Regards,

Santosh Shivane

[Former Member]

Hi santosh,

thanks so much for your help. The wage type 4TEA is showing in payroll but the calculation is not showing. I have written the following PCR:

AMT = BETRG

NUM= ANZHL

RTE=TASOLL

MULTI ARA

AMT/100

ADDWT 4TEA

The code is showing the desired effect i.e. calculating Tea Deduction as per work days, but this is impacting all the other payments I am doing in infotype 0014 it is dividing all the payment amounts by 100. please help.

Regards,

Jyoti

[Sujith_EM]

If you giving the the num 0.2 in your wage type through IT0014

try this

*

ABCD ( here abcd is your wage type)

RTE=TASOLL

MULTI NRA

ADDWT ABCD

and put this under the function P0014

I tried this PCR it is working with the scenario you mentioned

Edited by: Sujith Nambiar on May 11, 2011 4:13 PM

[former_member193210]

In your Payroll Schema, look for function P0014 and the PCR associated with it.

That is where IT0014 is processed.

To automate the process, you could build a PCR in Time Evaluation to generate a WT with a value of 1 for every "normal day" and store that WT in table ZL. Then, in Payroll Processing, that WT would have a value in it's number and you could use a constant from V_T511K to hold the rate (0.20 paisa) and get the PCR to do the math. This would minimize the effort required weekly to make the deduction and minimize the risk for errors.

[Former Member]

Hi Remi,

Thanks for your prompt response but we are not doing time evaluation we are managing time management manually through negative time management, can you recommend some other solution.

Thanks

Jyoti