The following Formulas can be used for this search. The user should use the formula numeric as it is compatible only with it. It should be used in the criteria to get the result. CASE WHEN {internalid} IN (1111, 2222, 3333) THEN 1 ELSE 0 END CASE WHEN {internalid} = any(1111, 2222, 3333) THEN 1… Continue reading How to search Multiple Items using Item Name
Tag: search formula
Compare Address Fields on Entity and Transaction
Use case: This Solution can be used when we cannot get an exact match between Address text (Ship To address as referred here) in both transaction and customer, but can essentially compare between the address fields in the subrecord. Sample Scenario: When creating a Customer record, we often enter a default address. This default address is… Continue reading Compare Address Fields on Entity and Transaction