Title
#suitescript
al3xicon

al3xicon

01/05/2017, 2:21 PM
here's a snippet:
var filters = [
	   		["transaction.type","anyof","SalesOrd"],
			  	"AND",
			  ["transaction.shipping","is","F"],
			  	"AND",
			  ["transaction.taxline","is","F"],
			  	"AND",
			  ["transaction.mainline","is","F"],
			  	"AND",
			  ["transaction.status","anyof","SalesOrd:D","SalesOrd:E","SalesOrd:B"],
			  	"AND",
			  ["transaction.quantitycommitted","greaterthan","0"],
			  	"AND",
			  ["type","anyof","Assembly","InvtPart","Kit"],
			  	"AND",	
			  ["transaction.purchaseorder","anyof","@NONE@"],
			  	"AND",
			  ["transaction.department","noneof","18"],
			  	"AND"
			  ];
	    	
	    	if (mode == 'vendor') {
	    		filters.push([["vendor","anyof",vendor],"OR",["memberitem.vendor","anyof",vendor]]);