When to tell our 6 year old

Tashana
I had the idea of telling our daughter at our first sono appointment when I will be 12 weeks 2 days. My husband is apprehensive due to a friend of ours going to her first sono and them telling her there was no heartbeat. Any thoughts or experiences with this? Thank you!