Global Account Mapping Import
For accounts using Multi-Book Accounting, the global 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 user can manually select 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.
For details, see Multi-Book Accounting Overview.
In the user interface, you access this record at Setup > Accounting > Global Account Mappings > New.
Global 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 global 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 global 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 Global 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.)
Global Account Mapping CSV File Example
The following table shows how you might format your CSV file when importing global account mapping records. In this example, the custom dimension field has been configured to reference the customer record. 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 |
Source Account |
Destination Account |
Custom Dimension |
|---|---|---|---|---|---|---|
|
101A |
1/31/2014 |
Canadian Accounting Book |
Parent Company : CA Subsidiary |
1100 Accounts Receivable |
1130 AR CA |
Customer A |
|
102A |
1/31/2014 |
Canadian Accounting Book |
Parent Company : CA Subsidiary |
1100 Accounts Receivable |
1182 AR CA |
Customer B |
|
101A |
1/31/2014 |
Czech Accounting Book |
Parent Company : CZ Subsidiary |
1100 Accounts Receivable |
1125 AR 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.