Alternate keys in Dataverse: when they save you and when they bite

A client wanted their billing system to push invoice updates into Dataverse. Their invoice numbers were the canonical identifier on their side - six digits, globally unique, never reused. Our instinct