I have slept with a few of my female friends and we are still close friends so I'd say it doesn't always ruin friendships on occasions it can make things better.
I think it depends on the level of friendship. Harry & Sally were BEST friends, and in cases like that, yeah, it will mess up a friendship when one person wants more than just one night together.