Accounting Book

Internal ID: accountingbook

Supports Custom Fields

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
basebook	select	false	Base Book	false
customform	select	false	Custom Form	false
effectiveperiod	select	false	Effective Period	true	(Required) Select the existing historical base period for this secondary accounting book. The accounting periods that appear in this list are those associated with the primary accounting book. If there are no closed periods in your system, NetSuite lists only the first open accounting period. You can change the effective period only on a secondary accounting book with a Pending status. You cannot, however, change the effective period on a secondary book with a Pending status that has transactions, or when the book is in the process of deleting or processing historical transactions.
externalid	text	false	ExternalId	false
includechildren	checkbox	false	Include Children	false	This check box is for display purposes only. Any child subsidiaries of the subsidiaries you select are automatically associated with this accounting book. You cannot select a parent and only one of its children.
isadjustmentonly	checkbox	false	Adjustment Only	false	When this box is checked, your secondary accounting book is created as an adjustment-only book. Adjustment-only books differ from standard secondary books in that they do not duplicate the data in the primary book. Instead, adjustments to data from the primary book are made in the adjustment book. You can display financial reports on the data combined from both the primary book and adjustment book in reports and searches. Adjustment-only books do not count against the accounting book limit.
isconsolidated	checkbox	false	Enable Consolidation	false	Check this box to enable this secondary accounting book for consolidation. Secondary books enabled for consolidation have access to all OneWorld consolidation including all tasks on the period close check list, consolidated reporting, auto-elimination, and book specific consolidated exchange rates. Primary accounting books are enabled for consolidation by default.
isprimary	checkbox	false	Is Primary	false	This box is for display purposes only. It cannot be checked for secondary accounting books. It cannot be cleared for the primary accounting book.
name	text	false	Name	true	Enter a unique name for the accounting book. This name appears in fields and lists when a choice of accounting book is available.
status	select	false	Status	true	The status may be Pending, Active, or Inactive. The status of a new accounting book is Pending. If Currency Management is also enabled, you cannot activate the accounting book until the currency for the accounting book is set in each of the associated subsidiaries. An accounting book that is active may be deactivated, but it cannot be reactivated afterwards.
subsidiary	select	false	Subsidiaries	false	Select one or more subsidiaries to associate with this accounting book. Any child subsidiaries of the subsidiaries that you select are automatically associated with this accounting book.

Sublists

accountingbookcurrencies - Currencies

Internal ID	Type	Label	Required	Help
currency	select	Base Currency	false
effectivedate	date	Effective Date	false
exchangerate	float	Translation exchange rate	false
primarybookcurrency	select	Primary Book Base Currency	false
subsidiary	text	Subsidiary	false
subsidiarykey	text	key	false
subsidiarystatus	text	Status	false

accountingbooksubsidiaries - Subsidiaries

Internal ID	Type	Label	Required	Help
currency	select	Base Currency	false
effectivedate	date	Effective Date	false
exchangerate	float	Translation exchange rate	false
primarybookcurrency	select	Primary Book Base Currency	false
status	select	Status	false
subsidiary	select	Subsidiary	false

Tabs

Name	Label
workflow	Workflow

Search Filters

Internal ID	Type	Label
basebook	select	Base Book
currency	select	Currency
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
includechildren	checkbox	Include Children
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isadjustmentonly	checkbox	Is Adjustment Only
isprimary	checkbox	Primary
name	text	Name
status	select	Status
subsidiary	select	Subsidiary

Search Columns

Internal ID	Type	Label
basebook	select	Base Book
currency	select	Currency
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)
includechildren	checkbox	Include Children
internalid	select	Internal ID
isadjustmentonly	checkbox	Is Adjustment Only
isprimary	checkbox	Primary
name	text	Name
status	select	Status
subsidiary	select	Subsidiary