How do I get the salesrep field on the invoice record using suiteql

AI generated answer (using internal Slack threads):

To get the salesrep field on the invoice record using SuiteQL, you can use the

N/query

module in SuiteScript. This module allows you to execute SuiteQL queries to retrieve specific data from your NetSuite records. Here is a sample SuiteQL query that you can use to retrieve the salesrep field from the invoice record:

sql
SELECT T.id, T.salesrep 
FROM Transaction T 
WHERE T.type = 'Invoice'

In this query,

T.id

is the ID of the invoice and

T.salesrep

is the sales representative associated with the invoice. The

WHERE

clause filters the transactions to only include invoices. Please note that the salesrep field might not be directly available on the invoice record. In such cases, you might need to join the invoice record with the employee record to get the sales representative's details. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******