coresuite onPremise products, Upgrade/Installation for SAP Business One 9.1 (and 9.2/9.3, if upgrading from lower than 9.1) – Helpdesk

Introduction

As per SAP Note 2056808 - New addition SAPBusinessOneSDK.dll in Business One version 9.1, SAP introduced a new dll (SAPBusinessOneSDK.dll) which is a combination of SAPbobsCOM.dll and SAPbouiCOM.dll.

Due to this change, we had to recompile all our modules to reference to the new dll instead of the two old ones. In order to be able to use coresuite onPremise products on SAP Business One 9.1 and later, a special procedure needs to be followed when

upgrading an existing SAP Business One installation to version 9.1 where coresuite onPremise products are installed
installing coresuite onPremise Products on a new SAP Business One 9.1 installation

This also means that from version SAP Business One 9.1 the coresuiteSAPDlls are no longer needed.

We strongly recommend following the steps below exactly to ensure a smooth and happy transition!

Prerequisites

onPremise Products

Ensure that you have at least 9.1 PL04 (or the respective GA version of your SAP Business One Release!) installed – previous Patchlevels are NOT be supported
When running the OnPremise products on 64-bit SAP Business One Clients Applications, the 32-bit DI-API should also be installed also
Ensure that your own/custom modules are recompiled as described in section "Compatibility with own/custom modules" at the end of this very FAQ

in case you were still using a coresuite version lower than 4.00 on your SAP Business One installation prior to your upgrade to 9.1, please ensure that you also compile your modules against Microsoft® .NET Framework 4.0

Recommended Upgrade Procedure

We recommend to always create a backup of your company and coresuite (SQL only!) database, export your customize rules and layouts as good practice before performing any upgrade.

A) Upgrading an existing SAP Business One installation to version 9.1 (or higher) where coresuite onPremise products are already installed

If you are using the 32-bit and 64-bit SAP Business One Client Applications at the same workstation (server), you will need to perform Step 3 through to Step 5 (HANA: Step 2 to Step 4) first via the 64-bit SAP Business One Client Applications, then with the 32-bit SAP Business One Client Applications. Only after you have performed the removal procedure on both Client Applications, you can proceed with Step 6!

SQL environment (onPremise only)

Backup coresuite database
Stop the coresuite add-on (double-check via Taskmanager that NO coresuite process is still running!)
Remove the coresuite add-on via Administration->Add-Ons->Add-On Administration=>"Remove Add-On"
Restart SAP Business One via right-click->Run as Administrator to complete the uninstall process
Verify the coresuite application is fully removed from your SAP Business One Client application
Check %ProgramFiles(x86)%\SAP\SAP Business One\AddOns\ (%ProgramFiles%\SAP\SAP Business One\Addons\) for remaining COR and/or coresuite folders; should they still exists, please delete them.
Delete coresuite database
Download the respective coresuite installer for your SAP Business One version from our download area, register and install it.

if you are installing in a 32-bit SAP Business One applications, use the installer marked "Installer for SAP Business One 32-Bit Client Application"
if you are installing in a 64-bit SAP Business One applications, use the "Installer for SAP Business One 64-Bit Client Application"

Start the coresuite add-on
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management

HANA and SQL (onDemand only) environment

Stop the coresuite add-on (double-check via Taskmanager that NO coresuite process is still running!)
Remove the coresuite add-on via Administration->Add-Ons->Add-On Administration=>"Remove Add-On"
Restart SAP Business One via right-click->Run as Administrator to complete the uninstall process
Verify the coresuite application is fully removed from your SAP Business One Client application
Check %ProgramFiles(x86)%\SAP\SAP Business One\AddOns\ (%ProgramFiles%\SAP\SAP Business One\Addons\) for remaining COR and/or coresuite folders; should they still exists, please delete them.
Remove the @SWA_MODULES table via Tools->Customisation Tools->User-Defined Table - Setup
Download the respective coresuite installer for your SAP Business One version from our download area, register and install it.

if you are installing in a 32-bit SAP Business One applications, use the installer marked "Installer for SAP Business One 32-Bit Client Application"
if you are installing in a 64-bit SAP Business One applications, use the "Installer for SAP Business One 64-Bit Client Application"

Start the coresuite add-on
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management

B) Installing coresuite onPremise Products on a new SAP Business One 9.1/9.2/9.3 installation

Download the respective coresuite installer for your SAP Business One version from our download area, register and install it.

if you are installing in a 32-bit SAP Business One applications, use the installer marked "Installer for SAP Business One 32-Bit Client Application"
if you are installing in a 64-bit SAP Business One applications, use the "Installer for SAP Business One 64-Bit Client Application"

C) Upgrading coresuite modules AFTER following initial installation/upgrade on 9.1/9.2/9.3

Only once coresuite has been installed with the correct installer for respective SAP Business One Version, the modules can be updated to later versions. The respective sip versions for each module can be downloaded automatically and installed via the coresuite administration.

In case you need to download newer sips manually (e.g. due to Network restrictions in your environment), remember to ensure that you select the correct SAP Business One version at the top of our download page - DO NOT try to import the sips that are compiled for use with 8.82/9.0!

D) General points to remember

Uninstalling the add-on will have no impact on your current settings (e.g. your layouts and customize rules).
The coresuite uninstall process can be performed before but also after the SAP Business One Upgrade to 9.1/9.2/9.3; the install process with the respective installer can only be performed after the SAP Business One Upgrade to 9.1/9.2/9.3
Please note that if you do not follow the above procedure step by step, you will encounter coresuite customize compiler errors and layouts containing Hyperlinks will fail to print/preview.
After replacing the coresuite installer as described above, each SAP Business One Client application of each workstation will need to be started once via right-click run as Administrator, so the installer can be automatically replaced on each SAP Business One Client application. The uninstall and the new install will run automatically.

