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

<@UAPHBR6TS> I'm still getting ERROR: Field Not Found .  I'm doing a transaction search.

are you using it as a formula in results?

yes, i tried to to a formula text field with only {customermain.parent}

Try adding it through the dropdown? Customer (Mainline) Fields... then "Top Level Parent"

This brings the name of the parent, which is great, but I'm trying to get the internal ID of the top level parent.  I don't think I can.

Not from a transaction because that's a 3 level join

you could store it in a field on the customer record and then join to that custom field

Or, do a customer saved search and bring in transaction data?

that would work -ish. results could get a bit wonky depending on use case