Skip to Content

How would I combine amounts of 2 same wage types off Table RT?

On payroll processing, I'd like to add amounts of the same wage types coming from PRT table RT. I want my final results to show only 1 line on this wage type with the total amount.

The 2 lines are:

3 854R Text Description0101 0001 B 08 1,000.00

3 854R Text Description0101 0001 250.00-

ESG 3, Wage type 854R, and cost center 0001, are the same for these 2 lines, however, one has a variable assignment type (B 08), the other does not. For the final RT table, I'd like to see only 1 line:

3 854R Text Description0101 0001 750.00

I very much appreciate any assistance. Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 05, 2017 at 09:30 PM

    Thank you very much. I was able to get the desired results.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 01, 2017 at 05:05 PM

    If I understand you correctly, you do not need the variable assignment (B 08) in the final RT.

    Then, why not eliminate that split before the WT is transfered from the Input Table (IT) to the Results Table (RT) ?

    Find where WT 854R is transfered from IT to RT, and just before that Function, add a PCR that will process WT 854R and use Operation ELIMI X to eliminate the Variable Assignment Split.

    Add comment
    10|10000 characters needed characters exceeded