This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone successfully used the BUILTIN.HIERARCHY function?  I have tried to get it to run on the customer table, but can not seem to get the correct joins in my select

This works for the Locations or Subsidiary  table, but it will not work on the Customer table.
```select 
BUILTIN.HIERARCHY(parent,'SELF_DISPLAY'), 
* from location```

I've had some luck with it in Account-related queries. Here's one. How effective it is depends on how the CoA is configured in the NetSuite instance.
```SELECT 
	ID,
	DisplayNameWithHierarchy, 
	Parent,
	BUILTIN.HIERARCHY( Parent, 'DISPLAY' ) AS DISPLAY,
	BUILTIN.HIERARCHY( Parent, 'DISPLAY_JOINED' ) AS DISPLAY_JOINED,
	BUILTIN.HIERARCHY( Parent, 'DISPLAY_SEPARATED' ) AS DISPLAY_SEPARATED,
	BUILTIN.HIERARCHY( Parent, 'IDENTIFIER' ) AS IDENTIFIER,
	BUILTIN.HIERARCHY( Parent, 'IDENTIFIER_SEPARATED' ) AS IDENTIFIER_SEPARATED,
	BUILTIN.HIERARCHY( Parent, 'LEVEL' ) AS LEVEL,
	BUILTIN.HIERARCHY( Parent, 'SELF_DISPLAY' ) AS SELF_DISPLAY,
	BUILTIN.HIERARCHY( Parent, 'SELF_IDENTIFIER' ) AS SELF_IDENTIFIER
FROM 
	Account 
WHERE 
	( Parent IS NOT NULL )
ORDER BY
	BUILTIN.HIERARCHY( Parent, 'LEVEL' ),
	DisplayNameWithHierarchy```

Thank you for the response, I guess that BUILTIN is limited in it's usage.