Hi All, I have written my first script with some help from examples on this forum, the script fires via a workflow button and generates a Sales Order.
This all works fine but I need to capture the tranid to link onto a field in a custom record, the button sits originally on that custom record.
my code is below, can anyone suggest how I go about catching the Sales Order tranid field in order to populate it back into the field.
function CreateSO() { var newRec = nlapiGetNewRecord(); var customer = newRec.getFieldValue('custrecord_sb_customer'); //Capture location var record = nlapiCreateRecord('salesorder'); record.setFieldValue('entity', customer); record.setFieldValue('otherrefnum', 01); record.setLineItemValue('item','item',1,3811) var id = nlapiSubmitRecord(record, true); } I had tried adding the below to the end of the code after the submitrecord but it seemed to only capture 'To be Generated' so i am gussing I am doing it in the wrong order.var tranid = id.getFieldValue('tranid'); newRec.setFieldValue('custrecordsb_tranid', tranid);Thanks for anyone who helps.Ben H