var vendorprepaymentSearchObj = search.create({
type: “vendorprepayment”,
settings:[{“name”:”consolidationtype”,”value”:”ACCTTYPE”}],
filters:
[
[“type”,”anyof”,”VPrep”]
],
columns:
[
search.createColumn({
name: “formulahtml”,
summary: “MAX”,
formula: “‘<a href=”/app/accounting/transactions//vprep.nl?id=’||{internalid}||'” target=”_blank”>View</a>'”,
label: “View”
}),
search.createColumn({
name: “trandate”,
summary: “GROUP”,
label: “Date”
}),
search.createColumn({
name: “transactionnumber”,
summary: “GROUP”,
label: “ID”
}),
search.createColumn({
name: “subsidiarynohierarchy”,
summary: “GROUP”,
label: “Subsidiary”
}),
search.createColumn({
name: “classnohierarchy”,
summary: “GROUP”,
label: “Class”
}),
search.createColumn({
name: “departmentnohierarchy”,
summary: “GROUP”,
label: “Cost Centre”
}),
search.createColumn({
name: “locationnohierarchy”,
summary: “GROUP”,
label: “Location”
}),
search.createColumn({
name: “tranid”,
summary: “GROUP”,
label: “Check #”
}),
search.createColumn({
name: “entity”,
summary: “GROUP”,
label: “Payee”
}),
search.createColumn({
name: “statusref”,
summary: “GROUP”,
label: “Status”
}),
search.createColumn({
name: “currency”,
summary: “GROUP”,
label: “Currency”
}),
search.createColumn({
name: “formulacurrency”,
summary: “SUM”,
formula: “MAX({amount})”,
label: “Amount”
}),
search.createColumn({
name: “amountpaid”,
summary: “SUM”,
label: “Applied Amount”
}),
search.createColumn({
name: “formulacurrency”,
summary: “MAX”,
formula: “MAX({amount})-SUM({amountpaid})”,
label: “Unapplied Amount”
}),
search.createColumn({
name: “tranid”,
join: “appliedToTransaction”,
summary: “MAX”,
label: “Purchase Order #”
}),
search.createColumn({
name: “statusref”,
join: “appliedToTransaction”,
summary: “MAX”,
label: “Purchase Order Status”
})
]
});
var searchResultCount = vendorprepaymentSearchObj.runPaged().count;
log.debug(“vendorprepaymentSearchObj result count”,searchResultCount);
vendorprepaymentSearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
/*
vendorprepaymentSearchObj.id=”customsearch1731650309906″;
vendorprepaymentSearchObj.title=”JJ Vendor Prepayment List (copy)”;
var newSearchId = vendorprepaymentSearchObj.save();
*/
