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

I feel like I’ve solved this before but I can’t remember how…. How do I get the direct parent customer id of a sub-customer, and not the top-most parent customer id?

From the description of the problem, it sounds like you are doing a search

if so, use the parent customer join instead of the parent column

the name of the parent column is "Top Level Parent"