Skip to Content
avatar image
Former Member

CTC fixation

Hi,

This is existing configuration in the system for basic pay

Level 0 1 2 3 4 5 6 7 8 9 Basic Salary 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC 50 % of CTC House Rent Allowance (HRA) NA 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic 50 % of Basic Conveyance Allowance (CA) NA 9600 9600 9600 9600 9600 9600 NA NA NA Children Education Allowance (CEA) NA NA 2400 2400 9600 9600 9600 9600 9600 9600 Medical Reimbursement NA NA 15000 15000 15000 15000 15000 15000 15000 15000 Leave Travel Allowance (LTA) NA NA NA 15000 18000 24000 30000 42000 60000 78000 Professional Development Reimbursement NA NA NA NA NA NA 12000 12000 24000 24000 Attire Reimbursement NA NA NA NA NA NA 12000 12000 24000 24000 HDFC Food Card NA NA NA NA 13200 13200 13200 13200 13200 13200 Special Allowance Balance amount

But the client requirement is  as given below.

There are 9 levels for each level this 4 conditions has to be satisfied, I know its not possible through standard configuration

In standard configuration one level can satisfy only one condition.

May be we need to develop custon program for this, if we need to develop custom program  can you please give me some idea for creating Functional Specification.

Is there any BADI or User exit to implement this.please suggest

Condition:-1

If Gross Monthly Salary is Less than or Equal to Rs. 9750 then

Allocation:-1

Components

Value

Allocation Priority

Basic  Salary will be

6500 - Standard

1

HRA

Differential Amount

2

other componets

NA

NA

Condition:-2

If Gross Monthly Salary is Greater than 9750 & Less than or Equal to Rs. 22500 then

Allocation:-2

Basic  Salary will be

67% of Gross

1

HRA

Differential amount

2

other componets N/A

NA

NA

Condition:-3

If Gross Monthly Salary is Greater than 22500 & Less than or Equal to Rs. 30000 then

Allocation:-3

Basic  Salary will be

15000

1

HRA

7500

2

Convyance - (Eligibility according to table)

3

Medical  - (Eligibility according to table)

4

CEA  - (Eligibility according to table)

5

LTA  - (Eligibility according to table)

6

Condition:-4

If Gross Monthly Salary is Greater than 30000 then:

Allocation:-4

Allocation according to the tabel:

Regards,

Bhaskar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 09, 2015 at 06:31 AM

    Dear Bhaskar,

    Try the below Config:

    1. Create 4 different Gross Wage Types and maintain the min and max amount for the Gross

    2. Create 10 levels and assign the wage type allowance to your levels (Assign respective gross to the levels - I guess Gross will also vary depending on level)

    3. Configure wage type valuation (Spl Allowance = Gross - all wage types)

    when you select the level, system will default the respective wage types. Enter the gross and the rest wage types will be defaulted with the amounts.

    Please let me know if you have any more deviations in the structure.

    Regards

    Ravi Kumar

    Add comment
    10|10000 characters needed characters exceeded