Skip to Content
0

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

Aug 22, 2017 at 09:54 PM

48

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Sep 05, 2017 at 09:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Rémi Corriveau Sep 01, 2017 at 05:05 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded