Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
Custom Record Join
I feel like I must be missing something as this is such a basic thing, but I cannot find a way to do it without SuiteScript:
How can I join a transaction to a custom record that does not have a parent/child relationship?
The SQL equivalent is almost as basic as it gets: SELECT custom_record.field_2 FROM custom_record WHERE custom_record.field_1 = transaction.field
In my case, I am trying to lookup a custom record using the Ship To Zip on the Sales Order. Since Zip is not a list/record type in NS (seems like it is all completely hard-coded), how can I link the Sales Order's Ship To Zip to a custom field on the custom record called Zip in order to return the value of another field on the custom record, in this case, Delivery Route?