NetSuite: Use SuiteQL to Get Transactions Posted to a General Ledger Account

Published on December 14, 2024.

This SuiteQL query returns all of the transactions that were posted to a specified general ledger account in a specified date range.

SELECT
	Transaction.TranDate,
	Transaction.TranID,
	BUILTIN.DF( Transaction.Entity ) AS Entity,
	TransactionAccountingLine.Debit,
	TransactionAccountingLine.Credit
FROM 
	Transaction
	INNER JOIN TransactionAccountingLine ON
		( TransactionAccountingLine.Transaction = Transaction.ID )
	INNER JOIN Account ON
		( Account.ID = TransactionAccountingLine.Account )
WHERE
	( Transaction.TranDate >= BUILTIN.RELATIVE_RANGES( 'DAGO30', 'START' ) )
	AND ( Transaction.Posting = 'T' )
	AND ( TransactionAccountingLine.Posting = 'T' )		
	AND ( 
		( TransactionAccountingLine.Debit IS NOT NULL ) 
		OR ( TransactionAccountingLine.Credit IS NOT NULL ) 
	)
	AND ( Account.AcctNumber = 7110 )
ORDER BY
	Transaction.TranDate,
	Transaction.TranID,
	TransactionAccountingLine.TransactionLine

Need a query that returns the GL impact for a specified transaction? Check out "Use SuiteQL to Get A Transaction's GL Impact."

About Me

Hello, I'm Tim Dietrich. I develop custom software for businesses that are running on NetSuite, including mobile apps, Web portals, Web APIs, and more.

I'm the developer of several popular NetSuite open source solutions, including the SuiteQL Query Tool, SuiteAPI, and more.

I founded SuiteStep, a NetSuite development studio, to provide custom software and AI solutions - and continue pushing the boundaries of what's possible on the NetSuite platform.

Copyright © 2025 Tim Dietrich.