This topic contains 2 replies, has 0 voices, and was last updated by rob@harkness 7 years, 1 month ago.

  • Author
    Posts
  • #21392

    rob@harkness

    If the following script returns the Work Order internal ID. Any ideas how getLineItemValue can be amended to return the WO tranid text value instead?

    Code:
    function userEventAfterSubmit(type){
    var a = nlapiGetRecordId();
    var x = nlapiLoadRecord('salesorder', a);
    var y = x.getLineItemCount('item');
    for(var i = 1; i <= y; i++){
    if(x.getLineItemValue('item', 'createwo', i)){
    x.setLineItemValue('item', 'custcol_work_order_id', i, x.getLineItemValue('item', 'woid', i));
    nlapiLogExecution('DEBUG', 'Setting the Work ID', '' + x.getLineItemValue('item', 'woid', i))
    }
    }
    nlapiSubmitRecord(x);
    }
    This is a cached copy. Click here to see the original post.

  • #21393

    al3xicon

    getLineItemText should get you what you are looking for

  • #21394

    rob@harkness

    ive tried:

    if(x.getLineItemValue('item', 'createwo', i)){

    x.setLineItemValue('item', 'custcol_work_order_id', i, x.getLineItemText('item', 'woid', i));

    nlapiLogExecution('DEBUG', 'Setting the Work ID', '' + x.getLineItemText('item', 'woid', i))

    but returns a blank value…

You must be logged in to reply to this topic.