My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Comments
-
following your case when statement.. here's how it should be, given that your fields are correct.. CASE WHEN {quantityavailable} > 0 THEN 'In Stock' WHEN NVL({quantityavailable},0)<=0) AND ( NVL({quantityonorder},0)<=0) THEN 'Out of Stock' WHEN (NVL({quantityavailable},0)<=0) AND ({quantityonorder} > 0) THEN 'Pending…
-
Hello, I am trying to create a custom item field called "Stock Status" that assigns free-form text values based on inventory levels for that item. The logic for this field is clear in my head, however, I have very little experience (i.e. no) experience in scripting or creating formula fields using SQL expressions. I have…