This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I want to delete all transactions based on a suiteQL.
Are there any built in functions to get the transaction type as record.Type/equivivalent from a suiteQL? I think I have seen this being discussed previously, but can't find anything fitting.
<http://BUILTIN.CF|BUILTIN.CF> and .DF just gives me the 'ExpRept' and 'Expense Report' values respectively

image.png

Just poking around, you may be able to do something with the table ScriptRecordType

maybe a join on the name with the value of builtin.df to the name column and get the internalid

Im not sure if you can replace the type parameter of record.delete() with an internalid though. Would be worth testing though

<@UP0GS40AF> Have you tried the field `recordtype`?

Thanks to both of you!
<@UH8L0UJAU>, that's exactly right

<@UP0GS40AF> I have an app that can do this via Saved search and was thinking of adding a SuiteQL feature to it. I'll have to add this to the backlog

<@UHKEFQTDZ> this is being used as a button function to delete transactions related to a custom record. So it should only delete a handful of transactions.

```require(['N/record','N/query'], function(record, query) {
    query.runSuiteQL({
        query: `
            SELECT id, recordtype as type
            FROM transaction
            WHERE 
                custbody_related_record = ${newRecord.id}
                AND isreversal = 'F'`
    }).asMappedResults().forEach(result =&gt; record.delete(result))
})```

Very cool. I'll have to save this snippet