LaborChart

The LaborChart Developer Hub

Welcome to the LaborChart developer hub. You'll find comprehensive guides and documentation to help you start working with LaborChart as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Sage 300 Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Sage 300 into LaborChart only

Sync Frequency

  • Twice daily

Connection Requirements

🚧

Your Sage 300 environment must be replicated to a SQL database

In order to begin the integration process your Sage 300 instance must be replicated to a SQL database. LaborChart will not perform the replication, but Sage does offer a free first-party replication tool that can assist with this.

  • Accessible IP address or URL
  • Set of read-only SQL credentials
  • Database name

Provided

  • Four LaborChart outbound IP addresses will be provided during implementation and will need to be whitelisted

Commonly Used Sage 300 Fields and Tables

📘

Note

Your Sage 300 database may feature tables and fields with naming conventions altered slightly from what is listed below. This list is intended to be a baseline/template and the integration will be tailored to match your system exactly.

People

LaborChart FieldSage FieldSage Table
First NameEmployee_NamePRM_MASTER__EMPLOYEE
Last NameEmployee_NamePRM_MASTER__EMPLOYEE
Status (Active, Pending, or Inactive)Termination_Date // Rehire_DatePRM_MASTER__EMPLOYEE
Employee IDEmployeePRM_MASTER__EMPLOYEE
Address 1Address_1PRM_MASTER__EMPLOYEE
CityCityPRM_MASTER__EMPLOYEE
StateStatePRM_MASTER__EMPLOYEE
ZipcodeZip_CodePRM_MASTER__EMPLOYEE
Phone NumberPhone_NumberPRM_MASTER__EMPLOYEE
EmailEmail_addressPRM_MASTER__EMPLOYEE
Date of BirthBirth_DatePRM_MASTER__EMPLOYEE
Hired DateHire_DatePRM_MASTER__EMPLOYEE
GenderGenderPRM_MASTER__EMPLOYEE
Job TitleTitlePRM_MASTER__EMPLOYEE

Projects

LaborChart FieldSage FieldSage Table
Project NameDescriptionJCM_MASTER__JOB
Status (Active, Pending, or Inactive)StatusJCM_MASTER__JOB
Project IDJobJCM_MASTER__JOB
Address 1Address_1JCM_MASTER__JOB
Address 2Address_2JCM_MASTER__JOB
CityCityJCM_MASTER__JOB
StateStateJCM_MASTER__JOB
ZipcodeZIP_CodeJCM_MASTER__JOB
Start DateActual_Start_DateJCM_MASTER__JOB
Est. End DateActual_Complete_DateJCM_MASTER__JOB
Project TypeTypeJCM_MASTER__JOB
CustomerNameMASTER_ARM_CUSTOMER
Project ManagerProject_ManagerJCM_MASTER__JOB

Have questions? Reach out to us at [email protected]