<@USR3EBSVB> Here's a query that will return the r...
# suitescript
t
@Ramanand Dubey Here's a query that will return the related records for a Sales Order. It should work with just about any transaction type.
SELECT DISTINCT
Transaction.TranDate AS Date,
BUILTIN.DF( Transaction.Type ) AS Type,
Transaction.TranID,
BUILTIN.DF( Transaction.Status ) AS Status,
PreviousTransactionLineLink.LinkType,
Transaction.ForeignTotal AS Amount
FROM
PreviousTransactionLineLink
INNER JOIN Transaction ON
( Transaction.ID = PreviousTransactionLineLink.NextDoc )
WHERE
( PreviousTransactionLineLink.PreviousDoc = 7301 )
ORDER BY
Transaction.TranDate