Azi
03/04/2021, 5:36 PMbattk
03/04/2021, 5:41 PMSciuridae54696d
03/04/2021, 6:15 PMvar vendorpaymentSearchObj = search.create({
type: "vendorpayment",
filters: [
[
"type", "anyof", "VendPymt"
],
"AND",
[
"custbody_9997_pfa_record", "anyof", context.newRecord.id
],
"AND",
[
"mainline", "is", "F"
]
],
columns: [
search.createColumn({ name: "currency", summary: "GROUP", join:"appliedtotransaction", label: "Currency" }),
search.createColumn({ name: "creditfxamount", summary: "GROUP",join:"appliedtotransaction", label: "Amount (Foreign Currency)" }),
search.createColumn({ name: "formulacurrency", summary: "SUM", formula: "{appliedtotransaction.creditfxamount}*{appliedtotransaction.exchangerate}", label: "Amount (Bank Currency)" }),
search.createColumn({ name: "statusref", summary: "GROUP", join:"appliedtotransaction", label: "Status" })
]
})
the general idea is in these searches you can do joins, in this case i'm getting Bill level information on a Bill Payment search
The joins work both ways, so I'd create a transaction search with these fields and joins and figure out what you need