We switched to the Custom Segments introduced by NetSuite from a couple of custom fields to keep track of what Industries are customers are in. For example one Parent Industry is Aerospace and the subsegments under Aerospace we have the following:
ID Value Parent
2 Aerospace
10 Air Cargo Aerospace
11 Aircraft Manufacturers Aerospace
12 Aircraft Repair and Maintenance Aerospace
13 Space Aerospace
14 Airlines Aerospace
If I run a saved search I can set in the Criteria to either the “Parent” or the “Value” field which is shown as “Name”. So if I want to run a search for those customers who are in the Aerospace industry I would just set the criteria for Parent = “Aerospace”.
However, in using the Report Builder or using Suite Analytics via ODBC you can not access the “Parent” field just the “Name” field. This is a major drawback to using Custom Segments and I can’t understand why NetSuite does not give us access to the “Parent” field in either the Report Builder nor via ODBC.
Pete
This is a cached copy. Click here to see the original post.