Anyone has insight as to why doing WHERE status = ‘B’ gives no results but doing WHERE status LIKE ‘%B’ gives expected results? Length of status is 1. Doing WHERE status LIKE ‘%B%’ gives very strange results.

Yes, this is one of Netsuite's fun little stinkers. Check out my answer regarding a way to approach this in SuiteQL, and more broadly Zig's article regarding transaction statuses, here.

Thank-you @Clay Roper! Little stinker is right. :-)

I had similar issue with type column. Try using

BUILTIN.DF(status)