Returning a Boolean Value from a NetSuite Formula

Sharing is Caring

When creating a NetSuite Formula field for a report, saved search, or a SuiteAnalytics report you will at some point need to create a field that returns a boolean value.

In NetSuite, the formula fields use a different value than true or false or 1 or 0. Instead of returning true or false or 1 or 0, you must return ‘T’ or ‘F’.

T = true
F = false

Sharing is Caring

Brian is a software architect and technology leader living in Niagara Falls with 13+ years of development experience. He is passionate about automation, business process re-engineering, and building a better tomorrow.

Brian is a proud father of four: two boys, and two girls and has been happily married to Crystal for more than ten years. From time to time, Brian may post about his faith, his family, and definitely about technology.