Company Info

Sage 100 Contractor Data Integration Suite

Sage 100 Contractor Data Integration Suite Logo
Sage Development Partner
Overview
Key Features
Data Integration Points
Sample Integrations
User Interface
Installation Requirements

Overview:

Integrate virtually any data back into Sage 100 Contractor. Whether your data comes from Excel, a 3rd Party vendor solution or a custom application, integrating data back into Sage 100 Contractor has never been easier.

There is no need to be constrained by Sage 100 Contractor, the Sage 100 Contractor Data Integration suite allows you to work where, when and how you want to work.

Key Features:


Data Integration Points:



General Ledger:
1-3 Journal Transactions


Accounts Receivable:
3-2 Receivable Invoices/Credits
3-5 Jobs
3-5 Job Contacts
3-6 Clients
3-6 Client Contacts


Accounts Payable:
4-2 Payable Invoices/Credits
4-4 Vendors
4-4 Vendor Contacts
Payroll:
5-2 Employees
5-5-1 Daily Payroll


Project Management:
6-2 Budgets
6-3 Cost Codes
6-4-1 Change Orders (Budget,Subcontract, Prime)
6-6-1 Purchase Orders
6-7-1 Subcontracts
6-9 Proposals


Equipment Management:
8-3 Equipment
8-4 Equipment Allocation

Sample Integrations:

  • Journal Entries - prepare complex and recurring journal entries outside of Sage 100 Contractor in Excel or Google Sheets. Having the ability to use a spreadsheet to prepare journal entries has several advantages. For instance, having the ability to iteratively save your work, or the ability to start and stop what you're doing as frequently as you'd like without worrying about losing what you've done. Moreover, the ability to work at your own pace while not monopolizing valuable and limited Sage licenses can make preparing journal entries so much more efficient and cost effective.

  • Budgets - prepare your budgets in Excel or Google Docs. This is what spreadsheets were designed for. Not only can you take advantage of the advanced budgeting and proforma features of a spreadsheet but it will enable you to more easily collaborate with others in your organization to prepare and finalize your budgets. Once you're finished simply import the budget into Sage 100 Contractor.

  • Timecard Entry - use a 3rd party time entry system or Excel to prepare and capture field time. Import the time back into Sage 100 Contractor as a Daily Payroll. Eliminate the need to rekey time from an external timecard system into Sage 100 Contractor increasing the chance for human errors and incorrect payrolls.

  • CRM Integration - maintain a single list of contacts, clients, vendors, subcontractors in your CRM system or other source system such as an external Project Management system and integrate those contacts back into Sage 100 Contractor without maintaining and entering the same information in Sage 100 Contractor.

  • Purchase Orders - maintain and enter PO's in the field on a spreadsheet or 3rd party project management solution and import those PO's back into Sage 100 Contractor without manually re-keying the details.

  • AP Invoices - import AP Invoices either individually or in bulk from a spreadsheet or external system. For example, downloading PO invoicing detail from Home Depot or bulk supplier and importing the individual PO invoices back into Sage 100 Contractor in bulk. Another example would be to have subcontractors submit their payment applications via Excel and then import the invoice back into Sage 100 Contractor without rekeying the invoice details manually.

  • AR Invoices - import AR Invoices either individually or in bulk from a spreadsheet or external system. For example, bulk import recurring service contract invoices on a monthly basis rather than manually entering the individual invoices into Sage 100 Contractor.

  • User Interface:

  • Supports importing data into multiple company databases
  • Downloadable Excel Template for each Integration Point
  • Defined File Layout for each Integration Point




  • REQUEST A DEMO


    Installation Requirements:

    The Sage 100 Contractor Data Integration Suite is installed on the same server where Sage 100 Contractor is installed. The solution is developed on top of the Ei Dynamics BPM platform. Ei Dynamics is a data integration and workflow solution. A limited licensed copy of Ei Dynamics is included with the Sage 100 Contractor Data Integration Suite.

    • Sage 100 Contractor version 22.1 or higher (1)
    • Windows Server 2012 R2 or higher
    • Minimum of 16GB of RAM on the server
    • Minimum of 2 processors
    • SQL Server 2016 or higher (2)
    • IIS7 or greater
    • .NET 4.5.2

    (1) A compatible version of the Data Integration Suite is provided for each major version of Sage 100 Contractor starting with version 22.1. Please verify you have the correct version of the Data Integration Suite that is compatible with your version of Sage 100 Contractor before downloading and installing. Also, if upgrading Sage 100 to a newer version, make sure that a compatible version of the Data Integration Suite has been released for the version of Sage 100 Contractor being installed.

    (2) Sage 100 Contractor ships with SQL Server Express 2014, if SQL Server Express 2014 is installed it will need to be upgraded to SQL Server Express 2016 or higher. As long as SQL Express is being used there is no additional charge to upgrade and the compatible version can be downloaded and installed for free from Microsoft.


    Brochure Download: