BAQ Needed for Job complete, not closed

[KRiley1039 (Karin Riley)]

Would anyone happen to know how to write BAQ for all jobs completed but not closed?

I’m new to Epicor and my SQL experience is slowly coming back to me. I was using ECI Solutions - M1 previously and I used this grid daily. I’d like to create a version in Epicor to help us ensure nothing is missed.

[d_inman (David Inman)]

Criteria on the JobHead table as such:
JobComplete = true
JobClosed = false

[Banderson (Brandon Anderson)]

Just posted about this here.

BAQ's

Your best place to start is in the tools user guide found in the help. (hit f1 when you are in a screen). If you’re on the BAQ screen it will bring to the general help, which is fine, you should still review that. But the tools guide does much better job showing you the mechanics of it. [image] And if you’re going to insights, come to my presentation. I’m going to be explaining some the “whys” behind the basics.

[gpayne (Greg Payne)]

Once you go over @Banderson guide this information is in the JobClosingLog table. If you use auto complete and auto close any jobs that can’t complete or close with an exception are here.