Account

Internal ID: account

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
acctname	text	false	Name	true	Enter up to 31 characters for an account name that will appear on all reports. If you want to use GL account numbers and do not see a Number field above this Name field, go to <_TABNAME=ADMI_ACCTSETUP_> > <_TASKCATEGORY=ADMI_ACCTSETUP_> > Accounting Preferences, and check the Use Account Numbers box. Save the preference, and return to this page.
acctnumber	text	false	Number	true	Enter the number to identify this account.
accttype	select	false	Type	true	Select a GAAP category for the type of account you are creating. The account type you select here determines the default section for this account on your financial statement.
accttype2	text	false	Type	false
billableexpensesacct	select	false	Track Billable Expenses in	false	You can select a revenue or income account to track expenses and costs that are billable to customers. This field only appears for Account Types such as COGS and Expense.
cashflowrate	select	false	Cash Flow Rate Type	false	Select the type of exchange rate that is used to translate foreign currency amounts for this account in the cash flow statement. The Current rate type is based on the currency exchange rate that is effective at the end of the reported upon period. The Average rate type is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Average. This rate is the default. The Historical rate type is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Historical.
category1099misc	select	false	1099-MISC Category	false	Select a 1099-MISC Category to have all cash-basis transactions for a vendor reported on the corresponding box of the 1099 form. Amounts are not reported until they exceed the threshold for the category. To view 1099-MISC categories and edit thresholds, go to Setup > Accounting > Accounting Lists, and select 1099-MISC Category in the Type field.
class	select	false	Restrict To Class	false	Select a class to restrict use of this account to roles with permission to access it. If you select a class in this field, this account can be selected only by employees whose role permits access. For example, if you select Class 1 in this field, use of this account is restricted to employees that have permission to access Class 1. Then, this account does not appear in account dropdowns on transactions for employees with a role that restricts access to Class 1.
currency	select	false	Currency	false	Select a currency for the funds in this account.
deferralacct	select	false	Deferral Account	false	Select a deferred expense account to record deferred transactions for amortization and depreciation. A deferral account is available only for account types that allow deferred transactions.
department	select	false	Restrict To Department	false	Select a department to restrict use of this account to roles with permission to access it. If you select a department in this field, this account can be selected only by employees whose role permits access. For example, if you select Department 1 in this field, use of this account is restricted to employees that have permission to access Department 1. Then, this account does not appear in account dropdowns on transactions for employees with a role that restricts access to Department 1.
description	text	false	Description	false	Enter a description for this account.
eliminate	checkbox	false	Eliminate Intercompany Transactions	false	Indicates this is an intercompany account used only to record transactions between subsidiaries. Amounts posted to intercompany accounts are eliminated when you run the intercompany elimination process at the end of an accounting period.
externalid	text	false	ExternalId	false
generalrate	select	false	General Rate Type	false	Select the type of exchange rate that is used to translate foreign currency amounts for this account in the income statement, balance sheet, and other general purposes. The Current rate type is based on the currency exchange rate that is effective at the end of the reported upon period. This rate is the default for most balance sheet accounts. The Average rate type is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Average. This rate is the default for income statement accounts and is used build retained earnings. The Historical rate type is calculated from a weighted average of the exchange rates for transactions applied during the period to accounts with a general rate type of Historical. This rate is used for equity accounts, or owner&#x2019;s investments, in the balance sheet.
includechildren	checkbox	false	Include Children	false	Check the Include Children box to share the account with all the sub-subsidiaries associated with each subsidiary selected in the Subsidiary field.
inventory	checkbox	false	Inventory	false	If this will be an Other Current Asset account and you want the balance of this account included in the total balance of the Inventory KPI, then select the Inventory check box.
isinactive	checkbox	false	Inactive	false	Check this box to inactivate this account. Inactive accounts do not show in lists on transactions and records.
location	select	false	Restrict To Location	false	Select a location to restrict use of this account to roles with permission to access it. If you select a location in this field, this account can be selected only by employees whose role permits access. For example, if you select Location 1 in this field, use of this account is restricted to employees that have permission to access Location 1. Then, this account does not appear in account dropdowns on transactions for employees with a role that restricts access to Location 1.
openingbalance	text	false		false	Enter an opening balance for this account.
parent	select	false	Subaccount of	false	Select the parent account if this account is a subaccount of another.
revalue	checkbox	false	Revalue Open Balance for Foreign Currency Transactions	false	Indicates whether this account can be selected for open balance currency revaluation.
subsidiary	select	false	Subsidiaries	true
trandate	date	false	Date	false	Enter the date of the opening balance of this account.
unit	select	false	Default Unit	true	This field displays the base unit assigned to the Unit Type. The default unit cannot be changed.
unitstype	select	false	Unit Type	false	This field displays the type of unit associated with this statistical account.

Tabs

Name	Label
history	System Notes
translation	Translation

Search Filters

Internal ID	Type	Label
balance	currency	Balance
cashflowratetype	select	Cash Flow Rate Type
category1099misc	select	1099-MISC Category
description	text	Description
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
generalratetype	select	General Rate Type
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isinactive	checkbox	Inactive
name	text	Name
number	text	Number
parent	select	Sub-Account Of
subsidiary	select	Subsidiary
type	select	Type

Search Columns

Internal ID	Type	Label
balance	currency	Balance
cashflowratetype	select	Cash Flow Rate Type
category1099misc	select	1099-MISC Category
description	text	Description
externalid	select	External ID
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
generalratetype	select	General Rate Type
internalid	select	Internal ID
isinactive	checkbox	Inactive
name	text	Name
number	text	Number
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
type	select	Account Type