var transactionSearchObj = search.create({
type: "transaction",
settings:[{"name":"consolidationtype","value":"ACCTTYPE"}],
filters:
[
[["type","anyof","SalesOrd"],"AND",["cogs","is","F"],"AND",["shipping","is","F"],"AND",["formulanumeric: case when ({item.type}NOT IN('Inventory Item','Kit/Package','Assembly') AND {item.isfulfillable} ='T' AND ({quantity} - nvl({quantityshiprecv},0)) >0 ) THEN 1 when {item.type}IN('Inventory Item','Kit/Package','Assembly') AND {quantitypicked}!={quantity} AND {quantitycommitted}>0 then 1 else 0 end","equalto","1"],"AND",["taxline","is","F"],"AND",["status","noneof","SalesOrd:A","SalesOrd:G","SalesOrd:H","SalesOrd:C","SalesOrd:F"],"AND",["mainline","is","F"],"AND",["closed","is","F"]]
],
columns:
[
search.createColumn({
name: "trandate",
summary: "GROUP",
label: "Date"
}),
search.createColumn({
name: "tranid",
summary: "GROUP",
label: "Document Number"
}),
search.createColumn({
name: "entity",
summary: "GROUP",
label: "Name"
}),
search.createColumn({
name: "shipto",
summary: "GROUP",
label: "Ship To"
}),
search.createColumn({
name: "shipmethod",
summary: "GROUP",
label: "Ship Via"
}),
search.createColumn({
name: "statusref",
summary: "GROUP",
label: "Status"
}),
search.createColumn({
name: "item",
summary: "GROUP",
label: "Item"
}),
search.createColumn({
name: "lineuniquekey",
summary: "GROUP",
label: "Line Unique Key"
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;