Sage 100 Contractor Integration

Clearstory now offers an integration with Sage 100 Contractor! This integration allows you to automatically create new projects from Sage into Clearstory, as well as push CORs into new or existing Change Orders.

To set up the Sage 100 Contractor and Clearstory Integration - Please contact Clearstory Support at support@clearstory.com.  

After initial set up is complete with our support team, below are the two ways to set up Sage 100 Contractor jobs and Clearstory projects.

Project Mapping

Mapping Sage 100 Contractor Jobs with Existing Clearstory Projects

If you are currently using Clearstory Projects and want to link them to current Sage 100 Contractor jobs follow the steps below.

  • Select your project in Clearstory 
  • Under Advanced Settings select Sage 100
  • Select Edit then select the Sage 100 Contractor job you would like to map this project to

map_sage100 (1)-1

 

Creating a Job in Sage 100 Contractor before creating an Clearstory Project 

If you are creating a new Sage 100 Contractor job and there is not an Clearstory Project follow the steps below. 

When you create the job in Sage 100 Contractor, it will automatically create a project within Clearstory.

  • Create the job in Sage 100 Contractor
  • Select the Projects tab then Imported Projects

imported projects

  • Accept (or Reject) the project in Clearstory. 

Accepting the imported project will automatically create the Clearstory project and map to the Sage 100 Contractor job


 

Syncing COR's from Clearstory to Sage 100 Contractor

  • Select to COR's from the Change Order Log you would like to import into Sage 100 Contractor
  • Then select + Add to Sage 100

1-select CORs (1)

Select the Change Order it is related to in Sage 100 or Create a Change Order in Sage 100

 

To Select a COR from Sage 100 Contractor:

  • Select the COR from Sage 100 Contractor then select Next

2.1-CO selected (1)

To Create a New Change Order in Sage 100 Contractor:

  • Select Create Change Order

2-select Sage 100 CO (1)

  • Complete necessary information to create Change Order in Sage 100 Contractor

create co in extracker (1)
  • After Selecting the Change Order from Sage 100 Contractor or creating a Change Order in sage 100 Contractor - Select the Sage 100 Contractor Cost Codes

3-assign codes (1)

  • Select the Sage 100 Contractor Cost Type

3.1-code dropdown (2)

  • Complete the Budget and Sub Change Details for Sage 100 Contractor
    • Sage 100 Contractor Cost Code
    • Sage 100 Contractor Cost Type
    • Sage 100 Contractor Multiplier

4-assign codes for breakdown (1)

Select the Sage 100 Contractor Cost Code first to generate Sage 100 Cost Type options

  • Select Push To Sage 100

Updates into Sage 100 Contractor from Clearstory sync every 5 minutes.

Updates from Sage 100 Contractor to Clearstory sync every 30 minutes.

It can take anywhere between 5 - 30 minutes for all information in Clearstory and Sage 100 Contractor to be updated.