Updateable BAQ - LaborDtl - Error "A valid Job Number is required"

Epicor ERP 10
,
1

I created what I thought was a simple updateable BAQ to update a blank status on a LaborDtl record. Uses LaborHed, LaborDtl, Employee. Only LaborDtl.TimeStatus is checked as updateable.

Analyze comes back okay but when I do Get List, update the field an E and click Update, I get an error of “Severity: Exception, Table: LaborDtl, Field: , RowID: 61d4248d-ee65-475f-8dc5-1e497b09ca9e, Text: A valid Job Number is required”

Any suggestions as to what I am doing wrong?

Here’s the “SQL”:
/*

  • Disclaimer!!!
  • This is not a real query being executed, but a simplified version for general vision.
  • Executing it with any other tool may produce a different result.
    */

select
[LaborDtl].[JobNum] as [LaborDtl_JobNum],
[LaborDtl].[ClockInDate] as [LaborDtl_ClockInDate],
[LaborDtl].[ClockinTime] as [LaborDtl_ClockinTime],
[LaborDtl].[LaborType] as [LaborDtl_LaborType],
[LaborDtl].[TimeStatus] as [LaborDtl_TimeStatus],
[LaborDtl].[LaborQty] as [LaborDtl_LaborQty],
[LaborDtl].[LaborHrs] as [LaborDtl_LaborHrs],
[LaborDtl].[EmployeeNum] as [LaborDtl_EmployeeNum],
[EmpBasic].[Name] as [EmpBasic_Name],
[LaborHed].[LaborHedSeq] as [LaborHed_LaborHedSeq],
[LaborDtl].[LaborHedSeq] as [LaborDtl_LaborHedSeq],
[LaborDtl].[LaborDtlSeq] as [LaborDtl_LaborDtlSeq],
[LaborDtl].[PostedToGL] as [LaborDtl_PostedToGL]
from Erp.LaborHed as LaborHed
inner join Erp.LaborDtl as LaborDtl on
LaborHed.Company = LaborDtl.Company
and LaborHed.LaborHedSeq = LaborDtl.LaborHedSeq
and ( LaborDtl.JobNum = ‘SJ-008696’ and LaborDtl.PostedToGL = 0 )

inner join Erp.EmpBasic as EmpBasic on
LaborDtl.Company = EmpBasic.Company
and LaborDtl.EmployeeNum = EmpBasic.EmpID
order by LaborDtl.ClockInDate, LaborDtl.ClockinTime, LaborDtl.EmployeeNum

2

@jgreenaway Here is mine that works. I did not have any not posted to the gl, so that condition is not there.
COMP01-FixLaborDtl_E10.baq (33.9 KB)

2 Likes
3

Thanks Greg!

1 Like