Item Account Mapping Import
For accounts using Multi-Book Accounting, the item account mapping record enables you to configure secondary accounting books to post to accounts different from the primary book. These mappings are used by transactions where the item determines the account to which the transaction posts.
This import is available when you enable the Chart of Accounts Mapping option at Setup > Company > Enable Features, on the Accounting subtab. Note that this choice is part of the overall setup required for Multi-Book Accounting.
NetSuite Professional Services handles the setup and implementation of the Multi-Book Accounting feature in Version 2014 Release 2.
For details, see Multi-Book Accounting Overview.
In the user interface, you access this record at Setup > Accounting > Item Account Mappings > New.
Item Account Mapping Fields
The Import Assistant supports all the fields that are available in the user interface. It also supports external ID — that is, you can give each item account mapping record an external ID of your choosing, which you can later use as a unique identifier when updating the record.
For details about fields that can be mapped in this record, see the SOAP Schema Browser’s item account mapping reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.
For help working with this record in the user interface, see Item Account Mapping.
The field labeled Custom Dimension is available only if you have configured the field at Setup > Accounting > Accounting Preferences, on the Accounting Books tab. (For details on this process, see Custom Mapping Dimensions.)
Item Account Mapping CSV File Example
The following table shows how you might format your CSV file when importing item account mapping records. In this example, the custom dimension field has been configured to reference costing method. Note that because this record has no sublist, you always use a single CSV file for the import.
External Id |
Effective Date |
Accounting Book |
Subsidiary |
Item Account Type |
Source Account |
Destination Account |
Custom Dimension |
---|---|---|---|---|---|---|---|
111A |
1/31/2014 |
Philippine Accounting Book |
Parent Company : PH Subsidiary |
Expense |
6012 Advertising |
6160 Outside Services |
Average |
112A |
1/31/2014 |
Philippine Accounting Book |
Parent Company : PH Subsidiary |
Expense |
6012 Advertising |
6180 Professional Fees |
LIFO |
111A |
1/31/2014 |
Czech Accounting Book |
Parent Company : CZ Subsidiary |
Asset |
1200 Inventory |
1221 AT CZ |
— |
Exercise care with the formatting of your date and subsidiary values. With the date field, the value must match the NetSuite formatting preference for the person doing the import. With the subsidiary field, the value must be hierarchal; for example: “Parent Company : UK Subsidiary.” If the formatting of either the date or subsidiary value is incorrect, the import fails.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.