LaborHed Payroll Date - Change via BPM in E10.1

I have typically handled this in crystal reports in the following manner


( if {EmpBasic1.Shift} <> 3 then 

    {LaborDtl1.PayrollDate} = {@lastBusinessDay} to {@lastBusinessDay 2}

  else

    {LaborDtl1.PayrollDate}-1 = {@lastBusinessDay} to {@lastBusinessDay 2}

)

We have third shift employees that start Sunday evening around 10:00pm. In E9 their payroll date would roll to the next day so they weren't paid overtime for Sunday(We have an external payroll system we feed with Epicor data). Now in E10 that changed so I'm trying to create a BPM or data directive to change the payroll date. I've tried an in-transaction data directive on the LaborHed table for Added rows but can't get it to work. I created a condition to base it off of shift = 3, ClockInTime > 17.0 (9:00pm) and PayrollDate = Today. I added a message to pop up that displays shift, clockin, and payroll date and shift seems to be the only field populated. Is there a better way to go about this?

Since you are feeding a payroll system, why not collect the Labor.ClockOut date to a UD field and use that in your feed vs the payroll date. If they punch out during a normal day shift like an 8-5 it will be the right date. If they punch out over a midnight rollover you would get the next date? Could that work?

 

Joshua Giese
Technology Solutions : CTO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 27, 2016 13:25
To: vantage@yahoogroups.com
Subject: [Vantage] LaborHed Payroll Date - Change via BPM in E10.1

 

 

We have third shift employees that start Sunday evening around 10:00pm. In E9 their payroll date would roll to the next day so they weren't paid overtime for Sunday(We have an external payroll system we feed with Epicor data). Now in E10 that changed so I'm trying to create a BPM or data directive to change the payroll date. I've tried an in-transaction data directive on the LaborHed table for Added rows but can't get it to work. I created a condition to base it off of shift = 3, ClockInTime > 17.0 (9:00pm) and PayrollDate = Today. I added a message to pop up that displays shift, clockin, and payroll date and shift seems to be the only field populated. Is there a better way to go about this?

Where would I gather the clockout date?  It doesn't exist in the laborhed or labordtl tables.

Just need a bpm to add today to a Date0# field when you run Labor.ClockOut

 

Joshua Giese
Technology Solutions : CTO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, July 27, 2016 13:51
To: vantage@yahoogroups.com
Subject: RE: [Vantage] LaborHed Payroll Date - Change via BPM in E10.1

 

 

Where would I gather the clockout date?  It doesn't exist in the laborhed or labordtl tables.