Mapping Restrictions
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.
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
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.
When mapping tax accounts, ensure that the destination account is also a tax account.