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

My syntax is working fine
select tranid,status from transaction
where type='SalesOrd'
and trunc(transaction.createddate) = trunc(SYSDATE)
and status = "B"

until I've added status = "B".
What is the trick to use Status ?

Status is typically something like `"SalesOrd:B"`

When reading from the results of the query, it can be like `"B"` , but as criteria it should be the longer version