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

image.png

Hi Everyone, I have an issue with filter the transactions by transaction status 'B'. However, the query shows no result while I could see the status as 'B' if I do not filter by status 'B'. Does anyone know how to filter the transaction by status in SuiteQL? Thank you in advance.

use the full id from <https://suiteanswers.custhelp.com/app/answers/detail/a_id/50165/|Transaction Status List of Internal IDs>

Thank you <@U5TF1GQ20> , I tried with the full id but it still returns no records.

NetSuite had some issue last time and returned no record from my previous screenshot, now I tried again, it shows the results as expected. Thank you so much for your help.

Still don't like the fact that we need to filter by full name, but returns the single character status. It is inconsistent.