Server Script :
Continue reading Adding and Removing Line Items
Tag: Netsuite
Netsuite : Saved Search grouping by … and then Count …
Suppose there are senario where you want to know the cases closed by all users in the last month
In criteria you can give the date range but in results you want to group by and then count all
— Assigned To — Group
— Number — Count
Netsuite : Saved search that extracts data for a list
In case where you have a list(comma delimited) and needs to extract data from Netsuite then this search can be used
Create a New search and in criteria choose Formula Numeric and then enter condition
– CASE WHEN (INSTR(‘list‘, {field} )<>0) THEN 1 ELSE 0 END
– Formula(Numeric) = equal to
– Value = 1
List : comma delimited list that needs to be extracted
field : The netsuite field the list value belongs to
EX : CASE WHEN (INSTR(‘david.nicholson@2ergo.com 2davidbrent@gmail.com’, {email} )<>0) THEN 1 ELSE 0 END