Hi
I want to add condition if it is vendor XYZ then this FMS should not apply
select distinct GSTRegnNo from crd1 where crd1.CardCode=$[opch.cardcode]
and crd1.address=$[opch.shiptocode]
and AdresType='S'
Thanks