Getting transactions between two trandate

/**
* Fetch transactions created between two dates
* @since 2015.2
*/
function getTransaction () {
try {
var transactionSearchObj = search.create({
type: "transaction",
filters:
[
["type", "anyof", "CustCred", "CustInvc"],
"AND",
["mainline", "is", "F"],
"AND",
["shipping", "is", "F"],
"AND",
["cogs", "is", "F"]
],
columns:
[
search.createColumn({
name: "custbody_eb_channel",
summary: "GROUP",
label: "Channel"
}),
search.createColumn({
name: "formulacurrency",
summary: "MAX",
formula: "SUM(CASE WHEN TO_CHAR({trandate}, 'YYYY/MM') BETWEEN '2022/01' AND '2022/06' THEN {amount} ELSE 0 END)",
label: "Formula (Currency)"
}),
search.createColumn({
name: "trandate",
summary: "GROUP",
label: "Date"
})
]
});
var searchResultCount = transactionSearchObj.runPaged().count;
log.debug("transactionSearchObj result count", searchResultCount);
transactionSearchObj.run().each(function (result) {
// .run().each has a limit of 4,000 results
return true;
});
}catch(err){
log.error("err @ search",err)
}

}

Leave a comment

Your email address will not be published. Required fields are marked *