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."
Hello, I’m Tim Dietrich. I design and build custom software for businesses running on NetSuite — from mobile apps and Web portals to Web APIs and integrations.
I’ve created several widely used open-source solutions for the NetSuite community, including the SuiteQL Query Tool and SuiteAPI, which help developers and businesses get more out of their systems.
I’m also the founder of SuiteStep, a NetSuite development studio focused on pushing the boundaries of what’s possible on the platform. Through SuiteStep, I deliver custom software and AI-driven solutions that make NetSuite more powerful, accessible, and future-ready.
Copyright © 2025 Tim Dietrich.