PCR for Bonus Calculation ?

[Former Member]

CASE1:

Below are the Recent Bonus act amendment changes

Bonus celieng amount is 7000 and eligibility limit is 21000.

Bonus Calculation:

Employee Basic pay is 8000.

Bonus calculation: system will consider 7000 for bonus calculation.

= 7000*20/100

=1400

we are using below Two PCR's  for  above requirement.

CASE 2:   - MY Client Requirement

Bonus calculation based PA is new requirement.

We have maintained few PA‘s along with minimum wage amount in Custom table.  Custom table is   Zhr_PY_Minmum_wages

EX:   we have maintained more than 50 PA's in custom table. As an example below i have given 3 Personal area's.

Personal Area                                                             Minimum Wages

1122                                                                                8000

2233                                                                                6000      

6789                                                                                9000

Bonus Calculation:

Example:

• Ø If Employee PA is  1122  (  PA 1122  is available in Custom table) then system should fetch the minimum  wage  of  PA

          from custom table and  system should use same amount for bonus calculation.

= 8000*20/100

= 1600

• Ø If Employee PA is not available in  Custom table then  bonus calculation as CASE1

               = 7000 * 20/100

                = 1400

Can anyone provide PCR to  ( CASE2  )above Requirement.

Thanks& Regards,

Anand

[raghu_c]

Reading from a custom table in PCR is not possible unless you write your own operation. The following two options can be considered.

Approach-1:-

Maintain Minimum wages in Table T511k.

Write 2 PCR's to calculate Amounts based on Formula.

Write a PCR to identify PA and use IF/ELSE loop and insert the PCR's.

Approach-2:-

Write a custom program to calculate amount based on custom table and update IT-15/IT-267 accordingly.

Raghu