NetSuite Account Special Types Reference

This article is meaningful if you are performing saved searches and you want to get at specific capacities in NetSuite data based on account type usage.

Background

In a recent article, How To: NetSuite Stock Inventory Movement and In-Transit, I used a NetSuite lookup based on the General Ledger Special Account type representing Inventory and Inventory-in-Transit.  When solving for the challenge, I did not reference accounts directly.  Instead, the key to many inquiries is not to use the general ledger account; rather use the account type.  Thus, the more I thought about it, it was clear that the Special Account Types used in Saved Searches joining with the Account table might unlock a world of capacities.

Table of NetSuite General Ledger Special Account Types

The following is the table of NetSuite general ledger Special Account Types that can be used to help you discover key information.  The key is to use the Special Account Type presented in Saved Searches when performing a join.

2016.2 # Account Type Meaning
1 AcctPay Accounts Payable
2 AcctRec Accounts Receivable
3 AccumDeprec Accumulated Depreciation
4 AdvPaid Advances Paid
5 COGS Cost of Goods Sole
6 CommPay Commissions Payment
7 CTA-E Cumulative Translation Adjustment-Elimination
8 CumulTransAdj Cumulative Translation Adjustment
9 CustAuth – Unknown –
10 CustDep Customer Deposit
11 DeferExpense Deferred Expense
12 DeferRevenue Deferred Revenue
13 DefRevClearing Deferred Revenue Clearing
14 DirectLabor Direct Labor
15 Estimate Estimate
16 FailedACH Failed ACH
17 FxRateVariance Foreign Currency Rate Variance
18 IndirectLabor Indirect Labor
19 InterCoPayRec Intercompany Payable Receivable
20 InvInTransit Inventory In Transit
21 InvtAsset Inventory Asset
22 JobCostVariance Job Cost Variance
23 OpeningBalEquity Opening Balance Equity
24 Opprtnty Opportunity
25 PayAdjst Payroll Adjustment
26 PayrollExp Payroll Expense
27 PayrollFloat Payroll Float
28 PayrollLiab Payroll Liability
29 PayWage Payroll Wage
30 PSTExp Provincial Sales Tax Expense
31 PSTPay Provincial Sales Tax Payable
32 PurchOrd Purchase Order
33 RealizedERV Realized Gain / Loss
34 RecvNotBill Received not Billed
35 RefundPay Refunds Payable
36 RetEarnings Retained Earnings
37 RndERV Rounding Gain / Loss
38 RtnAuth Return Authorization
39 RtnNotCredit Return Not Credited
40 SalesOrd Sales Order
41 SalesTaxPay Sales Tax Payble
42 Tax Tax
43 TaxLiability Tax Liability
44 Tegata Tegata
45 TrnfrOrd Transfer Order
46 UnappvExpRept Un Applied Expense Report
47 UnappvPymt Un Applied Payments
48 UnbilledRec Unbilled Receivable
49 UncatExpense Uncategorized Expense
50 UncatIncome Uncategorized Income

Gain Access to NetSuite’s Power

The key to getting more out of NetSuite is to understand the fundamental architecture of the platform. Many elements of the system are well-document. Others are less-so. Most of the platform, in my assessment, “makes sense”. Meaning, it is held together logically and its architecture is well-designed thus giving you access to powerful capacities.

Share with use your special use case for Account Types so we can all get better at working with NetSuite.

Be Sociable, Share!

Marty Zigman

Holding all three official certifications, Marty is Southern California's 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 25 years, Marty has produced leadership in ERP, CRM and eCommerce business systems. Contact Marty to setup a conversation.

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

| Tags: | Category: Accounting, NetSuite | 2 Comments

2 Comments

  1. Prakash
    Posted March 22, 2017 at 11:54 am | Permalink

    Hi Marty, I’ve a question on Currency translation abilities in NetSuite. Does NetSuite provide the ability to define different historical rates for different equity accounts?

    Thanks

  2. Posted March 22, 2017 at 1:01 pm | Permalink

    Hi Prakash,

    This question is off-topic relative to the article. I recommend sending me a note or referencing another one of my foreign currency articles.

    Marty

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>