var columns=[
    	             search.createColumn({name: "tranid", label: "movementId"}),
    	             search.createColumn({name: "item",sort: search.Sort.DESC,label: "sku"}),
    	             search.createColumn({name: "location", label: "warehouse"}),
    	             search.createColumn({name: "trandate",sort: search.Sort.DESC,label: "timestamp"}),
    	             search.createColumn({
    	                name: "formulatext",
    	                formula: "'ADJUSTMENT'",
    	                label: "movementType"
    	             }),
    	             search.createColumn({name: "quantity", label: "delta"}),
    	             search.createColumn({name: "memomain", label: "notes"}),
    	             search.createColumn({
    	                name: "formulatext1",
    	                formula: "CASE WHEN {createdfrom.type} = 'Purchase Order' THEN {createdfrom.otherrefnum} END",
    	                label: "asnID"
    	             })
    	             ];
    	var filters=[
    	             ["type","anyof", "InvTrnfr"],
	    		      "AND", 
                      ["item.custitem_lb_customer_segment","anyof","669"], 
	    		      "AND", 
	    		      ["location","anyof",locationId]
    	             ];
    	if(from_time&&from_time!=""){
    		filters.push("AND",["trandate","onorafter",from_time])
    	}
    	if(to_time&&to_time!=""){
    		filters.push("AND",["trandate","onorbefore",to_time])

    	}

    	   var searchObj = search.create({
        	   type: "transaction",
        	   filters:filters,
        	   columns:columns
        	});
   		var searchResultCount = searchObj.runPaged().count;

   		log.debug("searchObj result count",searchResultCount);