Mapping Restrictions

Note:

Please contact your sales or account representative to find out how to get the Full Multi-Book Accounting feature. The assistance of NetSuite Professional Services or a Multi-Book authorized partner is required to implement this feature. You should consider contacting NetSuite Professional Services or a Multi-Book authorized partner for assistance in setting up the Adjustment-Only Books feature, even though it is not required.

Important:

Multi-Book Accounting, including the Adjustment-Only Books feature, is available only in NetSuite OneWorld.

Not all accounts can be mapped to other accounts, and those accounts that can be mapped may usually be mapped only to other accounts of the same type.

For Global Account Mapping, NetSuite permits any account type to any account type mapping. If you create a mapping rule between different account types, NetSuite prompts you to confirm the mapping rule. You cannot create a mapping rule for account types that cannot be mapped.

In general, the following types of accounts cannot be mapped:

• Non-posting accounts such as sales orders and payroll adjustments

• Bank accounts

• Credit Card accounts

Note:

Although accounts receivable and accounts payable accounts can be mapped, the mapping is ignored for transactions that include entities such as invoices and bills.

The following accounts cannot be mapped to other accounts.

Account	Account Type
Reclassification Deferred Revenue *	Deferred Revenue
Cumulative Translation Adjustment	Equity
Cumulative Translation Adjustment — Elimination	Equity
Opening Balance	Equity
Retained Earnings	Equity
Estimates	Non Posting
Opportunities	Non Posting
Payroll Adjustments	Non Posting
Purchase Orders	Non Posting
Return Authorizations	Non Posting
Sales Orders	Non Posting
Transfer Orders	Non Posting
Unapproved Customer Payments	Non Posting
Unapproved Expense Reports	Non Posting
Vendor Return Authorizations	Non Posting
Work Orders	Non Posting
Intercompany Clearing (previously known as Intercompany Payable/Receivable)	Other Current Assets
Inventory	Other Current Assets
Inventory in Transit	Other Current Assets
Inventory Returned Not Credited	Other Current Assets
Undeposited Funds	Other Current Assets
WIP Account	Other Current Assets
Accrued Purchases	Other Current Liabilities
Exchange Rate Variance	Other Expense
Realized Gain/Loss	Other Expense
Rounding Gain/Loss	Other Expense
Unrealized Gain/Loss	Other Expense
Unrealized Matching Gain/Loss	Other Expense
Unbilled Receivable	Unbilled Receivable
* Accounts used as part of revenue reclassification are not system generated and cannot be blocked from mapping. Automatic revenue reclassification journal entries, however, ignore any mapping.

The source account for item account mapping is restricted on the primary account record.

Note:

When mapping tax accounts, ensure that the destination account is also a tax account.

Related Topics:

Mapping Dimensions

Global Account Mapping

Item Account Mapping

Chart of Accounts Mapping

General Notices