NetSuite Suitescript code for creating saved search that could only fetch the Item Fulfillments which are not received yet.
search.create({
type: "transferorder",
settings:[{"name":"consolidationtype","value":"ACCTTYPE"}],
filters:
[
["mainline","is","F"],
"AND",
["taxline","is","F"],
"AND",
["cogs","is","F"],
"AND",
["shipping","is","F"],
"AND",
["type","anyof","TrnfrOrd"],
"AND",
["numbertext","is","TOFNA25000304"],
"AND",
["applyingtransaction.type","anyof","ItemShip"],
"AND",
["applyingtransaction.applyingtransaction","anyof","@NONE@"]
],
columns:
[
search.createColumn({
name: "internalid",
join: "applyingTransaction",
summary: "GROUP",
label: "Internal ID"
}),
search.createColumn({
name: "type",
join: "applyingTransaction",
summary: "MAX",
label: "Type"
}),
search.createColumn({
name: "tranid",
join: "applyingTransaction",
summary: "GROUP",
label: "Document Number"
}),
search.createColumn({
name: "statusref",
join: "applyingTransaction",
summary: "MAX",
label: "Status"
}),
search.createColumn({
name: "applyingtransaction",
join: "applyingTransaction",
summary: "MAX",
label: "Applying Transaction"
})
]
});