I'm trying to figure out the code behind looking at a new Sales Order that has an item called "Repair" and add a second item called "Repair Cost" before User submit. I'm a bit lost and I wele any help that can be given. I would like this script to be in Javascript and I will attach it to the Sales Order form in Netsuite to run.

I'm trying to figure out the code behind looking at a new Sales Order that has an item called "Repair" and add a second item called "Repair Cost" before User submit. I'm a bit lost and I wele any help that can be given. I would like this script to be in Javascript and I will attach it to the Sales Order form in Netsuite to run.

• javascript
• netsuite

2 Answers 2

Here is one sample solution:

We will still assume that the items internal ids are Repair = 100 and Repair Cost = 200

function recalc(type)
{
    if(type == 'item')
    {
        var itemId = nlapiGetCurrentLineItemValue('item', 'item'); //Get the Item ID
        if(itemId == 100) //Repair Cost
        {
                //Insert item
                nlapiSelectNewLineItem('item');
                nlapiSetCurrentLineItemValue('item', 'item', 200); //Repair Cost
                nlapiSetCurrentLineItemValue('item', 'quantity', 1);
                nlapiSetCurrentLineItemValue('item', 'amount', '0.00');
                nlapiCommitLineItem('item');
        }
    }
    return true;
}

Deploy this as client-side code and make sure that the function is Recalc.

To learn more about client side script: https://system.na1suite./help/helpcenter/en_US/Output/Help/SuiteFlex/SuiteScript/SSScriptTypes_ClientScripts.html#1016773

First thing you need to do is to get the internal id of the item "Repair" and "Repair Cost".

In this example, let's assumed that the internal id of Repair = 100 and Repair Cost = 200

Here is th code:

function afterSubmit(type)
{
    if(type == 'create' || type == 'edit')
    {
        var record = nlapiLoadRecord(nlapiGetRecordType(), nlapiGetRecordId()); //Load the record

        //Loop to all sublist item
        var count = record.getLineItemCount('item');
        for(var i = 1; i <= count; i++)
        {
            var item = record.getLineItemValue('item', 'item', i); //This will return the internal id of the item
            if(item == 100) //Item is equal to 100; insert one item
            {
                record.insertLineItem('item', i);
                record.setLineItemValue('item', 'item', i, 200); //Repair Cost internal id
                record.setLineItemValue('item', 'quantity', i, 1); //You should put some quantity; depending on your account setup all required fields should be set here.
            }
        }

        //Submit the changes
        nlapiSubmitRecord(record, true);
    }
}

To understand the suitescript API and the fields exposed to sales order check on this Netsuite helpguide:

https://systemsuite./help/helpcenter/en_US/RecordsBrowser/2012_2/Records/salesorder.html