NetSuite: Use SuiteQL to Get Customer Deposits

Published on December 9, 2024.

This SuiteQL query returns all deposits received for a specific customer.

SELECT
	Transaction.ID AS Transaction,
	Transaction.TranID,
	Transaction.TranDate,
	BUILTIN.DF( Transaction.Entity ) AS Customer,		
	BUILTIN.DF( TransactionMainLine.CreatedFrom ) AS SalesOrder,
	Transaction.ForeignTotal,
	BUILTIN.DF( Transaction.PaymentMethod ) AS PaymentMethod,
	Transaction.OtherRefNum,
	BUILTIN.DF( Transaction.Status ) AS Status
FROM
	Transaction
	INNER JOIN TransactionLine AS TransactionMainLine ON
		( TransactionMainLine.Transaction = Transaction.ID )
		AND ( TransactionMainLine.MainLine = 'T' )
WHERE
	( Transaction.Type = 'CustDep' )
	AND ( Transaction.Entity = 7553356 )
	AND ( Transaction.Voided = 'F' )
ORDER BY
	Transaction.TranID

For an alternative version of this query, see "Use SuiteQL to Analyze Customer Deposits" from November of 2021.

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.