Zum Hauptinhalt wechseln
Dokumentation
Dokumentation
Adaptive Planning
Zuletzt aktualisiert: 2024-08-23
Steps: Set Up NetSuite Basic Integration

Steps: Set Up NetSuite Basic Integration

If you are an
Adaptive Planning
 customer who's also a NetSuite customer, you can automate the import of actuals data from your NetSuite accounts into your
Adaptive Planning
 model using the NetSuite connector. Once the NetSuite connector gets turned on and configured, you can also export budgets from
Adaptive Planning
 to NetSuite and enable drill through from
Adaptive Planning
 into NetSuite. This method of connecting is also known as NetSuite Basic.
In an
Adaptive Planning
 model,
Adaptive Planning
 users with administrative permissions can grant NetSuite Setup permission to any Concept: Permission Sets. Users with that permission can then set up the NetSuite Connector.
You can integrate using NetSuite Basic using token-based authentication:
  • For existing implementations, you need a Consumer Key, Consumer Secret, Token ID and Token Secret.
  • For new implementations, you only need a Token ID and Token Secret. New implementations of NetSuite Basic will use the shared Consumer Key and Consumer Secret managed by Workday.

Prerequisites

  • Permissions required in
    Adaptive Planning
    :
    Administrator
  • Permissions required in NetSuite:
    NetSuite admin
    (role id=3)
  • Obtain your company's NetSuite account ID from within NetSuite by navigating to
    Setup
     >
    Company
     >
    Company Information
  • For Token-Based Access, generate token-based authorization keys in NetSuite.

Basic Steps

  • Grant the
    NetSuite Setup
     permission in
    Adaptive Planning
     and assign that permission set to the user who needs to set up the NetSuite connector
  • Enter your NetSuite Account ID. Log in to
    Adaptive Planning
     as the user with the NetSuite Setup permission and enter NetSuite token-based authentication keys in the NetSuite Integration Setup page.
  • Set up NetSuite category configuration and mappings in
    Adaptive Planning
     before importing from NetSuite the first time.
  • Import from NetSuite to
    Adaptive Planning
  • If needed, export budgets to NetSuite

Navigation

Compass.png From the nav menu navigate to
Integration > NetSuite Setup
.

Set Up Integration

Set up the NetSuite integration once for each
Adaptive Planning
 instance.
  1. Log in to
    Adaptive Planning
    .
  2. Go to nav menu
    >
    Integration > NetSuite Setup
    . Only users with the
    NetSuite Setup
     Concept: Permission Sets can access NetSuite Setup.
  3. Select
    Token based authentication
     if you already generated token based authentication keys from NetSuite.
    You may need to select
    Update Import User
     to unlock the settings. Updating the import user does not delete any mappings or previously imported actuals.
  4. Enter the NetSuite
    Account ID
    . If your company purchased the
    Adaptive Planning
     for Netsuite bundle in the NetSuite Bundle Marketplace (recommended), select
    Enhanced bundle-based drill-through
    .
    NetSuite Drill-through is only available if you set up your NetSuite Integration before August 12, 2024.
  5. Enter authentication details. For Token-Based Authentication enter the NetSuite
    Token ID
    ,
    and Token Secret
     you generated from NetSuite.
  6. Save
     the setup.
For security purposes, user NetSuite passwords and email addresses are not stored in
Adaptive Planning
 applications.
Adaptive Planning
 attempts to connect to NetSuite to establish the integration when you click
Save
. If the connection succeeds, this page confirms the integration and displays the NetSuite account ID. If the connection fails, the page will display an error message with a description of the issue.

Create an Adaptive Planning Integration User

