If anyone can tackle this I would be eternally grateful.
I am bringing in Sales Orders from an email parsing integration. Often times the email has a sloppy shipping address. I would like to be able to see if the address label, from the customer record, is in the shipping address of the created sales order. I can get this field value from a saved search using the below formula:
case when (INSTR({shipaddress}, {customermain.addresslabel}) > 0) then {customermain.addressinternalid} else null end
Any ideas on how I would use the above value to set the Ship To on the sales order?