Item Account Mapping
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.
The posting accounts for many transactions are determined by the items in the transaction. Use item account mapping to configure secondary accounting books to post to accounts different from the primary book for these transactions. There are limits on the accounts that can be mapped. For more information, see Mapping Restrictions.
Add all custom dimensions before you begin account mapping. Any change in custom chart of account mapping dimension invalidates all existing mapping rules.
To configure item account mapping:
-
Go to Setup > Accounting > Multi-Book Accounting > Item Account Mappings.
-
In the General field group, complete the required and optional fields as follows:
Effective Date – (Required) The mapping rule is not effective until this date is reached. Dates in the past are permitted.
End Date – When this date is reached, the mapping ends. If no date is entered, the rule remains in effect.
Accounting Book – (Required) Select the secondary accounting book to which the rule applies.
Subsidiary – (Required) The list of available subsidiaries depends on the accounting book selected.
-
In the Source field group, select an account type from the Item Account Type list. This selection determines the accounts that are available in the Source Account list.
Some items support multiple accounts on their Accounting subtab.
For example, you can select the Item Account Type Cost of Goods option and then select a cost of goods type account in both the Source Account and Destination Account lists.
Another example would be to select the Item Account Type Customer Return Variance option and then select any cost of goods, expense, or other expense type account in the Source Account and Destination Account lists.
Important:The Item Account Type must match the account type selected on the Accounting subtab of the item record. For example, if the item record uses an income account, the Item Account Type should be income.
-
Select an account from the Source Account list.
If you have restricted accounts to this accounting book, this list displays only those restricted accounts. For information about restricting accounts to accounting books, see Creating Accounts.
-
Select the appropriate dimensions from the Class, Department, and Location lists and any custom dimension list. Each account mapping must have unique dimension values.
Dimensions with the default value - Any - are permitted. Any dimensions with specific values selected have a higher priority in determining the account than those with the default.
-
In the Target field group, select an account from the Destination Account list.
If you have restricted accounts to this accounting book, this list displays only those restricted accounts.
-
Click Save.
The Actions menu on the Item Account Mapping page includes a Delete command. Use this command with caution. The system does not track deleted rules. Memorized transactions and other auto-posting transactions that rely on a mapping rule do not correctly post if that rule is deleted later.
The Import Assistant supports item account mapping. If you have many accounts to map, CSV import is recommended. For more information, see Item Account Mapping Import.