This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```CASE WHEN ( (1 &lt; NVL({quantityonhand},0) ) AND  (NVL({quantityonhand},0) &lt; 6  ) ) 
THEN 1 ELSE 0 END```


nm  it was an extra parent, sometime you just have to be willing to embarass yourself in order to look closely enough at your own work! thanks

I can't tell you how often I reach out to a coworker about something and then in the process of explaining it figure out what I've been spinning my wheels on for an hour.

1 million times? Right? That's my experience :grin:

that is so accurate - so many times i'm typing up on slack trying to describe the issue and suddently something clicks and all of a sudden the issue makes sense!