Specifying criteria for specific Job Numbers

Epicor ERP 10
1

I’m sure this is an easy question for most of you; however I am having difficulty specifying this in my BAQ.

I have a BAQ where I want to pull Job Numbers EXCEPT for Job Numbers that contain:
-R
-E
etc.

How and where do you specify NOT to choose something or to ignore fields that contain specific information?

Please note that I do not write any SQL code, I use the ‘Business Activity Query Designer’.

In advance thank you for your time (and patience).

Judy

2

image
image.png914×202 13.3 KB

Check the ‘Not’ box and use the LIKE Operation on the JobNum field. Your constant should be %-N% (% being the wild card)

3

I was so close!

Thank you so much for your help!

Back to my BAQ’s…:slightly_smiling_face: