You Never Can Tell

An ex-police/army dog (German Shepherd), named Rex inherits a fortune from an eccentric millionaire. But someone poisons him for his fortune, and he gets to go back to earth as a human detective to bring his killer to justice, and protect the girl who used to look after him. (imdb)