BAQ Statement Help

Epicor ERP 9
1

Hello Everyone,

I need help to get this statement to work.
IF JobHead.CheckOff2 = “Y” and
JobHead.CheckOff3 = “Y” and
JobHead.CheckOff4 = “Y” then “READY” else " "

IF JobHead.CheckOff2 = “Y” and
JobHead.CheckOff3 = “Y” and
JobHead.CheckOff4 <> “Y” then “PLAN” else " "

Thanks in Advance.
Miguel

2

JobStatus.baq (21.4 KB)

Note - use single quotes, not double quotes.

case
when JobHead.CheckOff2 = 1 and
JobHead.CheckOff3 = 1 and
JobHead.CheckOff4 = 1
then ‘READY’
when JobHead.CheckOff2 = 1 and
JobHead.CheckOff3 = 1 and
JobHead.CheckOff4 <> 1
then ‘Plan’
else ‘’
end

3

Hello Bruce,

I don’t have the case logic available on Epicor 9. I also updated my statement to single quotes and when I run the test I get the same error message. (See Below)
image

Thank you.
Miguel