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 the Name field, go to Setup > Accounting > Preferences > 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.
The number can be alphanumeric. The maximum number of characters is 60. |
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. This account does not appear in account dropdown lists 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 |
For income accounts, this is the deferred revenue account used to record transactions for revenue recognition. For expense accounts, it is the deferred expense account used to record deferred transactions for amortization and depreciation.
The deferred account should never be the system-generated Deferred Revenue Clearing account.
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. This account does not appear in account dropdown lists 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 |
Check this box to make this account an intercompany account. Intercompany accounts are used to record transactions between subsidiaries.
You can post both intercompany transactions and non-intercompany transactions to most intercompany accounts. Intercompany Accounts Receivable and Intercompany Accounts Payable, however, can be used only for recording amounts that are candidates for eliminations.
For details, see the help topic Intercompany Accounts. |
externalid |
text |
false |
ExternalId |
false |
Returns the account's external ID, if one is assigned. |
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’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, select the Inventory box. |
isinactive |
checkbox |
false |
Inactive |
false |
Check this box to inactivate this account. Inactive accounts do not show in lists on transactions and records. |
legalname |
textarea |
false |
Legal Name |
false |
If the Use Legal Name in Account accounting preference is enabled at Setup > Accounting > Preferences > Accounting Preferences, the Legal Name field appears. You can enter up to 400 characters in this field including special characters such as colon and semi colon. You can also enter characters such as Éé,Çç, and 2 byte characters such as 会計、科目.
This field is useful in countries where the legal name of an entity is required by law.
The Legal Name field can be added to financial reports where account is an available component. It is also available in advanced searches, SuiteScript, and ODBC.
System notes maintains an audit trail specific to the activity on the Legal Name field. |
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. This account does not appear in account dropdown lists 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. |
restricttoaccountingbook |
select |
false |
Restrict to Accounting Book |
false |
If Multi-Book Accounting is provisioned in your account, select the secondary accounting books to which this account is restricted when you make book specific secondary book transactions. Accounts restricted to only secondary accounting books are not available at book generic transactions.
Note: The Restrict to Accounting Book field displays Active and Pending accounting books. Inactive accounting books are listed only if selected before the accounting book was deactivated.
If you do not select a secondary accounting book, the account is available in all accounting books.
In addition to secondary accounting books, the Restrict to Accounting Book field lists the primary accounting book. If you select the primary accounting book, the account is not available at book specific secondary book transactions. If you select the account at primary accounting book generic transactions and mapping is not defined, the transactions are posted to the same account in the secondary accounting books.
Important: Secondary accounting book restricted accounts are not available for budgeting. Budgeting is available only in the primary accounting book. Every page where you can select an accounting book and an account adheres to the defined restrictions. For example, for Amortization and Revenue Recognition journal entries, the Original Account, Target Account, and Deferral Account fields display the restricted accounting books. For Allocation Schedules and Intercompany Allocation Schedules, the Source Account, Destination Account, Credit Account, and Intercompany Account fields display the restricted accounting books. If the account is not restricted to an accounting book, journal entries are posted to the same accounts in the secondary accounting books. For Account Mappings, the Source Account field lists all accounts that are available in the primary accounting book and the Destination Account field lists accounts that are available in the restricted secondary accounting books.
Statistical accounts do not have accounting book restrictions because these accounts do not appear at book specific transactions.
You can restrict an account to additional accounting books after transactions are posted to previously restricted accounting books.
A restricted account displays in reports. |
revalue |
checkbox |
false |
Revalue Open Balance for Foreign Currency Transactions |
false |
Check this box to select this account for open balance currency revaluation. |
subsidiary |
select |
false |
Subsidiaries |
true |
If necessary, select one or more subsidiaries to restrict the use of this account. Note: Bank accounts and credit card accounts are restricted to a single subsidiary.
After subsidiaries are selected, this account can be selected only on transactions where one of the associated subsidiaries is also selected.
* If the root subsidiary is selected, all subsidiaries can access the account.
* If one or more subsidiaries are selected, the account can be selected only for records and transactions associated with those subsidiaries.
* If no subsidiary is selected, transactions do not post to the account. It is used for reporting purposes only. |
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. |