OVERTIME THRU IT2010

[Former Member]

Hi Experts,

Can anyone help me to write PCR for Overtime scenario.

We are using negative time management and Overtime we paying through IT2010.

1.Staff Paying Overtime on Gross (Emp Grp = S)

    Ex: Total Gross = 10000

             = 10000/30 or 31 Calendar Days

             = 322.58 One day wage

             = 322.58 / 8 = 40.322 One Hrs rate

             = 40.322 * No of OT hrs ( Assume 120 hrs worked in a month) Which we maintain in IT2010

             = 4838.71 /-

2. Workers Paying Overtime on One day gross, We maintaining One day gross amount in IT0008 and have changed /805 Factoring PCR to

      Pay actual working days it means excluding weekly -off (Only friday).Like 26 days or 27 or 24 days (Emp Grp = w)

      Ex: One day Gross = 500

             = 500/8 = 62.5 (One Hrs rate)

             = 62.5 * No of OT hrs (Assume that 120 hrs worked in a month) Which we maintain in IT2010

             = 7500 /-

Could anyone help me to write PCR (Overtime) for employee sub group wise.

Regards

Prem

[leelamohan_kavali · Accepted solution]

Dear Prem,

Are you talking about gross means = /101 or do you have specific wage types?

If your talking about /101 then i hope so below PCR can help to you

9999 = Info type 2010

2000 = Payroll wage type

Ur's Mohan

[Former Member · Accepted solution]

Hi Mohan - Thanks for your reply.

Total fixed Gross in the sense of (Basic+HRA+DA+Special allow+Other Allow+Personal Allow)

Assume that = 10000/30 or 31 Calendar Days

= 322.58 (Per day rate)

= 322.58 / 8 Hrs

= 40.32 * 120 Hrs in IT2010

= 4838.71

Regards

Prem

[leelamohan_kavali · Accepted solution]

Dear Prem,

AMT= BASIC WAGE TYPE

AMT+ HRA

AMT+ DA

AMT+ SA

AMT+ OA

AMT+ PA

AMT/ KDIVI

AMT/ 8

AMT* 9999 (Info type 2010)

ADDWTE 2000 (Payroll wage type)

Ur's Mohan

[Sanky]

Hi Prem,

You can design your pcr like below.

ZTST

*

   ****

         OUTWPPERSG

                  S

                       9999

                              ADDWT *

                              AMT= /101

                              AMT/TKDIVI

                              ADDWT&VAR1

                              AMT=&  VAR1

                              AMT/8

                              ADDWT&VAR2

                             AMT=& VAR2

                             NUM=  9999

                             MULTI ANA

                             ADDWT 9999

                      ****

                             ADDWT *

                W

                     9999

                             ADDWT *

                             AMT=  1000

                             AMT/8

                             ADDWT&VAR1

                             AMT=&  VAR1

                             NUM=  9999

                             MULTI ANA

                             ADDWT 9999

                    ****

                            ADDWT *

Here WT9999 is the IT2010 entry for OT hours and WT1000 is the One day gross salary for W employee group which is maintained in IT8.

Use this PCR with PIT function like below

PIT ZTST GEN

and insert this after P2010 function in XT00 subschema.

Check and tell me.

Regards,

Sankarsan

[Former Member]

Hi Sankarsan - Thanks for your reply

Could you please explain me why we are using VAR1 and VAR2 ?

Meantime i will check and let u know.

Regards

Prem

[Sanky]

Hi ,

VAR1 & VAR2 is the variable wage type which is storing the intermediate result and will be using further for the calculation.

Regards,

Sankarsan

[Former Member]

Hi Sankarsan,

Am facing some problem in while writing the above PCR.

After ee subgrp

S

9999 (Sys not allowing to maintain the wage type there) Its show its not valid operation.

Can you please correct me if i am wrong.

[Sanky]

Hi,

Sorry it's my mistake.

After S & W use the operation WGTYP? and after that rest of the said pcr.

Regards,

Sankarsan

[Former Member]

Hi Sankarsan,

Please find the below screen shot and while running the payroll system throwing an error.

Could you please assist me on the same.

[Sanky]

Hi,

Your PCR syntax is wrong.

AMT=  /101 (after = give two space) and same in the NUM=  2004(Give two space after =).

Checka and tell me.

Regards,

