I have a transaction search with work orders, tran...
# general
m
I have a transaction search with work orders, transfer orders, and sales orders. How would I set a criteria to only run on the transfer orders? I want to set 'transaction line type' = 'Item', but doing so gets rid of all my WO and SO data. I would like for that criteria to only run on TOs if possible. Thank you!
d
You can either enable the 'use expressions' option to link multiple criteria:
Copy code
(( transaction line type = item AND
   type = Transfer Order ) OR
  type = {one of} Sales Order, Work Order )
Or you can use a 'formula (numeric)' field with a formula like
CASE WHEN {type} = 'transfer order' AND {transaction line type} = 'item' THEN 1 ELSE 0 END
(equal to 1) ☝️ untested pseudo code
🙌 1
let us know how you get on
m
can't believe I blanked on that! the first use expressions portion was exactly what I needed, thank you!! I used formula(numeric) a bunch of different ways and couldn't get the results I wanted.