[Jeff Wolf]

I would like to create a search where I could type in an internal ID to a filter and it would populate the Netsuite record. There are times where a CSV error log, search criteria, or other output gives an internal ID but I have no idea what it is. Does anyone have any recommendations on how to create this search? thanks!
This is a cached copy. Click here to see the original post.

[blarson@MesaLabs.com]

Internal IDs are only unique in the context of the record type. Have you tried the “Show Internal IDs” setting in your preferences? Not ideal, but that’ll display internal IDs in views which might help assuming you know the type of record you’re looking for.

[Jeff Wolf]

Yes, I do show internal IDs. The issue at time is that some filters, criteria, CSV responses will only give you the internal ID and you have no idea what it is. I thought there may be a way to create a record search of some kind with internal IDs as the filter where I could drop one in and it would tell me what the record is….

[rnedelkow]

Maybe this will help. Try adding the Quick search portlet to your dashboard so you could search by record type using Name/ID. See this SuiteAnswer for more details – https://netsuite.custhelp.com/app/an…arch%20portlet

[Jeff Wolf]

I just tried to add the quick search but when I type in an internal ID that I’m looking for it doesn’t work that way. If there was a record type of internal ID it would probably work.

[fjannelle]

Hi Jeff,

You will not be able to create a Generic search allowing you to search for any record type with a specific internal ID.

A viable solution I can think of is the following:Create a custom field for all record types you want to search for. Field type = Free Form text. Global Search = True.
Develop a script (or workflow) triggered on all same record types that copies the Internal ID over to this custom field.
This solution would synch the record Internal ID to a custom field and enable this field for Global Search. This will allow you to use the Global Search to type in an Internal ID and be able to find the matching records.

Keep in mind that records of different types can have the same Internal ID (ex: Customer and Transaction) so you run the chance of running across duplicates.

Best regards,

---

tsheets replied on 05/05/2016, 09:18 AM: Hi there. Did anyone figure this out? (other than creating the custom field). It seems to me we should either be able to add the transaction number to the error message email form (which I can’t find) or be able to search by internal id.

[Taphius]

Custom field is how we ended up accomplishing something similar to this.

{customer.internalid} is what we are using to append to the proper account (through workflow insertion on create/edit/view)

[Author]

Posts