• Archiving Employees - Employee # already exists in archive file.

    I want to move my past/terminated employees over to the archive folder, however there is already an archived employee with the same number of one I am looking to move. Any thoughts on what will happen, or what I can to to keep the records for both individuals…

  • SQL Replicator stops syncing in both Live or Scheduled modes, 18.1

    Hey everyone,

    First time poster here because we are in desperate need for assistance. Here's the rundown...

    - We had been using Sage 17.1 for 2 years until Nov. 2019. With it, we have the SQL Replicator running all the time, and though  "Scheduled…

  • Sage 300 Construction PO's

    I use a lot of queries to grab data out of Sage.  I have and use the PO/Commitments application.  Can someone tell me what table or where the table is to look at data there?  I can only find data in the Job after the PO has been committed and sent to Job…

  • Where are formulas being used

    I am trying to find out if there is a PSQL query or a report that I can run that will show me where formulas are being used - or if they are.  So, if a formula is being used, is it used in another formula, report, etc.  I have 100's of formulas & reports…

  • labor cost codes

    Does anyone know of a report that shows number of hours per year per cost code?

    Example how many hours at superintentant were logged in 2018?

  • Data export into salesforce

    Hi all,

    I don't have experience with sage, but am tasked with writing some automation for exporting sage 300 construction service manager data into salesforce. I'm here to ask mostly about the best way to export the data out of service manager - I've…

  • Slow ODBC Queries

    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…

  • Database Connection Error: HY000: when trying to add Master_PRM_Employee File to new crystal report.

    I am using Sage 300 CRE 13.1.24 (13.1.0 Rev 7).  I am using Crystal Reports XI Release 2 for Sage. I have my ODBC setup using my 32-bit ODBC administrator.  My problem is that when I try to create a new report, I can add any file I want in my database to the…

  • v13.1 and databases

    Hi folks,

    We're going to be upgrading to v13.1 here soon and I was wondering if anyone can confirm if Pervasive is the only option available for a database? I say a thread where someone said they were on SQL Server, I would prefer to use that over Pervasive…

  • QuickBooks Data migration to Sage 300 CRE

    Hi guys/ladies,

    We are just converting our accounting project management to BuilderMT and Sage 300 CRE.  Has anyone converted from QuickBooks and migrated their data from QB to Sage?  If you did, how did you do it?  Who did you use to do it?

    Rick M

  • How to explore Sage tables for reporting purposes (Office Connector and Crystal Reports)

    I am starting out on Sage 300 Construction and Real Estate. Timberline/Sage is installed and I have a username and password to access the system.

    I can also connect via Office Connector to the data and therefore have an data connection string. I would…