United will terminate Ferguson's ambassador role at the end of the season.