Catalyzes the reduction of all-trans-retinal to all-trans-retinol in the presence of NADPH. all-trans-retinol + NADP(+) = all-trans-retinal + H(+) + NADPH In the retina, expressed in cone but not rod outer segments. Belongs to the short-chain dehydrogenases/reductases (SDR) family.