Skip to Content
0
Former Member
Dec 03, 2008 at 05:51 AM

updation of tax code through formated search

20 Views

Dear All,

I have written a small query but it is giving some problem. The query is as follows

select

(case

when A.debpayacct = '_SYS00000000043' and A.vatstatus = 'Y' then c.vatgroup = 'S1-LB'

when A.debpayacct = '_SYS00000000043' and A.vatstatus = 'N' then c.vatgroup='S2-LB'

when A.debpayacct = '_SYS00000000044' and A.vatstatus = 'Y' then c.vatgroup='S1-LD'

when A.debpayacct = '_SYS00000000044' and A.vatstatus = 'N' then c.vatgroup='S2-LD'

end)as

FROM OCRD A JOIN ORDR B ON A.CardCode = (select $[b.cardcode])

join rdr1 C on B.docentry = C.docentry

Thanks & regards

Tavargeri Ganesh