Item Account Mapping

Internal ID: itemaccountmapping

Supports Custom Fields

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 Select the account that you want transactions post to in the secondary book that you selected from the Accounting Book list. 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.
effectivedate date false Effective Date true Enter or select the date that the account mapping begins.
enddate date false End Date false
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 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