As a recommended best-practice you can create a new user account exclusively for performing NetSuite data imports. This optional user account protects against the loss of the integration if the first user account becomes invalid.
If you do not want to use a NetSuite seat specifically for handling the integration and import process, you can use the following instructions to set up an existing user with the correct permissions.
To set up an
Adaptive Planning
 integration user in NetSuite:
  1. Create a new role in NetSuite called Adaptive. Give it web-services-only access with these permissions:
    • Transactions > Find Transactions FULL
    • Transactions > Set Up Budgets FULL
    • Lists > Perform Search FULL
    • Lists > Accounts VIEW
    • Lists > Classes VIEW
    • Lists > Customers VIEW
    • Lists > Departments VIEW
    • Lists > Items VIEW
    • Lists > Locations VIEW
    • Lists > Subsidiaries VIEW
    • Reports > Balance Sheet VIEW
    • Reports > Income Statement VIEW
    • Reports > Financial Statements VIEW
    • Setup > Accounting Lists EDIT
    • Setup > Deleted Records FULL
    • Setup > Login Using Access Tokens FULL
    • Setup > Manage Accounting Periods VIEW
    • Setup > SOAP Web Services FULL
    Permissions can be renamed in NetSuite. If you don't see a permission from this list, navigate in
    NetSuite to Setup > Company > Rename Records/Transactions
    and check for changed names. Example: Class could have been renamed Classification. Error messages use the original names.
    If you are a NetSuite OneWorld customer with multiple subsidiaries, grant the role access to all subsidiaries and check the cross-subsidiary record viewing permission box. In the
    Subsidiaries Restrictions
     section of the role page, set accessible subsidiaries to
    ALL
    .
  2. Make a note of the role's
    Internal ID
    .If the internal ID does not show, navigate to
    Home > Set Preferences > General > Defaults > Show Internal IDs
     and select
    T
    .
  3. Create a new user in NetSuite called Adaptive Planning Integration and assign this user the Adaptive role.
  4. Navigate to
    Integration > NetSuite Setup
     in
    Adaptive Planning
    .
  5. Select
    Update Import User
    .
  6. Enter the Adaptive Planning Integration user's authorization details. To view the account ID in NetSuite, navigate to
    Setup > Integration > Web Service Preferences
    . The role ID is the
    Internal ID
     you noted earlier.

Reset the Integration Setup

Once the NetSuite Integration has been successfully completed, a
Reset Connection
 button appears at the bottom of the screen. Click this button to disable the NetSuite integration and prevent data from transferring from NetSuite into
Adaptive Planning
. Resetting the integration does not delete any mappings or previously imported actuals.
You can restore an integration by re-entering authentication information in the NetSuite Integration Setup page described earlier.

Set Up NetSuite Category Configuration

  1. Go to nav menu
    >
    Integration > NetSuite Category Configuration
    .
  2. Select the
    Netsuite Import Category Mappings
     at the bottom of the page
    .
  3. Map the in-use NetSuite categories to their corresponding
    Adaptive Planning
     dimensions before performing the first import from NetSuite.
An administrator can specify how NetSuite categories (e.g. Subsidiary, Department, Class, etc.) relate to dimensions in
Adaptive Planning
 (e.g. Account, Level, etc.). The associations established here let you map:
  • A one-to-one relationship of a NetSuite category to a single dimension in
    Adaptive Planning
  • Multiple NetSuite categories to a single dimension in
    Adaptive Planning
  • A single NetSuite category to more than one dimension in
    Adaptive Planning
Mappings determine what choices the person importing gets during the import process or from the NetSuite Category Mappings page. Mappings don't need to change often, if at all.
  • If multiple NetSuite categories are associated with a single
    Adaptive Planning
     dimension, the values in those categories get concatenated and mapped as though they were one category. Example: If
    Department
    and
    Location
    are both associated with Level, then the import mapping screen will display choices like
    Engineering US
     or
    Sales London
    .
  • If a single NetSuite category is associated with two
    Adaptive Planning
     dimensions, the mapping appears for both dimensions. Example: If
    Class
    is associated with both
    Region
    and
    Product
    , then the import mapping screen will display both dimensions, allowing the user to map
    Americas: Product A
     to
    Americas
    in one instance and
    Americas: Product A
     to
    Product A
     in another.
