Is there a way to query what jobnumber is active on screen by user?

[Claudiagfx (Epicor account)]

I’m trying to find a way to query what job number is user logged into and is active on the screen.

[utaylor (Utah Taylor)]

There is a table called LaborDtl. Find the rows where LaborDtl.ActiveTrans = 1 (true). Then return LaborDtl.JobNum. You can also see the assembly and operation. I believe that will give you those jobs that are punched into. You can join empbasic on labor dtl to get the full employee record (name, address, etc).

[jgiese.wci (Joshua Giese)]

If you have access to it use Shop Vision under Executive Analysis and Trackers.

[utaylor (Utah Taylor)]

Nice, there is that too! Forgot about that one! @jgiese.wci