Late Hours Deduction Amount Calculation using Custom PCR

[BalaAP]

Introduction:

The purpose of this document is to explain about developing a Personnel Calculation Rule to calculate late deduction amount (from Basic Pay wage type).

Calculation formula:

Basic pay wage type to be calculated for the late hours and (from month basic to hours rate) and will be deducted from the employee's salary. You can also add other wage component for basis calculation depends on the requirement. I have taken the example to deduct only from Basic Pay component for illustration purpose.

Input :

We can maintain late coming hours to be deducted Infotype 15 with a wage type 7100 (Late deduction hours). The late hours may also be calculated from time evaluation and can be loaded in ZL. But, for simplicity, I have taken the example of entering late hours in IT15 wage type.

In this scenario,

Basic pay (WT 9000) amt = Rs.19,200

Late Hours (WT 7100) num=0.5 hours

PCR:

Calculation:

Employee's Basic salary is Rs.19,200 (which is AMT field of wage type 9000).

Late Hours is 0.5 hours (in wage type 7100's NUM field).

Calculation Steps:

NUM+ 7100              -> loads the value .5 for calculation.

NUM*10000              -> multiply 0.5 x 10,000 = 5,000

RTE=GKSOLL          -> loads the calendar days of the current month in RTE field

                                        30).

RTE*8                       -> multiply 30x 8 = 240 and store it in RTE field

DIVID NRR               -> divide 5,000/240 = 20.83 and store it in RTE field

NUM/10,000             -> divide 5,000/10,000 = 0.5 and store it in NUM field

MULTI ARA              -> multiply 19,200x20.83 = 399936 and store it in AMT field

AMT/10,000              -> divide 399936/10,000=39.9936 and store it in AMT field

ROUND 100              -> round 39.9936 to 40.00

ADDWT 7100            ->  store amt 40.00 to wage type 7100     

FILLF A,N,R              -> restore original AMT, NUM & RTE values back to wage type 9000 (basic pay)

ADDWT 9000            -> store wage type 9000 back to table IT/OT

Verification:

Month Basic pay amt = Rs.19,200

Per day rate     = 19,200 / 30= Rs.640

Per hour rate    = 640/8 = Rs.80

For 0.5 hours rate = 80x0.5 = Rs.40

Placement of this PCR in Payroll Schema:

This PCR can be placed in sub-schema INAP (import further payment/deductions), if the late hours

are entered in IT15.

PCR should be placed after the function P0015.

PCR can be called as:

PIT ZLTD