Skip to Content
0
Former Member
May 18, 2010 at 11:30 AM

FMS

92 Views

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