Roy went to the southern lands, died there, and still was bound to the northern section of the afterlife. It didn't matter where he lived or worshipped, only where he was from.
We've seen nothing to indicate that you can change your afterlife destination aside from failing to live up to your alignment.