Prashant Kala
03/24/2022, 4:26 AMtdietrich
03/24/2022, 5:13 AMSELECT
Transaction.Type,
Transaction.TranID,
Transaction.TranDate,
Transaction.Voided,
TransactionLine.LineSequenceNumber,
TransactionLine.Subsidiary,
BUILTIN.DF( TransactionLine.Subsidiary ) AS SubsidiaryName,
TransactionLine.Entity,
BUILTIN.DF( TransactionLine.Entity ) AS EntityName,
TransactionLine.NetAmount,
BUILTIN.DF( Transaction.Currency ) AS Currency,
Transaction.Exchangerate,
BUILTIN.DF( TransactionLine.ExpenseAccount ) AS ExpenseAccount,
TransactionLine.Eliminate,
TransactionLine.IsRevRecTransaction,
TransactionLine.CreditForeignAmount,
TransactionLine.DebitForeignAmount,
TransactionLine.Memo
FROM
Transaction
INNER JOIN TransactionLine ON
( TransactionLine.Transaction = Transaction.ID )
WHERE
Transaction.JournalType = 'ADVANCED_INTERCOMPANY_JOURNAL'
AND Transaction.ID = 240082
ORDER BY
TransactionLine.LineSequenceNumber
I hope that helps.Prashant Kala
03/24/2022, 10:22 AM