Sage 100 Contractor Data Integration Suite
Data Integration Points
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.
- Over 25 pre-built Excel templates, one for each Data Integration point.
- Single click installation. No implementation or consulting required. Simply, download, install and start using
- Control user access by integration point
- REST API available for programmers, web developers and 3rd party solutions providers to build seamless integrations
- Work when, where and how you want
Data Integration Points:
1-3 Journal Transactions
3-2 Receivable Invoices/Credits
3-5 Job Contacts
3-6 Client Contacts
4-2 Payable Invoices/Credits
4-4 Vendor Contacts
5-5-1 Daily Payroll
6-3 Cost Codes
6-4-1 Change Orders (Budget,Subcontract, Prime)
6-6-1 Purchase Orders
8-4 Equipment Allocation
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.
Supports importing data into multiple company databases
Downloadable Excel Template for each Integration Point
Defined File Layout for each Integration Point
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.