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.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update Class on a Cash Sale
We have an item with the wrong Class assigned to it.
There are about 500 transactions that need to be changed.
The CSV import is nuts, after an hour on the phone with Gold Support, the guy tells me it is an Enhancement Request to update a field on the line items.
I wrote a function that should do this, but it doesn't seem to save the new value in the field:
function xUpdateClass() { window.status = "Pulling Information from Saved Search"; var searchresults = nlapiSearchRecord('transaction', 1469, null,null); window.status = "Looping thru Records"; for (var i = 0; searchresults != null && i < searchresults.length; i++) { var searchresult = searchresults[i]; var InternalID= searchresult.getValue('internalid'); for ( var x = 0; x < searchresults.length; x++) { var record = nlapiLoadRecord(searchresults[x].getRecordType(), searchresults[x].getId() ); var recType = record.getRecordType() ; var recID = record.getId(); var NewActivity = 759; for(var y=1;y<=nlapiGetLineItemCount("item");y++) { var vClass = nlapiGetLineItemValue('item','class',y); if(vClass == '760') { nlapiSetLineItemValue('item','class', y,NewActivity); var id = nlapiSubmitRecord(record, true); } else { alert("FALSE"); } } } } alert("ALL 0