search for sales order using external id

Hi every one,

when i search for sales orders i usually using this formula text in criteria

CASE WHEN {NUMBER} IN (‘SOR004312623‘) THEN ‘1’ ELSE ‘0’ END

but if i have sheet with external number instead of sales order number how i can modifiey it to find the sales order ?

 

Rookie Asked on April 22, 2020 in Saved Searches.
Add Comment
1 Answer(s)

Just change NUMBER to whatever the field for external id is?

Beginner Answered on April 22, 2020.

Thanks it is work

on April 23, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors: Tipalti