This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi, i’m new to suiteql so please excuse me if this is a simple question. I am trying to recreate the general ledger report in suiteql, and I’m running into something that is making me think I am missing something fundamental. When you generate a general ledger report in the Netsuite UI, you get a “split” column by default which represents the ‘double’ part of double entry accounting.

It’s not clear to me if there is something in `Transactions` or `TransactionAccountingLine` that would represent this information, or if I’d be able to write a query that’d represent all posting transactions with a GL impact with the account that the “double” entry posted to. Am I missing something obvious? I know i can get a list of transactions for each account, but I’m not sure how I can find the second entry of each transaction.

Getting all the posting `transactionaccountingline` entries for a given transaction would be a good start

As a quick example, try this:
```SELECT
  account,
  credit,
  debit,
  transactionline
FROM transactionaccountingline
WHERE
  posting = 'T' AND
  transaction = {{transactionInternalId}}```