Skip to Content
avatar image
Former Member

Payroll Schema-Rule for Subtraction

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 06, 2007 at 04:14 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2007 at 04:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2007 at 07:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

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

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

      Thank You,

  • avatar image
    Former Member
    Oct 06, 2007 at 09:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 07, 2007 at 12:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 07, 2007 at 03:07 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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