Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Need help with a script please
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 0