Installing SEI for Sage 300 Embed

This topic describes how to install, activate, update, and uninstall SEI for Sage 300 Embed.

To install the application:

  1. Run the application SEI for Sage 300 Embed.exe.

  2. In the Welcome screen, click Next.

  3. In the License Agreement screen, click I Agree.

  4. In the Ready to Install screen:

    1. Choose whether or not to restart the Sage CNA Windows Service and the Sage 300 Application Pool after the installation is completed. If you remove this option, your server will need to be restarted before using SEI for Sage 300 Embed.

    2. Click Install.

  5. In the Installing screen, wait for SEI for Sage 300 Embed to be installed. This may take a few minutes.

  6. Once SEI for Sage 300 Embed is installed, check the box to agree to read the documentation and click Browse Documentation.

During the installation, several new folders and files are created in the Sage 300 directory:

  • A new folder with files is created in Sage300\RI69A (Sage 300 2022) or Sage300\RI70A (Sage 300 2023).

  • Files are added in Sage300\Online\Web\App_Data\MenuDetail and Sage300\Online\Worker.

To activate the SEI for Sage 300 Embed module

You need to activate the module before using SEI for Sage 300 Embed.

Note:  This step is only required for the first installation.

  1. Open Sage 300 and find the code of the Sage 300 company using SEI for Sage 300 Embed. If you have several companies, you will have to activate the module through the CSAPP table for each company.

  2. An SQL script needs to be run in the dbo.CSAPP table of the company database in which SEI for Sage 300 Embed is being used. The SQL script depends on the version of Sage 300 installed:

    For Sage 300 2022

    Replace COMPANY_CODE with the code of the Sage 300 company.

    INSERT INTO dbo.CSAPP
     

    (SELECTOR

    ,SEQUENCE

    ,AUDTDATE

    ,AUDTTIME

    ,AUDTUSER

    ,AUDTORG

    ,PGMID

    ,PGMVER

    ,DATALEVEL)
    VALUES

    ('RI',

    '00',

    CONVERT(DECIMAL(9,0), CONVERT(VARCHAR, GETDATE(),112)),

    CONVERT(DECIMAL(9,0), REPLACE(CONVERT(VARCHAR, GETDATE(),14),':','')),

    'ADMIN',

    'COMPANY_CODE', /*Place the Sage 300 company code here*/

    'RI',

    '69A',

    0);

    For Sage 300 2023

    Replace COMPANY_CODE with the code of the Sage 300 company.

    INSERT INTO dbo.CSAPP
     

    (SELECTOR

    ,SEQUENCE

    ,AUDTDATE

    ,AUDTTIME

    ,AUDTUSER

    ,AUDTORG

    ,PGMID

    ,PGMVER

    ,DATALEVEL)
    VALUES

    ('RI',

    '00',

    CONVERT(DECIMAL(9,0), CONVERT(VARCHAR, GETDATE(),112)),

    CONVERT(DECIMAL(9,0), REPLACE(CONVERT(VARCHAR, GETDATE(),14),':','')),

    'ADMIN',

    'COMPANY_CODE', /*Place the Sage 300 company code here*/

    'RI',

    '70A',

    0);

To uninstall SEI for Sage 300 Embed

  1. In the Welcome screen, read the note about the Sage CNA Windows Service and the Sage Application Pool that must be stopped before the uninstallation can proceed.

    1. Click the check box to proceed with the uninstallation.

    2. Click Uninstall.

  2. In the Uninstalling screen, wait for SEI for Sage 300 Embed to be completely uninstalled. This may take a few minutes.

  3. In the final screen, click Exit.

To update SEI for Sage 300 Embed

When SEI for Sage 300 Embed is already installed and you have an updated version of the installer:

  1. Uninstall the previous version.

  2. Run the new installer following the same installation process.

  3. Open Sage 300 and select SEI Settings > Menu Configurator and Save the menu to make the left menu visible again.

To update SEI for Sage 300 Embed from Sage 300 2022 to Sage 300 2023

  1. Uninstall SEI for Sage 300 Embed.

  2. Run the following SQL script in the dbo.CSAPP table of each company database in which SEI for Sage 300 Embed is being used.

     

    UPDATE dbo.CSAPP

    SET PGMVER = '70A'

    WHERE SELECTOR = 'RI'

  3. Ensure you have the latest version of the installer.

  4. Run the new installer following the same installation process.

  5. Open Sage 300 and select SEI Settings > Menu Configurator and Save the menu to make the left menu visible again.