It's possible that @alien4u is right and the newRecord object doesn't have the tranid yet. But since you need to load the record anyway, perhaps you should load it first and query the tranid from that object.