How to Migrate to NetSuite2.com – Phase 1
- shannonm325
- 2 days ago
- 5 min read
To ensure compatibility with the upcoming NetSuite2.com data source, all customers currently using Solution 7 version 4.11 or earlier are required to upgrade to version 4.12 by June 2025. After this date, earlier versions will no longer be supported.
To help you through the upgrade, we’ve created an easy-to-follow guide that explains why the upgrade is needed and walks you through each step of the process.
You can follow along using the steps below. Just click the timestamped links in each section to jump straight to the corresponding part of the video for a fully guided walkthrough.
Or watch Simon Miles, Co-Founder of Solution 7, demonstrate each step in full, here.
What is NetSuite2.com?
The NetSuite2.com data source is designed to display consistent data across SuiteAnalytics Workbook, which solves some previous inconsistencies in data exposure between saved searches and reports. – NetSuite Help Center
Why do I need to migrate?
NetSuite is moving the SuiteAnalytics Connect service to a new data source. This new data source called NetSuite2.com is not backwards compatible with the previous, legacy data source used by Solution 7. We have added support for the new data source in Solution 7 v4.12.
Who needs to migrate?
All new Solution 7 customers— that's those who joined us after 1st of June 2024— were added to NetSuite2.com by default and are currently supported by v4.12. If you became a Solution 7 customer before 1st of June 2024, you will be on the older version of the software and will be required to migrate.
Upgrade Guide
Configuring NetSuite
Log in to your NetSuite account.
Click on ‘Setup’ in the navigation menu, and then from the drop-down, select ‘Company’ and then select ‘Enable Features’.
*Please note that if you are not able to see this menu, it is because you do not have the rights to change the features within NetSuite. You will need to either log in as an administrator or ask your assigned NetSuite Administrator to enable this feature for you.
Once you are in ‘Enable Features’, navigate to the ‘SuiteCloud’ tab and scroll down until you find the ‘Manage Authentication’ section.
Within the ‘Manage Authentication’ section, you should see a tick box called ‘Token-Based Authentication’. This NEEDS to be ticked.
As before, it is important to note that this role may not exist if you do not have the relevant permissions within NetSuite. You will need to log in as an administrator or ask your NetSuite Administrator to enable this for you.
Navigate to the search bar at the top of your NetSuite account and type in the name of the relevant user and select ‘Edit’. Alternatively, you can access your user screen by going into the ‘Setup’ drop-down and selecting ‘Users Roles’.
Within your user record, scroll down and click on the ‘Access’ tab.
If you scroll to the bottom of that section, you should see all of the roles that you have access to within NetSuite.
Click on the drop-down menu and select the ‘Solution 7 Reporting’ role and click ‘Add’ to add it to the user.
*Please note that adding these permissions to your users means that all users have the same level of access and full view of the system.
If you wish to give more granular access to your users with a limited view of the system, or if you have set your users up using custom segments, it is now possible to add the Solution 7 reporting role to those custom segments, which will automatically add the required permissions to their custom role.
You will then need to click on the ‘Save’ button to save the role to the user.
If the Solution 7 reporting role does not exist within your NetSuite interface, it is because you are not running our bundle. Please follow the steps below to install the Solution 7 bundle. Otherwise, you can skip to step 4.
Click on the ‘Customization’ tab in the navigation menu at the top of your NetSuite Account and from the drop-down menu select ‘SuiteBundler’, then ‘Search and Install Bundles’.
Within the Keywords search bar that appears, type in ‘Excel’ as this is the quickest way to return the results you are looking for.
Within the search results, scroll down until you find an option called ‘Solution 7 – Excel Financial Reporting’ and select it.
Within this page, there will be an option to ‘Install’, so go ahead and click on that to install the bundle. This will take around 5 minutes.
You should now have the Solution 7 Reporting Role required to complete Step 2.
Updating all User’s PCs
Check what is currently installed on your PC by navigating to your settings menu and then selecting ‘Apps’ and then ‘Installed Apps’.
Scroll down until you find the ‘SuiteAnalytics Connect’ module.
The latest version of the NetSuite ODBC is v8.10.158. If you are not on this version, you will need to update.
To update, log into your NetSuite account and navigate to the NetSuite home page.
Scroll down to the Settings section and select ‘Set Up SuiteAnalytics Connect’.
Once on this page, scroll down to the ‘Drivers’ section and you should see 2 options for the ODBC Driver – the 64-BIT and the 32-BIT. You only need to install the version that matches the version that you already have installed.
Click on the ‘Download’ button and install on your PC.
Once installed, you will now be running the latest version of ODBC.
*Please note that the steps above will need to be performed on each individual user’s PC.
Check what is currently installed on your PC by navigating to your settings menu and then selecting ‘Apps’ and then ‘Installed Apps’.
Scroll down until you find the ‘Solution 7’ module.
The latest version of Solution 7 is v4.12. If you are not on this version, you will need to update. Alternatively, you can see what version of Solution 7 you are running via the ‘About’ button within the Solution 7 tab in Excel.
Navigate to the Solution 7 website and click on ‘Downloads’ within the navigation menu.
Under Software Downloads, you should see an option named ‘Solution 7 NetSuite Edition – Latest Version’. Click the ‘Download’ button.
You’ll then be taken to a new page and be prompted to hit ‘Download’ again, so click on this.
Once downloaded, you will be prompted to install. Before installing, please make sure you select the correct edition between ‘One World’ and ‘Standard’. One World is for those of you who use the subsidiaries feature, and Standard is for those of you who do not. Once you have selected the option relevant to you, click ‘Install’.
Once installed, you will now be running the latest version of Solution 7.
Before making any changes, you will first need to identify your current Role ID.
Log in to your NetSuite account.
Click on ‘Setup’ in your navigation menu and then from the drop-down select ‘Users/Roles’ and then ‘Manage Roles’.
Within this page, scroll down until you find the Solution 7 Reporting role and click on it.
Within the role, the simplest place to get the Role ID is from the URL at the top of the page. It’ll appear as ‘id=’ followed by the relevant numbers. In the video example, Simon demonstrates how to find his Role ID, which appears as ‘1071’.
Now open a new Excel Spreadsheet and within the Solution 7 tab, select ‘Configure’.
Within the configure dialogue, select the ‘Advanced’ button and within the Advanced Settings pop-up, you should see an option for ‘Role ID’.
You will then need to input your Role ID, and in the video example, Simon inputs his Role ID as ‘1071’ as previously identified.
Click ‘Close’ and then ‘Ok’.
Select the ‘Activate’ button within the Solution 7 tab.
Once loaded, you should now be running version 4.12 of Solution 7.
If you have followed all the steps above and still have any questions or concerns, please refer to the troubleshooting section of the video, where we answer some frequently asked questions and provide additional help.
Comments