cancel
Showing results for 
Search instead for 
Did you mean: 

Payroll PCR : Remove number from wage type after calculating amount

Former Member
0 Kudos

I am really new to payroll schema and trying to achieve a small functionality

I have a  wage type that have amount calculated from rate and number. After the amount is calculated, I want to remove the number so that RT will have only amount and rate and not the number.

This was the earlier PCR content

MULTI NRA

ADDNAE*

I tried changing it to as below to zero the number but its removing the amount along with the number

MULTI NRA

ZERO = N

ADDWTE

Please help with this

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member193210
Active Contributor
0 Kudos

First, please mention what Function you are using to call your PCR since you are writing directly into the Results Table (using ADDNAE or ADDWTE).

You have not mentioned what data is being processed, but I would suggest that you try

MULTI NRA

ZERO= N

ADDWTE*

Former Member
0 Kudos

I am generating wage type in RT with amount but no hours. This amount gets generated from the hours and rate but doesn't want to show the hours. Below is full pCR which does this. it s the hours zeroing out which is not working

RTE = /002

MULTI NRA

ZERO= N

ADDNAE*

former_member193210
Active Contributor
0 Kudos

Yes, I understand that you want the output to be in RT, but from where is the information comming from?  What function is used to process the PCR?

If the WT you want to modify is already in RT, then you won't be able to delete it's Number and the PCR should be built to process the Input Table just before the WT is cumulated and transfered to RT.

Former Member
0 Kudos

Wage types are not in RT until this rule is called. This rule is the one that generates the wage type.

PRT is the function used to call the PCR. for each wage type 86XX, 85ZZ wage type should be generated with a specific amount but these 85XX should not have the number in RT but only the amount. Hope this information helps.

/002 is in the RT when the rule is called and hence rate is picked from here and hours are picked from the wage type 86XX and amount is calculated to put in 85XX wage type.

Requirement is to only have amount in 85XX in RT and remove the number once calculation is done

former_member193210
Active Contributor
0 Kudos

Since the PCR is called by Function PRT, it is processing the WTs that are already in RT.

According to what you just wrote, the RT must contain WTs /002 and 86XX, and you want to use the Rate from WT /002, multiply it by the number of WT 86XX to get an Amount, and generate WTs 85XX containing only the Rate and Amount.  Correct?

Former Member
0 Kudos

That is correct.

former_member193210
Active Contributor
0 Kudos

Here is an example I created using WTs that I have available at the end of schema ZAL0

This is a screen capture from the log detailing the processing

There are other ways to create the PCR, and it could have included all WTs in the 1XXX range.  Basically, when processing the 1XXX WT, the Rate is set anew, the multiplication is done and the Number is deleted, and the result is saved under a different WT.

As for the Rate, the WT I used had a split so I used a temporary variable that would save only the value of the last split as I could not garantee that the WT used would have the same splits as the WT being processed (and that can have an impact).

Hope this helps.

Former Member
0 Kudos

Resolved the issue by creating a new rule and calling using PIT.

former_member193210
Active Contributor
0 Kudos

It could be helpful to others if you would mention how you resolved your issue, and why you opted to call your PCR through function PIT instead of PRT.

venkateshorusu
Active Contributor
0 Kudos

If your query is answered you can close thread as well.

Regards

Venkatesh

Former Member
0 Kudos

I typed in wrongly in post without space. There is no syntax errors when I run simulation but as I mentioned earlier, amount and number is becoming zero when I does this.

venkateshorusu
Active Contributor
0 Kudos

PCR syntax is wrong just write like below

MULTI NRA

ZERO= N  (No space after ZERO= N)

ADDWTE*

Regards

Venkatesh