ANS-0553 · CUSTOM FIELDS, RECORDS & FORMS
How to Source a Body Field for Main Line Accessibility in NetSuite?
Configure a custom free-form text column to source values from a NetSuite body field using a specific formula.
Short answer
To source a body field for main line accessibility, create a custom free-form text column and set its stored value to 'false'. Then, on the Validation & Defaulting subtab, input the internal ID of the target body field within curly brackets into the formula field. This configuration allows the custom column to display the desired body field's value.
Scenario
Users often need to display or source values from a NetSuite body field within a custom column, particularly when addressing main line accessibility requirements. The challenge lies in correctly configuring the custom column to pull the desired data from the body field. This setup ensures that specific body field information is readily available and accessible through the custom column.
Solution
To source a body field for main line accessibility using a custom column, follow these steps:
Ensure your custom column is of type 'Free Form Text' and has 'store value false'.
On the 'Validation & Defaulting' subtab, in the formula field, type in the internal ID of the body field you want to source between curly brackets.
{internalid_of_body_field}This configuration enables the custom column to display the value from the specified body field.
Expert NetSuite Support
Need help with this NetSuite issue?
Custom Fields, Records & Forms consulting and configuration support