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!
Sales Order number "To be Generated"
Since NetSuite lacks a unique identifier for each itemline from a Sales Order, I need to create it myself
I decided to use a concatenation of the internal id + a random generated number between one and one billion.
In order to do so, I used a post-submit server side script:
function generateRadId() { var lineitemcount = nlapiGetLineItemCount('item'); var internalid = nlapiGetRecordId(); for (var i = 0; i < lineitemcount; i++) { var linenumber = eval(i+1); var randomnumber = Math.floor(Math.random()*1000000001); var generatednumber = eval(internalid+randomnumber); nlapiSetLineItemValue('item', 'custcol_radid', linenumber, generatednumber); debug(generatednumber); } function debug(str) { nlapiLogExecution('DEBUG', 'debug', str) } } But this does not seem to set the custcol_radid field. Any ideas on how to solve this issue?
0