SedonaOffice WeSuite Integrations

Here, you will find all of the current information about WeSuite and how it integrates with SedonaOffice.

Below is the main section to get everything set up from a development perspective. For non-development information regarding WeSuite, see the following files for more information:

Part 01 - Brief Overview.docx

Part 02 - Project Essentials.docx

Part 03 - Creating your first project.docx

Part 04 - Rolling up items.docx

Part 05 - Importing into SedonaOffice.docx

Part 1: Initial setup

  1. You will need to install Crystal Reports Runtime before using WeSuite. These can be downloaded from Oracle's Crystal Reports section (NOTE: You will need an Oracle account to download. The runtimes are free). You will need to install both of the following;
    • CR13SP30MSI32_0-10010309.MSI
    • CR13SP30MSI64_0-10010309.MSI
  2. You will also need either the demo WeSuite database or a blank WeSuite database. Reach out to michael.fazio@wesuite.com to get a copy of the blank database.
    NOTE: The database being used in the QA/Test environment is a Demo Database for WeSuite.
  3. You will need to copy the WeSuite folder from the location that gets updated to whichever environment. Unfortunately, all of these files are too large to upload.
  4. Basic steps to get WeSuite running:
    1. Install both runtimes for Crystal (mentioned above).
    2. Copy the WeSuite folder, and run the application for the first time. This will error out, and a "config" folder is created.
    3. Open the config folder, and edit the file called "WsUser.config". Fill in the below keys:
    4. If you fill in the settings (NOTE: Assuming the database backup was restored prior), You should be greeted with the following screen after logging in:

Part 2: Common settings in WeSuite Database/Front-End

  1. Once inside WeSuite, go to the following location: [Tools] => [Program Options] => [Accounting Interface].
  2. Fill out the [Database Server] and [Database Name] - This information will be for your SedonaOffice database instance.

Part 3: Common issues with WeSuite

[no content]

Part 4: SedonaOffice WeSuite Integration Setup

  1. Open SedonaOffice, and go to [Tools] => [WeSuite Setup]



    NOTE: If you do not see this option, then you can "force" the setting to be enabled with this SQL Statement:
    UPDATE SS_Setup_Modules SET In_Process = (In_Process + 'w')is
  2. In the next screen, fill in the details for the WeSuite database. Fun fact: Check that you can connect via SSMS first, as this box will essentially do the same thing. After filling in the details, press [Test Connection]. If all goes well, then you'll be allowed to press [Save].
  3. To make sure everything works, the easiest way to tell is to go into [Job Management] => [Job Queue] and Select the [WeSuite Orders] button. If anything is set up incorrectly, the screen will display an error.
Was this article helpful?
Thank you for your feedback!
User Icon

Thank you! Your comment has been submitted for approval.