```var salesorderSearch = nlapiSearchRecord("sales...
# suitescript
n
Copy code
var salesorderSearch = nlapiSearchRecord("salesorder",null,
[
   ["type","anyof","SalesOrd"], 
   "AND", 
   ["trandate","onorafter","startoflastfiscalyear"], 
   "AND", 
   ["mainline","is","T"], 
   "AND", 
   ["closed","is","F"], 
   "AND", 
   ["status","noneof","SalesOrd:C","SalesOrd:H","SalesOrd:A","SalesOrd:B"], 
   "AND", 
   ["linesequencenumber","equalto","0"]
], 
[
   new nlobjSearchColumn("trandate",null,"GROUP").setSort(true), 
   new nlobjSearchColumn("formulanumeric",null,"SUM").setFormula("1")
]
);