Show only the last labor transaction in a BAQ

I am trying to write a BAQ in E9 that will display the last labor transaction date for all released jobs. Is there a way to only pull the last clock in from the LaborDtl table?

Thanks
-Phil

I believe it was there in 9 already but maybe not, JobOper.LastLaborDate. If you want it by just job and not oper you are probably boned in 9 without the aggregate options of 10.

@jgiese.wci
Isn’t there the Find First/Find Last kindda toggle option in the designer?

Yes but depending on the rest of the query it can be hit or miss if those work. They were always pretty sketchy I had limited success with them behaving as expected.

What I did was use a UD field like JobHead .Date01 an updated it with a BPM when the LaborDtl table was updated. After doing that, I had the last labor in the job head available for dashboards. You could go beyond that and capture the last
assy and last op as well to have a reference link back from the last labor entry.

Charlie Smith

CRS Consulting Services

860-919-1708

1 Like