Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Help with Item Quantity Search
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!
0