cancel
Showing results for 
Search instead for 
Did you mean: 

Payroll Schema-Rule for Subtraction

Former Member
0 Kudos

Hi,

I need to write a rule in Payroll schema wherein I need to deduct 2 Wagetypes and show the result in RT table meaning we have wagetype 2000 and wagetype 3000. I need to deduct Wagetype 3000-Wagetype 2000 = XY and the result XY should be reflected in RT Table.

Please help me writing the rule.

Regards,

Garima

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Arun,

We are using Amount here. I have configured but still the deduction is not getting reflected in the output table.

Please Help.

Regards,

Garima

Former Member
0 Kudos

Hi Garima,

When you say output table, are you referring to the table in the 'Output' section of the PCR in the payroll log or the RT table?

Also, could you have a look at the 'Processing' section of the PCR and let me know if WT 1060 is processed before WT 1080?

Your rule seems OK but based on the answers to the above questions, you may have to amend the PCR a little.

-Akshay

Former Member
0 Kudos

Hi Arun,

I tried the rule but it is still not deducting the values between the wagetypes in

OT(Output Table). It is giving the same value which is Input Table.

Please help.

Regards,

Garima

Former Member
0 Kudos

What is there in the wagetypes? Number, Amount or Rate or all.

Former Member
0 Kudos

Hi Arun,

I have designed in the following way.

There are 2 wagetypes 1080 and 1060 where in the requirement is 1080-1060.

WGTYP? Query wage type

****

ADDWT * OT Output table

1080

SUBWT 1060 OT Output table

ADDWTE1060 RT Results table

Please help me in correcting what I have done.

Regards,

Garima

Former Member
0 Kudos

Looks ok.

Former Member
0 Kudos

Hi Arun,

Sorry for asking the basic question. How the rule will deduct the wagetypes(say

Wagetype X-Wagetype Y=Z) and send the value Z to RT Table.

Please Help.

Regards,

Garima

Former Member
0 Kudos

Hi,

Please see my earlier answer. You are asking the same question again!

Please <b>reward points for all my answers</b>.

Thank You,

Former Member
0 Kudos

Hi,

Can anybody give me an example of it meaning a sample Rule. It will be a great help.

It will be rewarded.

Please Help

Regards,

Garima

garimadutta1@yahoo.com

Former Member
0 Kudos

Hi,

Please see a sample rule which I uploaded on this site:

<a href="http://img131.imageshack.us/my.php?image=rulera7.gif">Sample Rule</a>

In this rule, operations like OUTWP and MODIF are used.

<b>Reward points appreciated</b>,

Thank You,

Former Member
0 Kudos

Hi,

1. For deducting values from 2 wagetypes, please use the subtraction operation.

2. For storing the results in RT table, please use the operation ADDWT with parameter E.

<b>Reward points appreciated,</b>

Thank You,