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

Is it possible to build a search of all address info in Netsuite? Is: customer, vendor and locations all in the same search?

Locations no - but you can do customer and vendor with an "entity" search

just beware - if you have employee addresses in the system, it will expose those as well

Ah okay thanks, yeah could I limit it to exclude employee addresses?

filter on "type" not equal to employee or something like that.

of course, if they are also set up as vendors or contacts and the address is there, it'll spoil that.

Dang thanks. Still no way to include the locations? We build shipping tables to send to our EDI team for both sales and transfers.

I mean, you could always build a custom table to hold it all in a custom record and populate that table via script

Yeah I could see that being a workaround. Not a programmer on my end and the net need probably doesn't justify having a programmer build it.

<https://system.netsuite.com/app/common/search/search.nl?searchtype=Address&amp;adv=T>

There's no link to the company though from there, so I'm not sure that helps.

i knew from past experience that its searchable, and its not hard to guess its id

not sure where the actual option is in the ui

there's like 3 address tables. Addressbook is the one that he'd want

because that'd be the one that contains a join to the entity/location

If you do the search from entity table, you can't get location associated with that entity?

Whoa thx all. Will take a look back and report tomorrow