tdietrich
01/06/2022, 7:14 PMSELECT
Transaction.TranID,
BUILTIN.DF( Transaction.Entity ) AS EntityName,
BUILTIN.DF( TransactionAccountingLine.AccountingBook ) AS AccountingBookName,
Account.AcctNumber,
Account.Fullname AS AccountName,
TransactionAccountingLine.Debit,
TransactionAccountingLine.Credit,
TransactionAccountingLine.Posting,
TransactionLine.Memo
FROM
Transaction
INNER JOIN TransactionAccountingLine ON
( TransactionAccountingLine.Transaction = Transaction.ID )
LEFT OUTER JOIN TransactionLine ON
( TransactionLine.Transaction = TransactionAccountingLine.Transaction )
AND ( TransactionLine.LineSequenceNumber = TransactionAccountingLine.TransactionLine )
LEFT OUTER JOIN Account ON
( Account.ID = TransactionAccountingLine.Account )
WHERE
( Transaction.ID = 2808592 )
AND ( TransactionAccountingLine.Account IS NOT NULL )
-- AND ( TransactionAccountingLine.NetAmount <> 0 )
-- AND ( TransactionAccountingLine.Posting = 'T' )
ORDER BY
TransactionAccountingLine.TransactionLine
I hope that helps.