Configure NetSuite Categories
  1. Select the corresponding dimension for each category in the drop-down lists to map NetSuite categories to
    Adaptive Planning
     dimensions. The drop-downs display
    Account, Level,
     and any
    custom dimensions
     for your model. If multiple NetSuite categories map to one
    Adaptive Planning
     dimension, select that same dimension in the drop-down list for those categories.
  2. Select
    Add
    next to the drop-down list to associate a category with multiple dimensions. Up to three additional drop-down lists can be added for each category, for a total of four dimensions assigned to that category.
  3. Click
    Save
     when you finish.
Configure NetSuite Category Mappings Values
After you complete the category configuration, the NetSuite Import Category Mappings link navigates to the mapping page. The user importing can specify mappings between the NetSuite category values and the
Adaptive Planning
 model dimension values. This list remains empty until an import.

Import from NetSuite

Once the NetSuite integration and category configurations have been completely set up, the import user can perform imports from NetSuite on the
Import
 tab in their Adaptive model.
  1. Log into
    Adaptive Planning
    .
  2. Go to nav menu
    Integration > Import Data
    .
  3. Select
    Actuals
     under
    Import Type.
  4. Select
    NetSuite Actuals
    under
    Import From.
  5. Standard
     gets selected by default under
    Import into Sheet.
  6. Select the time range you want to import under
    Time Periods to Import.
  7. Click
    Import
    .
  8. Set up mappings you want in the
    Category Mappings
     page.
  9. Click
    Continue
    .
  10. The Results of Import page loads after the import completes, indicating if the import succeeded.

Export to NetSuite

Administrators can configure Adaptive Integration to export budgets into NetSuite.
Required Permissions
Administration
 >
General Setup
 >
Integration and NetSuite Basic
Administration
 >
Permission Set
 edit the user who exports and select
Export Capabilities
 and
Export Budgets to NetSuite
.
Select NetSuite As the Export Target
Once NetSuite Basic gets enabled, users with the Export Budget to NetSuite permission can export to NetSuite or a CSV file.
If NetSuite Basic is enabled but not configured, the Output Target section appears but the NetSuite checkbox is disabled. If NetSuite Setup isn't configured, the
NetSuite Category Configuration
 link appears.
  1. Set up the NetSuite Category Configuration described earlier if you didn't already.
  2. Go to
    Integration > Export Data
    .
  3. Select
    NetSuite
     for the output target.
  4. Select the budget category in NetSuite you want to export to.
  5. Select one or more fiscal years in NetSuite you want to export to.
  6. Select
    Export
    .

Drill Through

NetSuite Drill-through is only available if you set up your NetSuite Integration before August 12, 2024.
When you view a sheet in
Adaptive Planning
 or Cell Explorer window containing an actuals number mapped for importing from NetSuite, you can drill down into the number. This launches a NetSuite report detailing the transactions that comprise the number.
The
NetSuite Basic
 check box in
Administration
 >
General Setup
enables the
Drill into NetSuite Imported Numbers
 permission you can grant to any permission set.
The drill behavior depends on whether or not the Adaptive Insights for Netsuite bundle (from the NetSuite Bundle Marketplace) has been installed in your NetSuite installation. If the bundle has been installed, be sure to go to the NetSuite Integration Setup page and check the
Adaptive Insights for Netsuite bundle installed
 check box.
Requirements for Drilling
  • In NetSuite, install the NetSuite Bundle 30441 for drill-though.
  • Once data imports from NetSuite, users with the right permissions can drill into the NetSuite data from
    Adaptive Planning
    .
