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 Item Fulfillment records for a specific sales order? I have this query to fetch IF records, but I do not see a reference back to the Sales Order in any form:

`SELECT * FROM Transaction WHERE type = 'ItemShip' ORDER BY trandate DESC`

Answered my own question. Given a sales order entity id of `xxxxx`, you would use this query to get IF ids:

`SELECT Transaction.ID FROM Transaction INNER JOIN TransactionLine ON TransactionLine.Transaction = Transaction.ID WHERE TransactionLine.CreatedFrom = 'xxxxx' AND Transaction.Type = 'ItemShip' GROUP BY Transaction.ID`