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.

Note:

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

Note:

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.

Additional Information

Related Topics

General Notices