Hi
Declare @tax as varchar(20)
Declare @group as varchar(20)
Set @tax=($http://$38.160.0)
Set @group=($http://$38.U_It_Group.0)
SELECT CASE
WHEN (@tax = 'BD+CST2') and (@group = '104') then '4101001'
WHEN (@tax = 'BDCSTSC') and (@group = '104') then '4101001'
WHEN (@tax = 'BDV13.75') and (@group = '104') then '4101003'
WHEN (@tax = 'BDVT5SC') and (@group = '104') then '4101003'
END
Can anybody tell me when this FMS should fire. . I have used this query in A/R Invoice to change G/L Account.
Thanks