Forums › Cached › Customization › Searches / List Views

This topic contains 2 replies, has 0 voices, and was last updated by Dew 6 years, 8 months ago.

  • Author
    Posts
  • February 20, 2018 at 9:28 am #22564 Score: 0

    SererraMike
    • Contributions: 0
    • Level 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.

  • February 20, 2018 at 10:31 am #22565 Score: 0

    carl.billings
    • Contributions: 0
    • Level 1
    • ☆

    What about the Amount Unbilled?

  • February 20, 2018 at 2:12 pm #22566 Score: 0

    Dew
    • Contributions: 0
    • Level 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

You must be logged in to reply to this topic.