update vs4tinventory set tinvdate=tinvdate-day(tinvdate)+1 where tinvtintalias='BEGINBALANCE'
--update vs4tinventory set tinvdate='1/1/2007' where tinvtintalias='BEGINBALANCE' and TINvTIBKCode<>'BEGINBALANCE'

update vs4tinventorymb set tinmtacptacyid=(select tinvtacptacyid from vs4tinventory where tinmtinvno=tinvno) where tinmtacptacyid is null
update vs4tinventorymb set TInMTACPID=(select TInMTACPID from vs4tinventory where tinmtinvno=tinvno) where TInMTACPID is null


