Hi
What is wrong with this query
SELECT Declare @tax as varchar(20)
Declare @group as varchar(20)
Declare @service as varchar(20)
Set @tax=($[$38.160.0])
Set @group=($[$38.U_It_Group.0])
Set @service=($[$38.U_Type.0])
SELECT CASE
WHEN (@tax = 'BD+CST2') and (@group = '104') then '4101001'
WHEN (@tax = 'BDCSTSC') and (@group = '104') then '4101001'
WHEN (@tax = 'BDCST5') and (@group = '104') then '4101001'
WHEN (@tax = 'BDCST5.5') and (@group = '104') then '4101001'
WHEN (@tax = 'BD+VAT4') and (@group = '104') then '4101003'
WHEN (@tax = 'BDVTSC') and (@group = '104') then '4101003'
WHEN (@tax = 'BDV13.75') and (@group = '104') then '4101003'
WHEN (@tax = 'BDVT5SC') and (@group = '104') then '4101003'
END
It is giving me internal error . I am doing this to change g/l account in invoice . secondly i want to know when this fms should fire.
Thanks