No union dues should be taken when an employee is on LOA and no arrears if pay is at zero

[former_member594155]

Hello experts. I am new to PCRs and I need your help in the right direction.

This change is for a group of employees in a particular Personnel area.

When an employee is on Leave of Absence, there should be no union dues taken and any pay periods where an employee has no earnings, there should be no union dues deducted and union dues should not go into arrears.

[former_member193210 · Accepted solution]

If I understand you correctly, in a pcr that would be executed before Net Pay is created, you would like to create a pcr that takes Gross Pay and substract from it all your deductions, and then query it's relation to zero.

You could achieve that by processing all Earnings WTs and transferring their Amounts into a single Temporary Variable (through Operation ADDWT&xxxx) and also processing all Deduction WTs and transferring their Amounts into the same Temporary Variable. In a subsequent pcr, you would process the Union Dues Deduction WT and query the Temporary Variable, and should it's value be equal to zero or smaller than zero, then you would make the Union Dues Deduction WT "disappear" by not sending back into the Input Table.

[former_member594155]

Thanks for your help Remi.

Issue solved.

[former_member193210]

In this scenario, you could check the employee's status in the First Split and the Last Split of the Payroll Period, create temporary variables with the information, and then take the appropriate action regarding Union Dues.

First Split = Active and at Work, Last Split = Active and OnLeave - Calculate Union Dues

First Split = Active and at Work, Last Split = Inactive and Terminated - Do not calculate Union Dues

First Split = Active and OnLeave, Last Split = Active and OnLeave - Calculate Union Dues

First Split = ..., Last Split = ... - ... Union Dues

[former_member594155]

Thanks Remi. The first part is resolved. I'll need your assistance for the second part to the requirement. When an employee is on a LOA and subsequently terminated and "Paid out" for vacation. Union dues should be deducted. When processing the Union Dues deduction type; I queried the "Termination" Action and should the Action be "Termination", Union dues should be calculated. My dilemma is, because the termination action and the LOA are within the same pay period, there was no union dues calculated.

Below is my input table:

*

****

VAKEYMEMBS Membership subt.- VK

**** ADDWT * OT Output table

AB01 (Membership type)

OUTWPMASSN Action reason in VK

** PAYTP H Set ESG for PCR

20 (Termination action) PAYTP H Set ESG for PCR

10 (LOA action)

Union dues was not calculated because of the LOA.

Thanks again.

[former_member594155]

Thanks Remi. Yes, your understanding of my request is correct. I’ve been able to create a temporary variable as directed.

Variable queried as shown below:

AMT=& 2750

AMT?0

*

>

FILLF A

ADDWT *

[former_member193210]

If you have been able to solve your problem, please close your query (mark it as solved) so that other users searching for a solution to a similar problem would know to look at your solution.

[former_member594155]

Hi Remi,

Further to your question; we also have a wage type, 2075 to confirm that earnings is at zero.

Waiting for your treasured response.

Thanks

[former_member594155]

Thanks Remi for your response.

The union dues is a fixed amount per Pay period and it's calculated using a PCR.

For the employees on LOA; the action type in IT0000 could be queried to confirm the LOA.

In our system, WT /550 is used to confirm pay at zero.

How do i write a PCR to query the Net Pay and exclude the Union dues calculated?

[former_member193210]

How are your Union Dues calculated? Most of ours are based on a Custom Cumulator (/190 or /191) and a percentage, so there is no deduction when there is no revenue, but we also have some that are a fixed amount per Pay Period, and those require a special pcr during Long Term Unpaid Absences.

For your employees on LOA, is there an Infotype Field or a WT that could be queried to confirm that the employee is on LOA?

In your system, what WT could you use to confirm that "pay is at zero" ?