Item Account Mapping

Internal ID: itemaccountmapping

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountingbook	select	false	Accounting Book	true	You must select an accounting book before you select the subsidiary. Only active accounting books appear on the list.
class	select	false	Class	false	Select the class that the transaction must be associated with in order to meet the mapping rule.
customdimension	select	false	Custom Dimension	false
customform	select	false	Custom Form	false
department	select	false	Department	false	Select the department that the transaction must include in order to meet the mapping rule.
destinationaccount	select	false	Destination Account	true	<p>Select the account that you want transactions post to in the secondary book that you selected from the Accounting Book list.</p> <p>Select -Same- if you want skip mapping for the set of dimensions you have selected. This enables you to apply the mapping rules to all dimensions except a specific set.</p>
effectivedate	date	false	Effective Date	true	Enter or select the date that the account mapping begins.
enddate	date	false	End Date	false	Enter or select the date that the account mapping ends. This field can be left blank until a new account mapping is needed. When blank, the mapping continues indefinitely.
externalid	text	false	ExternalId	false
itemaccount	select	false	Item Account	true	Select the general ledger account type or other account specified on the Item record in Accounts section of the Accounting subtab. The item account type you select determines which accounts are available in the Source Account list.
location	select	false	Location	false	Select the location that the transaction must be associated with in order to meet the mapping rule.
sourceaccount	select	false	Source Account	false	Select an account that is used for the primary book. This is the account that is mapped from. The list includes both primary book accounts and secondary book accounts.
subsidiary	select	false	Subsidiary	false	Select the subsidiary that must be associated with the transaction in order to meeting the mapping rule. You must select an accounting book in order to select a subsidiary.

Tabs

Name	Label
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
accountingbook	Accounting Book	Accounting Book
department	Department	Department
destinationaccount	Destination Account	Account
location	Location	Location
sourceaccount	Source Account	Account
subsidiary	Subsidiary	Subsidiary

Search Filters

Internal ID	Type	Label
accountingbook	select	Accounting Book
class	select	Class
customdimension	select	Custom Dimension
department	select	Department
destinationaccount	select	Destination Account
effectivedate	date	Effective Date
enddate	date	End Date
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
itemaccount	select	Item Account
location	select	Location
sourceaccount	select	Source Account
subsidiary	select	Subsidiary

Search Columns

Internal ID	Type	Label
accountingbook	select	Accounting Book
class	select	Class
customdimension	select	Custom Dimension
department	select	Department
destinationaccount	select	Destination Account
effectivedate	date	Effective Date
enddate	date	End Date
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)
internalid	select	Internal ID
itemaccount	select	Item Account
location	select	Location
sourceaccount	select	Source Account
subsidiary	select	Subsidiary