NS12345
01/24/2020, 4:09 PMvar 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")
]
);