Show only the last labor transaction in a BAQ

Epicor ERP 9
1

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

2

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.

3

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

4

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.

5

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