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

image.png

Hi All. I'm trying to delete a user and i get the message that it cant be deleted because of dependent records with the following records to note. the problem is that it doesn't tell me what type of records there are for me to delete. Any thoughts on how to get past this?

Guessing that's the internal ID of the custom record that they own. You should be able to see "Customization &gt; Lists, Records, &amp; Fields &gt; Record Types" what custom records they own and edit to change the owner to yourself.

<@U010J37HTQE> I'm sure that is the internal id of a custom record. But they are not the owner of the "table" or definition of the custom record, so they don't show up on that list of record types. The problem is that i have over 100 custom record types, so it's too many to look though each one. Maybe there is a search that can help? It's really a lame, incomplete error message

maybe a sql query would find it... let me check

:bomb: :boom:
```SELECT
	SystemNote.recordId record_id,
	customrecordtype.name as record_type_name,
	customrecordtype.scriptid as record_type_scriptid
FROM
	SystemNote
	JOIN CustomRecordType ON systemnote.recordtypeid = customrecordtype.internalid
WHERE
	recordId IN (116411, 116412)
	AND systemnote.type = 1```

throw that into Tim Dietrich's SuiteQL query tool if you have it already

presumption is that the custom record has system notes enabled

<@UHXHE0684> WOW! that worked! thanks so much, great pull...

right click in browser, view source, find one of these strings.  sometimes the data type is shown in the html code.

it's useful to find the exact field id names

<@U05AC92BJE6> Good idea. I do that sometimes on other stuff, just didn't think about it this time. thx