Forums › Cached › Customization › Searches / List Views

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

  • Author
    Posts
  • February 2, 2017 at 10:06 am #22948 Score: 0

    kshaffer
    • Contributions: 0
    • Level 1
    • ☆

    I need to create a search that will default the quantity available on drop ship items to 50 but leave everything else alone. In the Channel Advisor system I accomplish it with SELECTCASE(($dropshipitem ="T"),"50", $CallForPrice = "T","0",$quantity). I am trying to recreate that in Netsuite. I tried CASE WHEN {isdropshipitem}=T THEN ’50’ WHEN {custitem_call_for_price}=T THEN null ELSE {quantityavailable} END. This does not work. Does anyone have any suggestions on what else I try? Thanks much!
    This is a cached copy. Click here to see the original post.

  • February 2, 2017 at 3:54 pm #22949 Score: 0

    michoel
    • Contributions: 0
    • Level 1
    • ☆

    You need to surround the string literals with quotation marks –

    Code:
    CASE WHEN {isdropshipitem} = 'T' THEN '50' WHEN {custitem_call_for_price} = 'T' THEN NULL ELSE {quantityavailable} END

  • February 6, 2017 at 7:56 am #22950 Score: 0

    kshaffer
    • Contributions: 0
    • Level 1
    • ☆

    Thank you, I will give this a try! Much appreciated.

  • Author
    Posts

You must be logged in to reply to this topic.