Display Employees Who Haven't Clocked In

Epicor ERP 10
1

Has anyone created a query that would show an employee record for each day even if no header record exists? Let’s say I have a date range from 3/5-3/6 and employee 123 did not clock both days. I still want two rows to be returned for each day even if there are no related LaborHed records. Is what I’m describing even possible in a BAQ? If I do an outer join it will return the employee record once because the EmpBasic table doesn’t know about that date range.

Thanks,

Ted

2

image
image.png881×571 13.2 KB

You mean something like this? Each line is an employee, I just have the column reduced to sanitize names.

3

I see, you made a pivot for each day of the week and have employees listed as rows. That may work for this, in the end it will be a hard copy report.

Thanks.

4

Yeah, I made calculated fields for the total labor for each day of the week. Then further to the right I’ve got the breakout of it by labor type per day. The whole thing is filtered by supervisor to make it a bit more manageable.

It takes whatever date you enter and returns data from the week it is contained in so it isn’t the most flexible but I’m sure it could be made with different criteria.

5

Dear Lucasn

May you share me your BAQ?

I will very appreciate it~~