hdeshev
07/27/2018, 8:27 AMYou have entered an Invalid Field Value ERROR: Invalid Expression for the following field: custbody_reverse_charge
CASE WHEN ({subsidiary.country} <> {entity.address.country}) AND
({subsidiary.country} IN ('United Kingdom', 'France')) AND ({entity.address.country} IN ('Netherlands', 'Luxembourg', 'Estonia', 'Lithuania', 'Hungary', 'Belgium', Portugal', 'United Kingdom', 'Slovakia', 'Croatia', 'Czechia', 'Italy', 'Finland', 'Poland', 'Malta', 'Germany', 'Slovenia', 'Romania', 'Bulgaria', 'Austria', 'Sweden', 'Cyprus', Denmark', France', 'Ireland', 'Spain', 'Greece', 'Latvia'))
THEN TRUE
ELSE FALSE
END
I am able to work around it by using an "always checked" custom field for the true
case, and NULL
for the false
one. This works:
CASE WHEN ({subsidiary.country} <> {entity.address.country}) AND
({subsidiary.country} IN ('United Kingdom', 'France')) AND ({entity.address.country} IN ('Netherlands', 'Luxembourg', 'Estonia', 'Lithuania', 'Hungary', 'Belgium', Portugal', 'United Kingdom', 'Slovakia', 'Croatia', 'Czechia', 'Italy', 'Finland', 'Poland', 'Malta', 'Germany', 'Slovenia', 'Romania', 'Bulgaria', 'Austria', 'Sweden', 'Cyprus', Denmark', France', 'Ireland', 'Spain', 'Greece', 'Latvia'))
THEN {entity.custentity_true_field}
ELSE NULL
END
Is there a better solution here? I'd love to get rid of the "always checked" field!