This article is relevant if you develop software using NetSuite’s SuiteScript.

NetSuite Account Type SearchFilters

If you are developing a search query and you need to reference the NetSuite General Ledger Account Types, you need to translate what you see in the Saved Search user interface to the equivalent nlobjSearchFilter code.

SuiteScript Code Example

Here is code that looks for all the Accounts Receivable accounts:

// return the number of Accounts Receivable Accounts defined within the NetSuite Account
function getARCount(){

	var filters = [];
	filters[0] = new nlobjSearchFilter('type', null, 'is', 'AcctRec' );
	var searchresults = nlapiSearchRecord('account', null, filters, []);

	if (searchresults){
		return searchresults.length
	} else {
		throw nlapiCreateError('getARCount_ERROR', 'Function did not return an AR Account.');
	};
};

Previous Articles

I have written previous articles that are related to this article.

1. NetSuite SearchFilter Internal Transaction Type Codes
2. NetSuite SearchFilter Transaction Internal Status List
3. How To: Script to Automate NetSuite Journal Entries
4. Showing NetSuite Internal IDs and Field Names
5. Use Custom Logic to Drive NetSuite General Ledger Posting Accounts

Subsequent cross referenced articles are below.

Get Help

Marty Zigman

Holding all three official certifications, Marty is regarded as the top NetSuite expert and leads a team of senior professionals at Prolecto Resources, Inc. He is a former Deloitte & Touche CPA and has held CTO roles. For over 30 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to set up a conversation.

More Posts - Website - Twitter - Facebook - LinkedIn - YouTube