BAQ syntax help

Epicor ERP 9
1

Epicor 9.05.701

I think the below syntax (in a BAQ calculated field) is fairly explanatory…it works out the ASSY2 part fine, but doesn’t do anything for ASSY1…it must be something to do with my syntax near “AND”?

IF(JobOper.OpCode = “A2DAS2” OR
JobOper.opcode = “ASMAS2” OR
JobOper.opcode = "T2SAS2"then “Assy2” else “”) AND

IF(JobOper.OpCode = “A2DAS1” OR
JobOper.opcode = “ASMAS1” OR
JobOper.opcode = "T2SAS1"then “Assy1” else “”)

Many thanks in advance.

2

IF(JobOper.OpCode = “A2DAS2” OR
JobOper.opcode = “ASMAS2” OR
JobOper.opcode = "T2SAS2"then “Assy2” else IF(JobOper.OpCode = “A2DAS1” OR
JobOper.opcode = “ASMAS1” OR
JobOper.opcode = "T2SAS1"then “Assy1” else “”))

2 Likes
3

worked a treat. Thank you.