eSUB Academy

Follow

Sage 100 Connector

eSUB has the ability to export approved hours from the eSUB project management system and import these approved hours into your Sage 100 Contractor account. 

Requirements: 

  • Job Numbers must match between eSUB and Sage, and must be numeric
  • Cost Code Numbers must match between eSUB and Sage, and must be numeric
  • Employee Numbers must match between eSUB and Sage, and must be numeric

Rules - The eSUB Sage 100 Connector supports adding records only, not updates. Therefore you cannot push a 2nd record for the same employee and project, on the same day.

Configure Sage 100 Contractor - There are a few steps you'll need to take in Sage 100 Contractor to ensure time can be pushed from eSUB to Sage. 

  • Uninstall any existing eSUB Sage 100 Connector if it exists. If it does not exist, you may have to do the following 2 Sage security steps
  • Set up Sage Security Group with a Group Name of exactly API. The Group # doesn't matter. We recommend 99.
  • Create a new User that has the security group of API. They must have a password. Remember that User Name and Password for the Connector setup later

 

Configure eSUB to export time to Sage 100

Enable Sage 100 in eSUB - You will first need to enable Sage 100 as your financial package in eSUB. Go to Navigate>Administration>Company Setup>Company Preferences>Accounting and use the drop down menu to select Sage 100.

  • Next make sure that under the project details in eSUB, the project has been set to "Payroll Live"

 

  • Important Note - For time to successfully push from eSUB into Sage 100 the following must be true:
    • Employee name, employee number must match in eSUB and Sage 100 Contractor. 
    • Project name and job number must match in eSUB and Sage 100 Contractor
    • Labor Activity code or Cost Code must match in eSUB and Sage 100 Contractor
    • Employee doesn't have an existing time record in Sage for the date you want to sync

Please follow the steps below to setup and configure the eSUB Sage 100 connector.

Enable Sage Connector Service To Login As Correct Sage 100 Contractor User - In order for time records to be successfully pushed into Sage, the connector service needs to login as the same Network Account that had the setup Sage 100 Contractor. 

Only do this step if the eSUB to Sage 100 Connector is installed on a different machine than the Sage 100 MB7 folder. The eSUB to Sage 100 Service which supports the Connector will need to run as a network account that has access to both machines, and the MB7 folder.

  • Configure Sage setup as network account
    • Use the search option to locate "Local Services" on your machine
    • Once local services has been opened locate the "eSUB Sage100 Synchronization Service"
    • Right click and select "Properties"
    • Select the Log On tab
    • Select "This Account"Enter the username and password of the Network Account that setup the Sage 100 Contractor program.
    • Apply changes
    • Restart Service

 

Configuring the Sage 100 Connector - Enter in the correct information for each field as outlined below. 

    •  Sage Database Drive: Use the drop down menu to select the correct drive your Sage 100 database is stored on. 
    • eSUB API: Please request the eSUB API web address from eSUB Support 
    • eSUB Client: Enter your eSUB subscriber code
    • eSUB Username: Enter your eSUB account username
    • eSUB Password: Enter your eSUB account password 
    • Company Name: Enter your Sage 100 account company name. Please use the name of the folder within the MB7 directory if it is different than your Sage Company Name
    • Username: Enter your Sage 100 account username
    • Password: Enter your Sage 100 account password

Running the Sage 100 Connector - Once you have saved the Connector configuration information, you're ready to begin pushing time from eSUB into Sage.

    • Click on the Synchronization Logging tab 
    • Make sure that your service lights are all green
    • Next you need approved and export hours in eSUB, click here for more information on this process
    • After you've exported approved hours click the "Start synchronization" button.  
    • The connector will then look for the exported hours file and being to push the employee hours into Sage 100. 

 

Things To Remember - For time to successfully push from eSUB into Sage 100 the following must be true:

  • Employee name and employee number must match in eSUB and Sage 100 Contractor. 
  • Project name and job number must match in eSUB and Sage 100 Contractor
  • Labor Activity code or Cost Code must match in eSUB and Sage 100 Contractor
  • Employee doesn't have an existing time record in Sage for the same project and date your attempting to sync

We have also created a troubleshooting guide that can help to address any issues that might come up with pushing time into Sage 100. Please see document attached to this article. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments