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 DONE"); } I put the function under a button on the Cash Sale form, It loops through the cash sales that need to be changed, but the new Class value isn't saved.You would be saving someone here HOURS AND HOURS ifyou could let me know how to fix this.