Indirect Evaluation of Wagetype

[Former Member]

Hey Guys,

I have been finding it difficult to evaluate wagetype 1017.In the attached screenshot,

wagetype 1017 has to  be a %age (mentioned in wagetype 1011) of total of wagetype 1000 and wagetype 1200.

wagetype 1011 is an input value by the user. I was able to bring total of the 2 wagetypes but then again I need to prorate into % given in wagetype 1011.

Example :-

1000 = Rs. 10,000

1200 = Rs. 12,000

1011 = 5%

1017 = 5% (10,000 + 12,000) = Rs. 1,100

Note :- we do not process payroll for these employees. This value is being picked for ECM processes.

Any help would be greatly appreciated.

Regards,

ARNAV...

[Former Member]

You can store the percentage in wage type 1017 itself. You do not need a separate wage type only for the percentage.Try this:

1) In v_t511, assign the below characteristics to wage type 1017:

Amount +

Number/unit +

Time unit/meas. Percent

Indirect eval.module PRZNT

Module variant B

2) In v_t539J, create two entries for wage type 1017, one for each base wage type. In both the records, assign the module PRZNT & Percent should be 100.

Then when you are entering wage type 1017 in IT 8, specify the percentage for that employee. The system will calculate the amount for wage type 1017 as (sum of base wage type amounts)* wage type 1017 percentage.

[Former Member]

HI Tania,

That was an awesome solution...
I tried your solution and it works. So what I did was, I was PRZNT with B for 1011 under T511 and T539J contains 100% for 1017.

So, I was getting the value in 1011 wagetype correctly. But I need the amount to be re-written in wagetype 1017 itself and wagetype 1011 would remain only percentage entry field.

Regards,

ARNAV...

[Former Member]

The solution i recommended requires storage of the percentage in wt 1017 itself. There is no need for 1011. Store the percentage in 1017 & the corresponding amount will be calculated in the same wage type through PRZNT.

[Former Member]

Hi Arnav,

Let me know, Is your % Fixed?

Regard

KKS

[Former Member]

HI KKS..

No percentage is not fixed and it is an input field. User can enter anything from 1-100 as a percentage.

Regards,

ARNAV...

[Former Member]

Hi Arnav,

1) IF 1011 is only for % to be defined for WT1017.

Then We can eliminate 1011 WT and give 1017 as % Based for WT 1000 and 1200.

2) Also maintained V_t539J for WT 1000 and 1200 for base WT 1017.

Regard

KKS

[Former Member]

Hi KKS,

Thanks for this..

However, the percentage is a value that user is going to update in IT0008 and it is going to be different for different employee.

Regards,

ARNAV...