Home

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
Cancel
1 Answer(s)

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

Cancel
Intermediate Answered on April 22, 2020.

butterflyeffect

Thanks it is work

on April 23, 2020.
Cancel
Add Comment
Cancel

Your Answer

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