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.
Transaction search filter returns null id
Hi,
I am trying to search for all transactions and delete them. The problem is that my search is returning multiple records/lines with the same internalid. My idea was to search the transactions by type, loop though the results and delete them.
I was first used the following code (note there is no grouping) when I descovered the multiple duplicate id's returned:
//search for all transactions based on Type matching deleteTypeArr index var tranType = "SalesOrd"; var tranFilter = new nlobjSearchFilter('type', null, 'anyof',tranType); var tranCol = [new nlobjSearchColumn('internalid')]; var tranResults = nlapiSearchRecord('transaction',null,tranFilter,tranCol); //loop through results for(resultIndex=0;resultIndex<tranResults.length;resultIndex++){ logger.debug('Deletion', 'id= '+tranResults[resultIndex].getValue('internalid')); } 0