Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Custom code for line items
Hi all,
It appears that after V11 the operation to loop through each single line item no longer works.
Please refer to the following code below:
Function saverecor()
{
for(i=1; i<= nlapiGetLineItemCount('item'); i++)
{
//nlapiSelectLineItem('item', i);
var therate = parseFloat(nlapiGetCurrentLineItemValue('item', 'rate'));
var theqty = nlapiGetCurrentLineItemValue('item', 'quantity');
var itempercent = parseFloat(nlapiGetCurrentLineItemValue('item', 'custcolitemcostpercent'));
var calcamt = parseFloat(((therate * theqty) - (therate* theqty * comm)) * (itempercent/100));
nlapiSetCurrentLineItemValue('item', 'custcolitemcostamt', nlapiFormatCurrency(calcamt) );
}
return true;
}
This function is executed on record save of an invoice. What happen is that the code in the for loop gets executed once only. The code is not repeated again and so only the first line item is modified.