SAP Business One prerequisites

Boyum Cloud works as an extension to SAP Business One.

Before the Boyum Cloud setup, an SAP Business One environment must be set up with the following parameters:

  • SAP Business One version 9.3
  • SAP HANA
  • SAP Business One Service Layer

or

  • SAP Business One version 10.0
  • MS SQL
  • SAP Business One Service Layer

Some object types must be enabled in the Post Transaction Notice in SAP Business One. For details, see SAP Business One synchronization.

Connect to the SAP Business One Service Layer

Boyum Cloud connects to SAP Business One using the SAP Business One Service Layer. The SAP Business One Service Layer needs to be accessible from Boyum Cloud. Firewall and routing rules must be put in place to ensure that the SAP Business One Service Layer is accessible from Boyum Cloud.

Boyum Cloud connects to the SAP Business One Service Layer from several IP addresses. The IP addresses depend on the region. For details about regions, see the Boyum Portal database setup. To connect, open all the IP addresses for the SAP Business One Service Layer.

For the Europe West region, the following IP addresses must be open for Boyum Cloud to be able connect to the SAP Business One Service Layer.

Kubernetes cluster:

  • 52.157.105.189
  • 52.236.169.11

Setup SAP Business One company database

User-defined tables and stored procedures need to be created in the SAP Business One company database for the data synchronization between SAP Business One and Boyum Cloud to be possible.

These objects can be created in 2 different ways:

Database setup using the Boyum Cloud Installer add-on

The Boyum Cloud Installer add-on creates user-defined tables and procedures in the SAP Business One company database. These tables and procedures are required for the data synchronization between SAP Business One and Boyum Cloud.

  1. Click the following link to download the Boyum Cloud Installer add-on.
  2. Install the add-on in SAP Business One in Administration > Add-on Administration.
  3. Go to Administration > Add-on Manager and start Boyum Cloud.Prompts warns you that SAP Business One and the SAP HANA Service Layer (SAP Business One Service Layer) must be restarted.
  4. Restart SAP Business One. The SAP HANA Service Layer (SAP Business One Service Layer) will be restarted in step 6 of this process.
  5. Start the add-on again to check that the Boyum Cloud Installer add-on performed the following operations correctly in the background. You must get the green confirmation message.
    Important: Never manually update the content of these tables.
    • Creates user-defined tables.
      • @BOY_SBO_...: These tables are required for all Boyum add-ons, and they are not specific to Boyum Cloud
      • @BOY_CLOUD_CONFIG: The table is used to track the installation status and version.
      • @BOY_CLOUD_NOTI_TYPE: The table stores the transaction types that should be synchronized to Boyum Cloud.
      • @BOY_CLOUD_NOTICE: The table stores the transactions, except inventory transactions, waiting for synchronization to Boyum Cloud. Records are deleted automatically after synchronization.
      • @BOY_CLOUD_WAREHOUSE: The table stores the inventory transactions waiting for synchronization to Boyum Cloud. Records are deleted automatically after synchronization.
    • Creates the BOY_SP_CLOUD_POSTTRANSACTIONNOTICE procedure, which copies data to be synchronized into the @BOY_CLOUD_NOTICE and @BOY_CLOUD_WAREHOUSE tables.
    • Updates the SBO_SP_POSTTRANSACTIONNOTICE stored procedure, so it calls BOY_SP_CLOUD_POSTTRANSACTIONNOTICE.
  6. Restart the SAP Business One Service Layer. This is required, as new user defined tables were added.
    1. Login as root on the HANA server.
    2. Execute the following command:
      /etc/init.d/b1s restart

After this procedure is finished, use the Install using add-on option after logging into the database in Boyum Cloud to verify the installation and continue the set up process.

Database setup without the Boyum Cloud Installer add-on

When Boyum Cloud first connects to a database, it checks whether the necessary objects exist and are available.

User-defined tables are created automatically through the SAP Business One Service Layer, but the stored procedures must be created manually.

The setup process is performed by the Boyum Cloud database selection screen.

  1. Go to Boyum Cloud and log in to the database. 
  2. Choose the Manual installation option.

  3. Boyum Cloud creates user-defined tables.

  4. Boyum Cloud verifies whether the user-defined tables are available through the SAP Business One Service Layer.

    If the user-defined tables exist in the SAP Business One company database, but are not available through the SAP Business One Service Layer, the SAP Business One Service Layer might have to be restarted manually.

    To manually restart the SAP Business One Service Layer:

    1. Login as root on the HANA server.
    2. Execute the following command:
      /etc/init.d/b1s restart
  5. If the stored procedures are not yet created, create them manually:
    • Creating stored procedures in the SAP Business One company database – HANA
    • Creating stored procedures in the SAP Business One company database – MSSQL
  6. Boyum Cloud verifies whether the Boyum Cloud stored procedures are created and activated.

SAP Business One license requirements

One SAP Business One Indirect access, user-based (or higher) license is required for each SAP Business One user of Boyum Cloud.

One additional SAP Business One Indirect access by non-employees user license is required during the database setup that is used for background processes. See, Setup Boyum Cloud in the Boyum Portal for details.

For example, if 5 employees need to log in to Boyum Cloud, 5 SAP Business One Indirect access, user-based (or higher) licenses are requried for the users, plus 1 SAP Business One Indirect access by non-employees license is needed for the background process.

SAP Business One authorizations

SAP Business One users need authorizations corresponding to the SAP Business One objects they are working with. See the list of objects in SAP Business One synchronization.