BAQ calculated field that looks to see if two fields are True

Epicor ERP 10
1

I would appreciate advice on a formula setup.
I would like to create a new calculated field in a BAQ which looks to see if both the OverridePriceList field and the LockPrice field each show True. If both are true, then I want to see True result, and if they both aren’t flagged as true then return a result of false.
Thank you

2

We don’t have any lines with any of these true for me to test, but it doesn’t bomb out, so it should work.

(case when QuoteDtl.OverridePriceList = 'true'  and QuoteDtl.LockPrice = 'true' then 'true' else 'false' end)

image
image.png1048×400 16.8 KB

3

Brandon,
thanks for the help, it worked.
My error was not using ’ ’ in each instance.

4

For a boolean (bit) field you should use 1 and 0 in SQL.

5

Don’t listen to him, he’s just mad that he didn’t get to the answer first…

But yes, true SQL is 1 and 0. Epicor will take either.

3 Likes
6

image

you messing with me stats man

5 Likes