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

Does anyone know how to query the project linked to an opportunity?

```SELECT
  transaction.tranid,
  BUILTIN.DF(transactionline.entity) as entity,
  job.id
FROM
  transaction
  INNER JOIN transactionline ON transactionline.transaction = transaction.id
  INNER JOIN job ON transactionline.entity = job.id
WHERE
  transaction.id = 583353 -- id of opportunity ```

Doesn’t work, the entity points to the customer not the project.

Are you sure you're using transactionline.entity not transaction.entity?

My exact query with a valid opportunity yields what?

There is only one line in transactinLine for the opportunity, and entity is the ID of the customer

I do agree normally transactionLine.entity links to job on other transaction types, but the opportunity ONLY has a mainline which generally does not link to project

We must have different configurations or something.

Results from your query, returning “customer / company”

We are using advanced projects, wonder if that is why

I believe you. The only thing I would suggest is to `select * from transaction inner join transactionline` and ctrl-f and see if you could find the job id.