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.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
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