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

:wave: Anyone know if it's possible to create a custom field for addresses filtered by a customer field on the same record?

use addressbook as the list/record source

and use an entity field to use for sourcing or filtering

<@U5TF1GQ20> I tried this, customer is not a viable comparator to be filtered by entity. I get this error

*`The list or record type of the field or source (Customer) must match the list or record type of the field you are filtering by (Entity).`*

by netsuite's rules, a customer field is not an entity field

use a custom field whose list/record source is entity

Should note - the field tied to addresses requires some extra work in order to be useful

I had to script a lookup in order to push values into other fields so the users could see it

If I remember correctly, I had to use a customer search as the type to look at.

and you'll have to use the internal ID of the field results against the field "Address internal ID"

the most confusing thing about addressses in netsuite is that there is an id for an address subrecord

and an id for the addressbook sublist line on the entity record

and the address selects on transactions use the addressbook line id