Conditional Formatted Search

[Former Member]

We have a formatted search in Sales Order to pull the Ship To Code from Sales Quotation based on the line #. But we want the formatted search NOT to happen for certain customers.

How can we write a conditional formatted search so that when this condition is met, this formatted search does NOT carry out?

thanks!

[Former Member · Accepted solution]

Hi Yi Liao,

try to use IF ELSE condition in the query.

cheers,

erwine