has anyone been able to filter by status? Like expired or open. Its field id is status on the record but status on the search is orderstatus.

should be possible. what are you experiencing? where are you trying to filter by status?

Trying to filter by status on a transaction search. Heres some screen shots of what I mean

Have you tried a formula field?

better to put that question in #C29HQS63G channel. I would be looking at the purchaseorder.status which I expect should be an internalid of the status or the full text of the status not "PurcahseOrd:G"

@pen one I did try the formula, its the same issue. @Netsuite Tragic sorry I am actually not looking for the purchase order status, that was just another filter I needed for the report. The code is a direct export of the search I created on the UI, so thats not the issue. I was just trying to show that status in the search is for whatever reason not the same as it is on the record. Even though they have the same fieldId.