Setting Up New Data Load Mappings for Rules Affected by Custom Dimensions
Make sure you set up new data load mappings for any data load rules affected by the custom dimensions. Data load mappings convert the chart of accounts values from the NetSuite General Ledger to Planning and Budgeting dimension members during data transfer. This lets Data Management categorize NetSuite General Ledger balances. For more information about data load mapping, see Data Load Mapping in the Oracle Help Center.
The following table list the data load rules affected by the custom dimension and the category for each rule. Use this table to select the Location and Category in the Point of View (POV) bar when you set up the data load mapping.
Data Load Rule (Location) |
Category |
---|---|
BalSht_Beg_Bals |
NSP_Actual |
BalSht_Beg_Bals_RC |
NSP_Actual |
BalSht_Trans |
NSP_Actual |
Consol_FxRate_Actual |
NSP_Actual |
Consol_FxRate_BudAct |
NSP_Actual |
Days_in_Month |
Current |
IncStmt_Trans |
NSP_Actual |
IncStmt_Trans_RC |
NSP_Actual |
To set up new data load mappings for the rules affected by custom dimensions:
-
Click the Navigator icon
, and then under Integration, select Data Management.
The Data Management window opens.
-
Click the Workflow tab, and then under Data Load, click Data Load Mapping.
-
In the POV bar, click the link next to Location.
The Select Point of View window opens.
Tip:In the Select Point of View window, you can click the search icon
next to fields to search for and select POV values.
-
In the Location field, enter the data load rule.
For example, enter BalSht_Beg_Bals.
-
In the Category field, enter the category that goes with the rule you entered, as shown in the preceding table.
For example, if Location is BalSht_Beg_Bals, enter NSP_Actual.
-
Click OK.
-
-
From the Dimensions list, choose the custom dimension that you want to map.
-
Click the Like tab, and then click Add.
-
In the new row, in the Source Value and Target Value fields, enter an asterisk (*).
The asterisk maps the NetSuite General Ledger account to Planning and Budgeting as-is, without any changes.
-
In Rule Name, enter the name of the data load rule used to transfer budget amounts to the NetSuite General Ledger.
-
(Optional) In Description, enter a short description of the mapping.
For example, enter something such as Map to the General Ledger.
-
Click Save.
-
If you enabled more than one custom dimensions, repeat steps 4 – 9 for each one.
-
Repeat steps 3 – 9 for each data load rule listed in the preceding table.