Write a SuiteQL query that retrieves the primary customer contact name and email from a salesorder

AI generated answer (using internal Slack threads):

To retrieve the primary customer contact name and email from a sales order using SuiteQL, you would need to join the

salesorder

table with the

customer

table and then the

contact

table. The primary contact information is stored in the

customer

table, and you can access it by joining on the

entityid

field. Here is a sample SuiteQL query:

sql
SELECT 
    c.companyname AS 'Customer Name',
    co.firstname || ' ' || co.lastname AS 'Primary Contact Name',
    co.email AS 'Primary Contact Email'
FROM 
    salesorder so
JOIN 
    customer c ON so.entity = c.entityid
JOIN 
    contact co ON c.entityid = co.company
WHERE 
    co.contactrole = 'Primary'

Please note that this is a simplified example and may need to be adjusted based on your specific NetSuite setup. The

contactrole

field may contain different values based on your setup, so you may need to adjust the WHERE clause accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******