Sage Construction & Real Estate

I would like to integration third party system with Sage 100 Contractor using API to sync data between systems. Does Sage 100 Contractor have API?

I have a bunch of excel files that ready from different AP, AR, JC etc tables using a User DSN with the Timberline Data driver. Prior to upgrading today, they all worked. Since the upgrade, I'm getting an error that the "required credential settings are…

Hi folks, We have been searching for purchasing software that integrates with Sage 300 CRE for quite some time and it looks like Agora Systems may be a good fit for us. We don't currently use the purchasing module; we manually verify POs and enter everything…

I am trying to establish a ODBC connection to Sage 300 using Powershell ODBC. I am getting below error. I have tried using the same username and password for importing via ODBC in MS Access and it works. What am I missing? Exception calling "Open…

Does Sage 300 have an active integration with Microsoft Access, or is it a manual process? Which users rights are necessary to modify the integration, and change what is sent from Sage 300 to MS Access?

Many of us are not using SQL replicator as the hardware requirements are up there, server and client, and we have enough data that I believe we would need full SQL vs express. Especially if your accounting dept wants the data to be live.(which ours does…

The last HR software question in the discussion was 3 years old. My HR Department is asking me if Sage HRMS and/or Sage ESS will work with Sage 100 Contractor. Does anyone that currently uses 100 Contractor use another HR software package that integrates…

We set up SQL replication last week and it is working well. However I am having trouble finding where our HH2 imports actually end up in the SQL database. We import a HH2 payroll each week via the import tool in Payroll > Tools > Import Time... Where…

Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…

Hey Folks: Can anyone tell me about their experience working with Syscon or About Time as an alternative to Sage Service Operations as their mobile resource management tool? We have reached an impasse with SSO in terms of collecting time on equipment…

I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection. I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval…

Problem: ODBC Syntax error when referencing Check column of table APM_MASTER__INVOICE_PAYMENT.Check, while other columns respond as expected Background 32-bit ODBC driver – installed OK Sage Role/user verified – OK DSN – User DSN and System…

I am trying to automate archiving of the Log files generated by sage. We generate an average of 15,000 log entries a day and the LogViewer in sage is so slow it is nearly unusable after a month. I am querying the data older than seven days and then inserting…

Does anyone have any experience working with Concur Travel and Expenses software? Has anyone looked at integrating the Concur product with Sage 300 CRE?

I am having trouble connecting to timberline from my asp.net mvc 4 application. MY CODE String connection = "DSN=Timberline Data Source;Uid=<myusername>;Pwd=<mypassword>;"; OdbcConnection timberlineConnection = new OdbcConnection(connection); timberlineConnection…

Hello All, I have a problem I have been researching lately regarding slow queries over ODBC to our sage server. I have seen people with similar issues on other sites, but no real solutions.... We have a web server that uses PHP to query several database…