how do we get orderline from item fulfillment in saved search or suiteql

AI generated answer (using internal Slack threads):

To get the orderline from an item fulfillment in a saved search or SuiteQL, you can use the

Applied To Transaction

join or the

transactionlines.previouslinks.previousline

field. In the UI of the analytics, starting at item fulfillment, you can get data from the related sales order line with '`Related Transactions Lines - Previous: Transaction' -> Transaction Line: ____`. When building this via code and

N/query

, you would use

transactionlines.previouslinks.previousline

. In searches, you can get the line id of the linked sales order line using

Applied to Transaction fields... Line ID

, and on the actual item fulfillment record object, this field is called

orderline

. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******