Global Account Mapping

Internal ID: globalaccountmapping

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 for 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 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
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 true 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.

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)
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
location select Location
sourceaccount select Source Account
subsidiary select Subsidiary