CASE WHEN {type} = 'Estimate' THEN {tranid} ELSE NULL END

- is this not valid for finding Estimates? It works for the Sales Order, but on the same search, they also want the doc number of the last Quote as a separate column. They could be unrelated transactions.

{transaction.type}

If Rusty's suggestion doesn't work, try switching null to ''.

Thank you! I will try these and let you know!

what are your search criterias?

@Nicolas Bean I got it to work by replacing NULL with ' '.

nice!

Thanks everyone! 🙂