on 09-11-2015 5:10 AM
I need to query rate based on comparison $8.50 please help me
For example If an employee earned amount is 300 and his working hours in a week are 40
370/40 = 9.25/hr so for this scenario its not required to calculate
If an employee earned amount is less than that is $8.50
270/40 = 6.75 that is 8.50 - 6.75 Still we have to make a payment 1.75 How would i query this rule
1.75 have to make a payment in another wagetype
It can be achieved with the help of PCR.
XXXX Earned amount wage type
ADDWT *
AMT/Week working hours(40 Constant or Field value from System)
RTE=1
MULTI ARR
RTE?8.50
<
RTE-8.50 (Create a constant and use)
RTE*-1
AMT=1
MULTI RAA
ADDWT YYYY
*
Regards
Venkatesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.