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: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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