This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I've tried using the BUILTIN.DF and using the display names but it doesn't seem to do it.  Any recommendations on other formats to try for querying certain transaction statuses?

Does the integration user being used on your rest api call have access to PO's?

I've had some issues on some SuiteQL call when doing them via the native REST API, however, it returns an error not no records.  And when that happens I run it through a restlet instead.

This is how i have a similar query but for SO's that works for me via the native rest api endpoint.

```Transaction.Type IN ('SalesOrd') AND (BUILTIN.DF(Transaction.Status) IN ('Sales Order : Pending Fulfillment'))```

Probably not the issue since it looks like Israel is doing it the same way successfully, but have you tried with just D, F, B, etc without the PurchOrd in front? When you query that field through an IDE via SQL, the PurchOrd piece isn't in the field, it's just the letters.

It is interesting because when I tried just the D, F, B in the SuiteQL Query Tool in NetSuite it didn't error but didn't return results, but then using the D, B, F etc in a REST API request did work that way.  Think I'm good, thanks all!