Issue creating BAQ

Kinetic ERP
,
1

I’ve been tasked with creating a report that gets emailed to all supervisors weekly of all active employees.
I thought I’d start by creating a BAQ to list all active employees and their supervisors. I have the Erp.EmpBasic table selected. Have my criteria set to only show active employees. However, when I go to select display fields “SupervisorName” is not listed. I can select SupervisorID, but that’s not very useful. When looking in the employee screen, supervisor name is as shown:

Employee Maintenance SupervisorName
Employee Maintenance SupervisorName336×552 45.5 KB

Any ideas on how I can get this accomplished?
I’m working in Epicor 11 (Kinetic)

2

That supervisor ID is just an employee ID. Add another EmpBasic table, and link it based on SupervisorID = EmpID. Then show the emp name from the second emp basic table, that will be the name of the supervisor.

2 Likes
3

Ugh, I feel like a dummy. Thanks Nate, that took care of it.

1 Like
4

Woo! No worries. Happy to help.