I need to find customers with a last transaction date occurring before 1/1/2012 and update a custom field on the customer record. I've never used the getSummary function and need to know if the below java I have will work.
Thank you in advance!
function UpdateWinback() { var filters = new Array(); filters[0] = new nlobjSearchFilter('winback', null, 'isEmpty', null); filters[1] = new nlobjSearchFilter('date', null, 'Before','1/1/2012').getSummary(max); // Need to pull customers with a last transaction date before 1/1/2012 filters[2] = new nlobjSearchFilter('custentity_altslsrep', null, 'isNotEmpty', null); filters[3] = new nlobjSearchFilter('custentity_transitiondate', null, 'onOrBefore', 'custentity_transitiondate'); var columns = new Array() columns[0] = new nlobjSearchColumn('internalid'); columns[1] = new nlobjSearchColumn('entityid'); columns[2] = new nlobjSearchColumn('salesrep'); columns[3] = new nlobjSearchColumn('companyname'); columns[4] = new nlobjSearchColumn('firstorderdate'); columns[5] = new nlobjSearchColumn('custentity_transitiondate'); columns[6] = new nlobjSearchColumn('custentity_altslsrep'); columns[7] = new nlobjSearchColumn('date'); columns[8] = new nlobjSearchColumn('custentity_winback'); var results = nlapiSearchRecord( 'customer', null, filters, columns); nlapiLogExecution('DEBUG', 'Records to process: ' + (results == null ? "0" : results.length)); for (var i = 0; results != null && i < results.length; i++) { var rectype = results[i].getRecordType(); var internalid = results[i].getValue('internalid'); var entityid = results[i].getValue('entityid'); var salesrep = results[i].getValue('salesrep'); var altsalesrep = results[i].getValue('custentity_altslsrep'); var companyname = results[i].getValue('companyname'); var firstorderdate = results[i].getValue('firstorderdate'); var transitiondate = results[i].getValue('custentity_transitiondate'); var winback = results[i].getValue('custentity_winback'); nlapiSubmitField('customer', internalid, custentity_winback, 'T'); nlapiLogExecution('AUDIT', 'Record ' + (i + 1) + ': ' + entityid + ' - ' + companyname, 'InternalID: {' + internalid + '}<br>TransitionDate: {' + transdate + '}<br>AltSalesRep: {' + altsalesrep + '}<br>SalesRep: {' + salesrep + '}<br>Winback: {' + winback + '}<br>'); } }