update vs4tinventorymb set tinmamouquantity=abs(tinmamouquantity) where 
(tinmtintalias='BEGINBALANCE' or tinmtintalias='LOTIN' or tinmtintalias='LOTINPOP' or tinmtintalias='LOTINPR' or tinmtintalias='LOTINPREPIUM'
or tinmtintalias='RECEIVEREPAIR' or tinmtintalias='RETURNISSUEUSE' or tinmtintalias='SALERETURN' or tinmtintalias='SENDREPAIRRETURN'
or tinmtintalias='STOCKADJUSTIN' or tinmtintalias='RECEIVEFGBUILTNOMRP')
GO

update vs4tinventorymb set tinmamount=abs(tinmamount) where
(tinmtintalias='BEGINBALANCE' or tinmtintalias='LOTIN' or tinmtintalias='LOTINPOP' or tinmtintalias='LOTINPR' or tinmtintalias='LOTINPREPIUM'
or tinmtintalias='RECEIVEREPAIR' or tinmtintalias='RETURNISSUEUSE' or tinmtintalias='SALERETURN' or tinmtintalias='SENDREPAIRRETURN'
or tinmtintalias='STOCKADJUSTIN' or tinmtintalias='RECEIVEFGBUILTNOMRP')
GO

UPDATE VS4TInventoryMB set tinminquantity=abs(tinmoutquantity) WHERE tinminquantity=0 and
(tinmtintalias='BEGINBALANCE' or tinmtintalias='LOTIN' or tinmtintalias='LOTINPOP' or tinmtintalias='LOTINPR' or tinmtintalias='LOTINPREPIUM'
or tinmtintalias='RECEIVEREPAIR' or tinmtintalias='RETURNISSUEUSE' or tinmtintalias='SALERETURN' or tinmtintalias='SENDREPAIRRETURN'
or tinmtintalias='STOCKADJUSTIN' or tinmtintalias='RECEIVEFGBUILTNOMRP')
GO

UPDATE VS4TInventoryMB set tinmoutquantity=0 WHERE tinminquantity<>0 and tinmoutquantity<>0 and
(tinmtintalias='BEGINBALANCE' or tinmtintalias='LOTIN' or tinmtintalias='LOTINPOP' or tinmtintalias='LOTINPR' or tinmtintalias='LOTINPREPIUM'
or tinmtintalias='RECEIVEREPAIR' or tinmtintalias='RETURNISSUEUSE' or tinmtintalias='SALERETURN' or tinmtintalias='SENDREPAIRRETURN'
or tinmtintalias='STOCKADJUSTIN' or tinmtintalias='RECEIVEFGBUILTNOMRP')
GO




