Skip to Content
0
R S
Aug 05, 2023 at 04:18 AM

FMS query not working

51 Views

Hi

I have below FMS. I want if Vendor Code is '123' then Udf field should be blank else it should get GstNo

select distinct GSTRegnNo from crd1 where crd1.CardCode=$[opch.cardcode]

and crd1.address=$[opch.shiptocode]

case

when $[opch.cardcode] = '29' then U_GstNo = ''

Thanks