Written by: Ely Beltran Background
An Address Book is listed in the NetSuite custom field of List/Record type. However, the issue with this approach is that the entire address list is selectable for the custom field. NetSuite does not permit setting the 'Customer' field as a source filter for the custom field. Instead, you can use a method involving two custom fields to achieve this use case.
This tutorial will demonstrate how to restrict the address book list based on the entity field in the record.
We require an Address Book within the Project Record in this sample setup. It will be selectable through the Custom Entity Field, which is the proper field type since we are in the Project Record. The selectable addresses should be limited to those associated with the Customer (ID: parent) set in the Project Record.
To accomplish this, you will need two entity fields:
A Custom Entity Field of List/Record type with Customer Record values
A Custom Entity Field of List/Record type with Address Book Record values
Custom Entity Fields Set-up
I. Customer Field
Go to Customization > Lists, Records & Fields > Entity Fields > New
Follow the following field setup:
3. In the Sourcing and Filtering tab, add a filter:
4. Save.
II. Address Field
Go to Customization > Lists, Records & Fields > Entity Fields > New
Follow the following field setup:
3. In the Sourcing and Filtering tab, add a Source List and Source Filter By:
Testing the Custom Fields
Create a new Project.
Lists > Relationships > Project > New
Populate the ‘Project Customer’ field
When you select an address in the 'Project Address' field, you'll notice that the address list is now filtered based on the customer specified in the 'Project Customer' field.
Etter+Ramli as the Trusted, Independent Managed Services Provider for NetSuite
Using NetSuite Managed Services could be your growing company's best strategic move. NetSuite Managed Services offers a comprehensive solution, granting companies access to a team of experienced NetSuite administrators and consultants to manage their NetSuite ERP. Typically, this service is more affordable than hiring in-house staff. When you use managed services, your systems are always up-to-date. In the world of IT, systems are consistently upgraded and patched and come with a slew of security protocols. It is a lot to handle, but your teams can handle this when implementing managed services.
The goal is to ensure your NetSuite instance supports your business’ growth.
For over 20 years, Etter+Ramli has helped several companies optimize their NetSuite software solution. With a 95% customer satisfaction rate, Etter+Ramli can provide your company with world-class support, Certified NetSuite experts, and a value-based pricing structure.
Etter+Ramli As Your Extended NetSuite Team
Etter+Ramli is an Independent Managed Success Provider for NetSuite clients. We are NOT partnered with Oracle NetSuite and do not take commissions. We bring our knowledge, expertise, and passion for success to our clients. We help clients Buy, Deploy, Grow, and Abandon NetSuite. We engage as a client-side managed service to ensure our priorities align with our clients.
To explore the benefits of retaining Etter+Ramli as your Managed Success Provider, contact Todd Kimpton or visit our website for a free consultation today.