[SererraMike Contributions: 0Level 1☆]

Working on a sales order saved search. It doesn't look like I can return the "Billing Status" value that's available in the criteria tab. So I wanted to use a formula to return a 1 or 0 depending on if there is a billing transaction.

The formula I'm using is:

Code:
CASE WHEN ({billingtransaction} is Null) then 1 else 0 end
I've tried changing "is" to "=", tried wrapping "null" in '', and every combo I can think of. I just can't get it to return a 1 no matter what. Can anyone help?

Thanks in advance,

Mike
This is a cached copy. Click here to see the original post.

[carl.billings Contributions: 0Level 1☆]

What about the Amount Unbilled?

[Dew Contributions: 0Level 1☆]

Oh, the inconsistencies of NetSuite… Try

Code:
CASE WHEN ({billingtransaction}=' ') then 1 else 0 end
That's 2 single quotes wrapping a space.

By the way, that works for the line level, not Main Line.

[Author]

Posts