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 Name field into two columns. One with the parent listed, and the other one with the parent's child. But this is where I get stuck as I do not know which formula to enter to split the values out.
Could anyone please assist me or guide me on where to find the correct information?
I will appreciate any help you can provide.
Thanks
Charlene