Epicor 9.04 BAQ JobReleased not working

(Randy) #1

This query is returning jobs that have not been released. Any idea why?

for each JobHead no-lock where JobHead.JobComplete = 0 And JobHead.JobReleased = 1

(Nathan your friendly neighborhood Support Engineer) #2

as in, the query is returning results where JobReleased=0?

(Randy) #3

It’s returning only Planned Jobs no matter if it’s 0 or 1

(Randy) #4

turns out in v9.04 you need this:
JobHead.JobReleased <> “1”

Strange. It’s not that way in later versions.