Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
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