Provide the following code section in the console. if you don’t know the real field name, you can create the saved search by this method.
require([‘N/record’, ‘N/runtime’,’N/search’], function (record, runtime,search) {
var transactionSearchObj = search.create({
type: “transaction”,
title: ‘FXAdjustment’,
filters: [
[“posting”, “is”, “T”],
“AND”,
[“memorized”, “is”, “F”],
“AND”,
[“account.isinactive”, “is”, “F”],
“AND”,
[“account.type”, “anyof”, “OthCurrAsset”, “FixedAsset”, “OthAsset”, “OthCurrLiab”, “LongTermLiab”, “Bank”, “AcctRec”, “AcctPay”, “CredCard”],
“AND”,
[
[“sum(amount)”, “notequalto”, “0.00”],
“OR”,
[“sum(fxamount)”, “notequalto”, “0.00”]
]
],
columns: [
search.createColumn({
name: “line.cseg5”,
summary: “GROUP”,
label: “Fund Number”
}),
]
});
var searchId = transactionSearchObj.save();
console.log(‘searchId’,searchId)
});