ANS-1286 · ONEWORLD & MULTI-SUBSIDIARY
How to Display Subsidiary Names Without Hierarchy in NetSuite Reports?
Simplify NetSuite reports by displaying subsidiary names without their full hierarchical path.
Short answer
The most straightforward way to display a subsidiary name without its hierarchical path in NetSuite is to use the dedicated "subsidiarynohierarchy" field. This field automatically provides the subsidiary's local name, eliminating the need for complex custom formulas to parse hierarchical strings.
Scenario
Users often require subsidiary names to appear without their full hierarchical path (e.g., 'Parent : Child' should display as 'Child') for cleaner reporting or simplified data presentation. The default subsidiary field typically includes the entire hierarchy, which can be cumbersome for certain analyses or integrations.
Solution
The most efficient method to display a subsidiary's name without its hierarchy in NetSuite is to leverage the "subsidiarynohierarchy" field. This field is designed to provide only the local name of the subsidiary, automatically stripping away any parent company prefixes.
To implement this:
Navigate to the record or report where the subsidiary name needs to be displayed.
Add or select the field labeled "subsidiarynohierarchy".
Alternatively, for scenarios requiring custom logic or in environments where the "subsidiarynohierarchy" field might not be directly available or suitable, a custom formula can be used. This formula parses the subsidiary's full name to extract only the last segment.
case when {parent} is null then {name} else REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ','') endThis formula checks if a subsidiary has a parent. If not, it displays its name directly. If it does, it uses regular expressions to extract the portion of the name after the last colon, effectively removing the hierarchical path.
Expert NetSuite Support
Need help with this NetSuite issue?
OneWorld & Multi-Subsidiary consulting and configuration support