Mapping Dimensions
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.
Both global account mapping and item account mapping rely on dimensions. Each rule must have a unique set of mapping dimension values. The dimensions for account mapping in their order of priority are:
-
Effective date (required)
-
End date
-
Accounting book
-
Subsidiary
-
Class
-
Department
-
Location
-
Custom mapping dimension
The lists for Class, Department, Location, and the custom dimension include two special values:
-
-Any- – This is the default value. If you accept -Any- as the value, the mapping rule applies to all values for that dimension. Dimensions with specific values take priority over dimensions with the default value.
-
-Unassigned- – Use this value to specify a class, department, location, or custom dimension that is null on the transaction record. It is a specific value, and dimensions set to -Unassigned- have a higher priority than those with the default value.
Custom Mapping Dimensions
Custom mapping dimensions enable you to use a field on an item or transaction record as an additional dimension to more narrowly define the account mapping. Global and item account mapping support one custom dimension each.
Add any custom dimensions before you begin account mapping. Any change in custom chart of account mapping dimensions invalidates all existing mapping rules.
To add a custom mapping dimension:
-
Go to Setup > Accounting > Preferences > Accounting Preferences.
-
Click the Accounting Books tab.
-
To add a custom dimension to the Item Account Mapping form, select a field from the Custom Item COA Mapping Dimension list.
To add a custom dimension to the Global Account Mapping form, select a field from the Custom Transaction COA Mapping Dimension list.
Note:You cannot add a custom dimension on the following fields: Sales, A/P Account, A/R Account, Adjustment Location, Buying Reason, Buying Time Frame, Country, Discount Item, Effectivity Based On, Next Approver, Payment Method, Purchase Contract, Sales Readiness, and To Location.
-
Click Save.
The custom dimensions appear on their respective mapping forms as Custom Dimension. Use the Customize Form option on the Customize menu for the page to change the label to match the field selected for the dimension. Custom Dimension appears on the Fields subtab. For more information about customizing forms, see Creating Custom Entry and Transaction Forms.