Sankarsan

[Former Member]

Hi Sankarasan,

I have the changed the PCR accordingly but while running the payroll there is no value ?.

But if u maintain valuation bases (V_512W_B) with 100 % value is comings. There is a mismatch value.

But if u maintain valuation bases (V_512W_B) with 100 % value is comings. There is a mismatch value.

Total fixed gross/30 Days = 1 Day rate

1 Day rate/ 8 Hrs = 1 Hrs rate (This will be stored in /001 nd /002)

/001 - One Hrs rate will be stored

/002 - One Hrs rate will be stored

But  in my case Total fixed gross / 27 days = 1 Day rate / 8 hrs = 1 Hrs

=15000/27 = 555.555

=555.555/ 8

=69.444 * 10 Hrs overtime

=694.444 (but this overtime amount is not correct

Its should be

=15000/30 = 500

=500 / 8 hrs

=62.5 * 10 Hrs overtime

=625 Overtime amount

However i maintain the all wage type PC:1 as 3 and PC:10 as 1

Please assist me whether this is std behavior or need to correct somewhere else ?.

Regards

Prem

[Sanky]

Hi,

Share the input table details of ZOT1 pcr line and do not maintain any valuation basis PC01 for WT2004.

Regards,

Sankarsan

[venkateshorusu]

If you want constant value as 30 days then create a constant in V_T511K and place the constant in PCR instead of TKDIVI else place 30 instead of TKDIVI.

Regards

Venkatesh

[Former Member]

Hi Sankarsan,

Please find the Input table of ZOT1 and my question is whether sys behavior is excluding weeklyoff  the value will be store in /001 nd /002 ? as per calendar month it will store like 30 or 31 or 28 or 29 ?

Please correct me if am wrong

Ex: Dec-14

15000/ 27 (4 - weekly off as Friday)

Regards

Prem

[Former Member]

Hi Venkatesh - Yeah i got ur point we can maintain the value in constant table, In PCR we can pick up from constant table.

But my question is about valuation bases /001 nd 002 ?. How system is behaving either calender day or actual working days amount will store in /001 nd /002 ?.

Please advice.

Regards

Prem

[venkateshorusu]

As far i understand it is not actual working day and calendar days it is on the basis of planned working hours check planned working hours per that period.

let assume that monthly planned working hours are 240 then X/240 = 1 hour rate you will get over there.

Regards

Venkatesh

[Sanky]

Hi Prem,

In the pcr cahnge the EEgroup,

ZOT1

3

  ****

       Continue with rest of the logic.

Regards,

Sankarsan

[Former Member]

Hi Venkatesh,

Yes you are right. In my case Daily 8.30 Min and Weekly 6 days Monthly hrs is 215.80.

= 15000/215.80

= 69.5088

So this is a case how we will pay overtime according to my scenario ?.

Can you assist me whether need to change to get exact 1 Hrs rate to Overtime ?.

Regards

Prem

[venkateshorusu]

Now exactly what you wanted is even though day off's and holidays are there we have to consider 30 days to get the hourly rate in that case use divisor TKDIVP instead of TSDIVI then it considers 30 days for all months rest as usual.

Regards

Venkatesh

[Former Member]

Hi Sankarsan,

Can you please elaborate.

Which emp grup need to change do u mean Ee grp for PCR as 3. Here i have mention 3 for all the ee group.

or

Normal Ee grp Like Staff nd worker ?.

Regards

Prem

[leelamohan_kavali]

Dear Prem,

As you said if problem is coming from /001 & /002 i think so you might have wrongly maintained PC 1 --> Specifications because /001 & /002 amount will be derived by PC 1 --> Specifications. so once again kindly can you cross check wage types PC1 specifications and let us know...!

Ur's Mohan

[Former Member]

Hi Mohan - Thanks for your reply.

There is a error in PCR, System is not allowing me to write ESP For PCR * wage type as ****

Am wondering why system is not allowing me to write with std ?. Whether need to configure or change somewhere else ?.

I need to specifically to tel the system that ESP 3 nd Wage type as 2004 then system is consider and process the same.

According to your guidance and Mr.Sankarsan PCR are working fine and have changed one operation according to my business requirement and Output is coming fine.

Once again thanks to Sankarasan nd Venkatesh who supported me to over come on the same.

Regards

Prem