whats the best way to join transactionaccountingline to a transaction record using suiteql

AI generated answer (using internal Slack threads):

To join the

TransactionAccountingLine

to a

Transaction

record using SuiteQL, you can use the

INNER JOIN

clause. The

TransactionAccountingLine

table contains the GL impact data for transactions, and it can be joined with the

Transaction

table on the

Transaction.ID

field. Here is a sample SuiteQL query:

sql
SELECT 
    Transaction.Type,
    Transaction.TranID,
    Transaction.TranDate,
    TransactionAccountingLine.Account,
    TransactionAccountingLine.DebitAmount,
    TransactionAccountingLine.CreditAmount
FROM 
    Transaction
INNER JOIN 
    TransactionAccountingLine ON Transaction.ID = TransactionAccountingLine.Transaction

This query will return the transaction type, transaction ID, transaction date, account, debit amount, and credit amount from the

Transaction

and

TransactionAccountingLine

tables. Please note that the

TransactionAccountingLine

table is only available in NetSuite accounts that have the Multi-Book Accounting feature enabled. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******