=IIf([Customer.AcctCD] = 'A123', 'John Smith', [ShippingContact.Salutation])
All, we’ve had an issue bugging us for over a year. Long story short -- for customer ‘A123’, we have contact ‘Jane Doe’ appearing as the shipping contact on the invoices. Jane Doe left A123 years ago but still appears on the invoices. I’ve hunted her down in contacts, leads, business/customer accounts, shipping tabs etc and can not find a trace of her.
So I’m trying to “hard code” our invoice -- if Customer = A123, then display value is John Smith (the correct contact); otherwise, just use the usual [ShippingContact.Salutation].
This works for A123 invoices… John Smith now appears! Great!
Now the issue is all non-A123 invoices leaves a <blank> Shipping Contact. :/
Do I need to use a visible expression instead?
