Skip to Content
0
Former Member
Dec 06, 2008 at 04:28 AM

Please help in writing FMS

18 Views

Dear all,

I have added an UDF in Business partner header namely Tax Liable. I am tring to write an FMS query so that when ever the user selects the tax defination it should updates the given UDF. if the user selects Tax liable option it should updates Y or else N. I wrote the query but it retrives list of records. My query is as follows

Select

(case

when ocrd.vatstatus = 'Y' then 'Y'

when ocrd.vatstatus = 'N' then 'N'

end)

FROM dbo.OCRD

Thanks

Tavargeri Ganesh