var salesorderSearchObj = search.create({
   type: "salesorder",
   filters: [
      ["type","anyof","SalesOrd"], 
      "AND", 
      ["status","noneof","SalesOrd:C"], 
      "AND", 
      ["mainline","is","T"], 
      "AND", 
      ["type","anyof","SalesOrd"]
   ],
   columns: [
      "tranid",
      search.createColumn({
         name: "trandate",
         sort: search.Sort.ASC
      }),
      "netamountnotax",
      "salesrep",
      search.createColumn({
         name: "custentity_nn_account_sub_industry",
         join: "customerMain"
      }),
      search.createColumn({
         name: "custentity_nn_area",
         join: "customerMain"
      }),
      search.createColumn({
         name: "formulatext",
         formula: "{customermain.custentity_nn_account_sub_industry}"
      })
   ]
});
salesorderSearchObj.run().each(function(result){
   return true;
});