Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
match data from other records in search
I need to search all customers and in the return include columns referencing data from contact and employee records.
Specifically, I have a field on the customer record that references the contact record and a field for salesrep. Pulling the field data from the customer I get the entityid and id from these fields. I need the email from the contact and employee records as well.
If I understand correctly, I can join using nlapiSearchColumn thusly: nlobjSearchColumn('id', 'contact'). However, how do I specify the contact record matching the id stored in the customer record's custom field?
Thank you.