NetSuite SearchFilter Internal Account Type Codes

Accounting NetSuite Technical

Tags: , , , ,

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.

Account Type SuiteScript SearchFilter
Bank Bank
Accounts Receivable AcctRec
Other Current Asset OthCurrAsset
Fixed Asset FixedAsset
Other Asset OthAsset
Accounts Payable AcctPay
Credit Card CredCard
Other Current Liability OthCurrLiab
Long Term Liability LongTermLiab
Equity Equity
Income Income
Cost of Goods Sold COGS
Expense Expense
Other Income OthIncome
Other Expense OthExpense
Non Posting NonPosting
Deferred Revenue DeferRevenue
Deferred Expense DeferExpense
Unbilled Receivable UnbilledRec
Statistical Stat

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

If you found this article relevant, feel free to get notifications of new articles.
We love to innovate on the platform. If you are looking to get more out of your NetSuite account, contact us.  

 

Be Sociable, Share!

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

About 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.

Biography • Website • X (Twitter) • Facebook • LinkedIn • YouTube

2 thoughts on “NetSuite SearchFilter Internal Account Type Codes

Leave a Reply

Your email address will not be published. Required fields are marked *