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

Can i write a case when for my sales orders that dont have every item committed yet?

How do I examine every line of a sales order in a saved search?

You could examine the lines individually (as long as `MainLine=F` ), and have a formula column that returns 0 when fully committed and 1 when not.  Then group by document number and sum on that formula.  That would tell you how many lines are not fully committed.

`CASE WHEN {quantity} - NVL({quantitycommitted},0) &gt; 0 THEN 1 ELSE 0 END`, that's a start;  you might have problems with lines that are completely filled already, could add more conditions to that.  Depends what your sales orders are like and hopefully restricting the base data set down more in the crieria.