I'm looking to access the related record with SuiteQL. In fact, we have one IF per SO. How can I get there

NextTransactionLineLink table. previoustype = 'SalesOrd' and nexttype = 'ItemShip'

I will try it. thank you very much

You can also query the

createdfrom

field on the IF record

mainline

.

SELECT salesorder.tranid, itemfullfilment.tranid

FROM transaction as itemfullfilment 

inner join transactionline as itemfullfilmentmainline 
on itemfullfilmentmainline.transaction = itemfullfilment.id and itemfullfilmentmainline.mainline = 'T' 

INNER JOIN transaction as salesorder on salesorder.id = itemfullfilmentmainline.createdfrom

Nice