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.
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|
|5||COGS||Cost of Goods Sole|
|7||CTA-E||Cumulative Translation Adjustment-Elimination|
|8||CumulTransAdj||Cumulative Translation Adjustment|
|9||CustAuth||– Unknown –|
|13||DefRevClearing||Deferred Revenue Clearing|
|17||FxRateVariance||Foreign Currency Rate Variance|
|19||InterCoPayRec||Intercompany Payable Receivable|
|20||InvInTransit||Inventory In Transit|
|22||JobCostVariance||Job Cost Variance|
|23||OpeningBalEquity||Opening Balance Equity|
|30||PSTExp||Provincial Sales Tax Expense|
|31||PSTPay||Provincial Sales Tax Payable|
|33||RealizedERV||Realized Gain / Loss|
|34||RecvNotBill||Received not Billed|
|37||RndERV||Rounding Gain / Loss|
|39||RtnNotCredit||Return Not Credited|
|41||SalesTaxPay||Sales Tax Payble|
|46||UnappvExpRept||Un Applied Expense Report|
|47||UnappvPymt||Un Applied Payments|
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.