Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Create a Business Unit Saved search with Parent and Child in two different columns
Good day,
I need to create a saved search in NetSuite listing the parent department and the child department in two different columns.
I created a new Department Saved Search and added the Name field to the Results tab. This shows me the parent and child in one column. I checked the Name (No Hierarchy) field, which shows me only the department's name with no relationship.
I then tried to add the Field ID: parent as a separate column to the saved search but the field is not available for selection.
I then added a Formula (Text) field and tried to split the
Tagged:
0