When records in NetSuite are linked to one another, it can be useful to display information from the related record directly on the current form. This can help users see important details without opening another record.
Displaying values from a related record can improve visibility, reduce clicks, and make data entry easier.
What Does It Mean to Display Field Values from a Related Record?
This setup allows a field on one record to show information pulled from another record that is already connected to it.
This is commonly used when a record includes a reference to another record, such as:
- customer
- employee
- vendor
- item
- custom record
- parent record
A field can then display a value from that related record, such as a name, status, department, category, or reference value.
Why Use It?
This setup can help:
- reduce manual entry
- make important information easier to see
- improve form usability
- reduce navigation between records
- improve consistency
- support better user decisions during entry
Example
A custom record may include a field that references an Employee record.
Example:
- Related Employee = John Smith
You may want another field on the same custom record to display the employee’s:
- department
- supervisor
- location
- title
This lets users view important details from the related record without opening it separately.
Step 1: Confirm the Related Record Field
NetSuite: Go to Customization > Lists, Records, & Fields
NetSuite Next: Click Explore (hamburger icon in the bottom left corner beside the home button).. In the menu, go to Customization > Lists, Records, & Fields
Open the record and identify the field that links to the related record.
NetSuite Next:
Examples:
- Customer
- Vendor
- Employee
- Parent Record
- Custom Record Reference
This linked field is what allows NetSuite to identify the related record.
Note: In this example we will be using the following Records and fields
Record: Sales Order
Field: Sales Rep
Related Record Field: Supervisor
NetSuite:
Step 2: Create the Field That Will Display the Value
Create a new custom field on the current record.
Choose the correct field type based on how you want the value to appear.
Examples:
- free-form text
- list/record
- date
- integer number
- decimal number
Make sure the the stored value is unchecked and Apply the field to the correct record type.
Step 3: Set Up Sourcing
Edit the new field and go to the sourcing setup.
Select:
- the source list or record
- the source field to pull from
In this example:
- Source From = Sales Rep
- Source Field = Supervisor
This tells NetSuite to display the value from the related record.
Step 4: Review Field Display and Behavior
Place the field on the form where users can easily see it.
Decide whether the field should be:
- editable
- view only
- stored
- shown on specific forms only
In many cases, a related display field works best as a view-only field.
NetSuite:
Step 5: Save and Test
Save the field setup.
Open or create a record that uses the related record reference.
Verify that:
- the related record is selected correctly
- the value displays as expected
- the field updates correctly when the related record changes
- the value appears on the correct forms and roles
Tips
- use clear labels for sourced fields
- make sure the related record field is already present
- confirm the source field is available on the related record
- use view-only display when users should not change the value
- test with real records
- check whether the value should be stored or simply displayed
Best Practices
- use sourcing for values users need to see often
- avoid duplicating too many related fields unless they are truly useful
- keep labels simple and easy to understand
- place sourced fields near the related record field
- review whether the value should refresh dynamically
- test in sandbox before moving to production
- document the source relationship for future admins
Summary
Displaying field values from a related record in NetSuite can make forms more useful and easier to work with. By using a related record field and sourcing the value into another field, administrators can show helpful information directly on the current record.
This can improve visibility, reduce manual work, and help users make better decisions while working in NetSuite.
We would love to hear some of your tips and tricks to your records. Share your insights and experiences in the NetSuite Admin Corner.