What to do in case something goes wrong

(e.g. system still looking for "coresuiteSAPDlls", or strange behaviour when printing, unexplained error messages, error message in only one of a number of databases in the same environment etc)

We recommend to always create a backup of your company and coresuite (SQL only!) database, export your customize rules and layouts as good practice before performing any upgrade before performing any upgrade or fix.
On Terminal Servers, please remember to switch to install mode, before attempting either of the options below.
Please note that if you do not follow the above procedure step by step, you will encounter coresuite customize compiler errors and layouts containing Hyperlinks will fail to print/preview.
We have listed two options each for SQL and HANA environments. No matter which option you choose, you need to ensure that you perform ALL the steps from the chosen option! If you leave out any step, you need to repeat the chosen option until the issue is resolved. Option 1 is always the prefered approach. If neither options helped to solve the issue (especially in cases where the system might still be looking for "coresuiteSAPDlls") considered reinstalling your SAP Business One Client Application.

SQL environment (onPremise only)

Option 1

Backup coresuite Database
Start SAP Business One via right-click->Run as Administrator
Uninstall the coresuite add-On (double-check via Taskmanager that NO coresuite process is still running!)
Connect to SQL Server and run the following query: DELETE FROM [coresuite].[dbo].[modules] => this will empty the modules table in the coresuite database
Verify the coresuite application is fully removed from your SAP Business One Client application
Check %ProgramFiles(x86)%\SAP\SAP Business One\AddOns\ (%ProgramFiles%\SAP\SAP Business One\Addons\) for remaining COR and/or coresuite folders; should they still exists, please delete them.
Download the respective coresuite installer for your SAP Business One version from our download area, register and install it.

if you are installing in a 32-bit SAP Business One applications, use the installer marked "Installer for SAP Business One 32-Bit Client Application"
if you are installing in a 64-bit SAP Business One applications, use the "Installer for SAP Business One 64-Bit Client Application"

Start the coresuite add-on
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management
If the above steps do not solve the issue for you, please contact support via helpdesk.coresystems.ch

Option 2 (recommended for advanced users only!)

If you are certain that you used the correct installer, you can simply follow the steps below:

Backup coresuite Database
Close SAP Business One
Open SQL Management Studio, go to the coresuite db and right-click on the "modules" table selecting "Edit Top 200 Rows"
Highlight all rows of modules version < 4.6x; ensure that you include any rows with the "coresuiteSAPDlls"
Delete the selected rows
Go to %ProgramFiles(x86)%\SAP\SAP Business One\ (%ProgramFiles%\SAP\SAP Business One\) and modify the AddOnsLocalRegistration.sbo by removing all coresuite entries
Go to %ProgramFiles(x86)%\SAP\SAP Business One\AddOns (%ProgramFiles%\SAP\SAP Business One\AddOns) and remove the COR folder
Start SAP Business One via right-click->run as Administrator
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management
If the above steps do not solve the issue for you, please contact support via helpdesk.coresystems.ch

HANA and SQL (onDemand only) environment

Option 1

Start SAP Business One via right-click->Run as Administrator
Uninstall the coresuite add-On (double-check via Taskmanager that NO coresuite process is still running!)
Remove the @SWA_MODULES table via Tools->Customisation Tools->User-Defined Table - Setup
Verify the coresuite application is fully removed from your SAP Business One Client application
Check %ProgramFiles(x86)%\SAP\SAP Business One\AddOns\ (%ProgramFiles%\SAP\SAP Business One\Addons\) for remaining COR and/or coresuite folders; should they still exists, please delete them.
Download the respective coresuite installer for your SAP Business One version from our download area, register and install it.

if you are installing in a 32-bit SAP Business One applications, use the installer marked "Installer for SAP Business One 32-Bit Client Application"
if you are installing in a 64-bit SAP Business One applications, use the "Installer for SAP Business One 64-Bit Client Application"

Start the coresuite add-on
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management
if the above steps do not solve the issue for you, please contact support via helpdesk.coresystems.ch

Option 2 (recommended for advanced users only)

If you are certain that you used the correct installer, you can simply follow the steps below:

Remove the @SWA_MODULES table via Tools->Customisation Tools->User-Defined Table - Setup
Go to %ProgramFiles(x86)%\SAP\SAP Business One\ (%ProgramFiles%\SAP\SAP Business One\) and modify the AddOnsLocalRegistration.sbo by removing all coresuite entries
Go to %ProgramFiles(x86)%\SAP\SAP Business One\AddOns (%ProgramFiles%\SAP\SAP Business One\AddOns) and remove either the whole COR folder OR the folder within %ProgramFiles(x86)%\SAP\SAP Business One\AddOns\COR\coresuite (%ProgramFiles%\SAP\SAP Business One\AddOns\COR\coresuite)
Start SAP Business One via right-click->run as Administrator
Start the coresuite add-on
Download and install the latest available versions of each module sip via Administration->Add-ons->coresuite administration->Administration->Sip Management
if the above steps do not solve the issue for you, please contact support via helpdesk.coresystems.ch

Compatibility with own/custom modules

Own/custom modules which were compiled for SAP Business One versions prior to 9.1 will not work with SAP Business One 9.1/9.2/9.3.

Before upgrading your Productive systems to SAP Business One 9.1/9.2/9.3, please ensure that all your own/custom modules are recompiled.

To recompile your own/custom modules, you will need to

remove the reference to SAPbobsCOM.dll and SAPbouiCOM.dll in your project and reference to SAPBusinessOneSDK.dll instead
use the development version of the framework dlls for running coresuite onPremise products on SAP Business One 9.1/9.2/9.3 which can be downloaded from here.