
Script
var customrecord_jj_commission_report_phrin6SearchObj = search.create({
type: "customrecord_jj_commission_report_phrin6",
filters:
[
["custrecord_jj_approval_status_id","anyof","3"],
"AND",
["isinactive","is","F"],
"AND",
["custrecord_jj_sales_rep_name.supervisor","anyof","@CURRENT@"]
],
columns:
[
search.createColumn({name: "custrecord_jj_commission_year", label: "Year"}),
search.createColumn({name: "custrecord146", label: "Month"}),
search.createColumn({name: "custrecord_jj_sales_rep_name", label: "Sales Rep"}),
search.createColumn({name: "custrecordjj_monthly_quota", label: "Monthly Quota"}),
search.createColumn({name: "custrecordjj_quota_achived", label: "Monthly Sales Amount"}),
search.createColumn({name: "custrecord_jj_commission_percentage_get", label: "Commission Percentage"}),
search.createColumn({name: "custrecord_jj_commisssion_amount", label: "Commission Amount"}),
search.createColumn({name: "custrecord_jj_new_account_goal", label: "New Account Goal"}),
search.createColumn({name: "custrecord_jj_new_account_count", label: "New Account Number"}),
search.createColumn({name: "custrecord_jj_quarter_bonus_amt", label: "Bonus Amount"}),
search.createColumn({name: "custrecord_jj_approval_status_id", label: "Approval Status"})
]
});
var searchResultCount = customrecord_jj_commission_report_phrin6SearchObj.runPaged().count;
log.debug("customrecord_jj_commission_report_phrin6SearchObj result count",searchResultCount);
customrecord_jj_commission_report_phrin6SearchObj.run().each(function(result){
// .run().each has a limit of 4,000 results
return true;
});
/*
customrecord_jj_commission_report_phrin6SearchObj.id="customsearch1724645256875";
customrecord_jj_commission_report_phrin6SearchObj.title="Sales Manager Approval - Commission Report Details (copy)";
var newSearchId = customrecord_jj_commission_report_phrin6SearchObj.save();
*/