Without the Adaptive Insights for Netsuite Bundle
If the Adaptive Insights for Netsuite bundle was not installed in NetSuite, the
Drill Through to
NetSuite
 option will appear in the right-click menu only when all of the following are true:
  • The user has a permission set that includes
    Drill into NetSuite Imported Numbers
    .
  • The NetSuite Integration Setup succeeded and the NetSuite connection is configured.
  • The right-clicked number belongs to the actuals version.The number is not the result of a formula; it must be either a raw piece of data or a rollup of such data, and that data was imported from NetSuite.
  • The number is for a timeslot that maps to at least one NetSuite accounting period.
  • The number is for an account that is a target of a NetSuite Import Account Mapping.
  • The number is not in a cube account. (Linked accounts which are linked to cube accounts, but are showing their own actuals numbers, can be drilled through.)
  • The number is on a level which fulfills at least one of the following requirements:
    • The level is the Top Level.
    • The level is included in the NetSuite Import Organization Mapping.
    • If the number is on a split, then all dimension values assigned to the split (other than blank or Any values) are included in one or more NetSuite Import Dimension Mappings.
  • The number maps to at most one value for each NetSuite category.
With the Adaptive Insights for Netsuite Bundle
If the Adaptive Insights for Netsuite bundle has been installed in NetSuite, the
Drill Through to NetSuite
 option requirements are less restrictive:
All other requirements stay the same.
To be more specific, the
Drill Through to NetSuite
 option appears in the right-click menu only if all of the following are true:
  • The user has a permission set that includes
    Drill into NetSuite Imported Numbers
    .
  • The NetSuite Integration Setup succeeded, and the NetSuite connection is configured.
  • The right-clicked number belongs to the actuals version.
  • The number is not the result of a formula; it must be either a raw piece of data or a rollup of such data. If a rollup, at least one of the pieces of data in that rollup must have come from NetSuite, but not necessarily all of them.
  • The number is for a timeslot that maps to at least one NetSuite accounting period.
  • The number is for an account that is a target of a NetSuite Import Account Mapping.
  • The number is not in a cube account. (Linked accounts which are linked to cube accounts, but are showing their own actuals numbers, can be drilled through.)
  • The number is on a level which fulfills at least one of the following requirements:
    • The level is the Top Level.
    • The level is included in the NetSuite Import Organization Mapping.
    • If the number is on a split, then all dimension values assigned to the split (other than blank or Any values) are included in one or more NetSuite Import Dimension Mappings.
  • The number maps to at least one value for at least one NetSuite category.
  • If the coordinates being explored or visited were mapped from NetSuite at all, then the
    Drill Through to NetSuite
     option shows. A mapping does not need to be exactly one-to-one.
  • Drilling on rollups is allowed when at least one of the leaf cells included in the rollup got mapped from NetSuite. Not all cells included in the rollup need mapping.
Drilling from a Sheet
A sheet can display actuals values when either:
  • The actuals version has been chosen in the View Selector
  • The chosen plan version displays some months of actual data
Either way, a right-click on an actuals number opens a menu including the choice,
Drill Through to
NetSuite
.
Select
Drill Through to
NetSuite
 from the right-click menu to launch a NetSuite transaction report in a new browser window. If you haven't logged in yet to NetSuite, you get prompted to log in.
After log in, either the NetSuite Profit and Loss Detail report or the NetSuite Balance Sheet Detail report shows up, depending on the selected number. The Profit and Loss Detail report shows if the drilled number is in a NetSuite account of type Expense, Income, Other Income, Other Expense, Non-Posting, or Cost of Goods Sold. All other account types launch a
Balance Sheet Detail Report
.
You can click on anything NetSuite allows and drill into whatever detail NetSuite provides.
If the number being drilled into was changed in
Adaptive Planning
, it may no longer match what was originally imported from NetSuite. The number in NetSuite may have changed at some time after it was imported into
Adaptive Planning
. In these cases, the NetSuite report reflects a different number than the number you drilled into in
Adaptive Planning
.
Drilling from Cell Explorer
When a Cell Explorer window displays a number that satisfies rules described above, a
Drill Through to NetSuite
link appears in the upper left corner. This link behaves identically to the
Drill Through to NetSuite
 option in the right-click menu.