Mark C
07/22/2022, 5:17 PMfunction salesCommissionInfoSearch(itemClassification) {
var salesCommissionMap = {};
var filteredItemClass = [];
if(itemClassification == 'fbm') {
filteredItemClass.push(['isinactive','is','F'])
filteredItemClass.push('AND')
filteredItemClass.push(['custrecord_br_commission_item_class', 'anyof', '1']) // 1 is FBM, EDI, WebStore
}
var salesCommissionSearch = searchModule.create({
type: 'customrecord_br_sales_commissions',
filters: [filteredItemClass],
columns: [
[searchModule.createColumn({name: 'custrecord_br_commission_weighted_pct', summary: searchModule.Summary.SUM})],
[searchModule.createColumn({name: 'custrecord_br_commission_weighted_per', summary: searchModule.Summary.SUM})]
]
});
salesCommissionSearch.run().each(function(result) {
var salesCommissionWeightedPct = parseFloat(result.getValue({name: 'custrecord_br_commission_weighted_pct', summary: searchModule.Summary.SUM}));
var salesCommissionWeightedPerUnit = parseFloat(result.getValue({name: 'custrecord_br_commission_weighted_per', summary: searchModule.Summary.SUM}));
iSuite
07/22/2022, 5:46 PMiSuite
07/22/2022, 5:46 PMcolumns: [
searchModule.createColumn({name: 'custrecord_br_commission_weighted_pct', summary: searchModule.Summary.SUM}),
searchModule.createColumn({name: 'custrecord_br_commission_weighted_per', summary: searchModule.Summary.SUM})
]
Try thatMark C
07/22/2022, 5:49 PMiSuite
07/22/2022, 5:50 PM