• Connecting via SQL

    I work for a software dev company that is setting up an application for a client. They have been using the Timberline Data driver (using ttsimba.dll) to create an ODBC DSN to their Sage 300 CRE data in Access and run some update queries. We are replacing…
  • Update ACA Dependent table through ADO and ODBC

    I use Excel VBA macros to update vairous tables. I have an Excel spreadsheet to update the ACA Dependents database for my 1095 preparation. Despite the SQL query only selecting one record for updating, when I update records it updates numerous records…
  • [SQLEngine] (31840)

    I am getting this error when trying to update Job Custom fields through ODBC. Has anyone seen this or know how to determine what the error is? Michelle Outler
  • Not able to Read .MKD FIle

    I am trying to read MKD file using pervasive odbc driver but i am not able connect pervasive odbc driver. anyone help me on this
  • SAGE 300 CRE and 64-bit ODBC or DSN. Possible?

    We're trying to set-up a workstation which would allow a 3rd party company (via Microsoft Runtime Integration, etc) to read data off our 300 CRE via the creation of 64-bit ODBC or DSN ... eventual goal is to get our Sage CRE database sending data to an…
  • Sage 300 CRE, automate adding employees to PR module

    Hi, I have been told by sage support that ODBC and MS Access can be used to add employees to the payroll module, but professional services must be engaged. I am wondering if anyone has used powershell or another scripting tool to add employees.
  • No data was returned by Sage Estimating Error: "Error Staging Data No data was returned by Sage Estimating. This could be caused if the estimate you selected is currently open (locked) in Sage Estimating. Close the estimate and then try again.&quo

    Error retrieving data for an estimate. Error: "Error Staging Data No data was returned by Sage Estimating. This could be caused if the estimate you selected is currently open (locked) in Sage Estimating. Close the estimate and then try again…
  • Company Folders Blank in a new installation

    Hello One of our workstations crashed and we have currently installed 20.5 version of Sage 300 CRE (there are no other versions on this workstation). The server is also on 20.5 which we upgraded from 18.4 to 20.5 In the workstation, the install completed…
  • Can you use Crystal Reports to change the value of fields in Sage 300 CRE...?

    If this is not possible what would the best way to accomplish this? I have the Certified Class description i want to assign to the Occupation field on the Master Employee Record, we would like them to match and currently they do not. Thanks V
  • Bank account created in CM is not showing in AP when trying to generate crystal reports.

    We have created a new bank account in CM module and the transactions are correct going but when trying to generate crystal report in AP module the particular bank name is not listed.The CM and AP module details and not sync. In order to generate crystal…
  • Creating upload files for Arcoro...

    We are in the process of moving to Arcoro HR and I have been building imports for this. Two of the imports concern pre/post 2020 employee tax info, and some of the data required is Year, Additional Withholding, Filling Status for that year, Exempt or…
  • What table in the DB has all the Job Setup Change Management information

    What table in the DB has all the Job Setup Change Management information - looking for the table that has the markup grid
  • Remote App - ODBC

    We recently change IT Providers and they are now hosting our servers. We access Sage via Remote App. They have created a separate Excel app I have to use (Remote App) that I am to use for ODBC. I know we have updated Excel and Sage but holy-moly - either…
  • Service Management Data Dictionary and ODBC Connector?

    I can connect to Sage 300 tables via the Sage 300 ODBC connection ; however, the ODBC Connection doesn't have access to any Service Management tables. Is there a different method for connecting to the S.M. tables. Finally, where can I get a list of the…
  • ODBC does not like other passwords except for "password"

    Hello, I'm trying to set up a connection to a Sage300CRE company using a "DSNLess" ODBC connection. It appears that the only password it will accept without giving me an ERROR [28000] [Sage][SQLEngine] (31830) Username and password is required - is…
  • Crystal Reports Fundamentals Training

    I have started Sage University's SAP Crystal Reports Fundamentals training and am having issues connecting Crystal Reports to Sage 300 CRE. I have the trial version of Crystal Reports and Sage 300 CRE. I have configured the Timberline Data Source in ODBC…
  • Crystal Report Formulas

    Employee Emp Name Per Begin Date Period End Date Fringe ID Amount Deduction ID Amount 1001 Jackson, One 1/4/2021 1/10/2021 MEDEMP $ 220.00 MED01 $ 95.00 1003 Jackson, Three 1/4/2021 1/10/2021 MEDEMP…
  • Is there a way to auto-generate a value in a new WBS code based on values in other WBS Codes?

    I have a field that I'd like to generate in Sage that is based on other manually entered values in Sage WBS codes. I could do this in excel utilizing a concatenate function, but I'd like to do it all in one place, if possible. Does anyone know if it's…
  • error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM"

    In Database Admin, restoring a Client's backup, I am getting an error, "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM" What is this? I write reports, and get client databases to work in. This is the first time…
  • Using an Excel OCBC SQL execute - Can you run multiple update statements to update entries in a Table?

    Using excel 2019, Sage CRE 300 18.2 I want to update hundreds of payrates via script instead of plugging each one in via user interafce. Tested this and it works fine for 1 update: UPDATE PRS_SYSTEM__PAY_RATE_TABLE SET Rate = 25.00 WHERE Pay_Table_Key…
  • Write Over Contract Value in Job Master from Office Connector

    It doesn't look like there is an ability to use the Write function to update the Original Contract Amount in the JC Job (1) Master table from Office Connector. Is this something that we are able to add in? We would like to keep this field updated for…
  • PJ Field Reports Labor Table Fields using ODBC

    I'm trying to pull records from the PJ Field Reports Labor Table in Crystal but I'm unable to figure out how the employee is being linked. Does anyone know what table is being used to link the employee to the PJ Field Reports Labor table?
  • Accessing Sage 300 CRE Data from the Web - Error [28000][Sage][SQL Engine](31830)Username and Password is required

    We are accessing Sage 300 CRE data in a web page using the ODBC 32 bit driver we set up as a system dnn (TMBWeb). The dsn points to the correct data folder and is configured for standard descriptions and maximum table segment size. We have a connection…
  • 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…
  • 35 tables are not loading to timberline database

    FormerMember
    FormerMember
    I am querying the Timberline replicated database located on the Kettler “ktlrhq-db1.corp.ketsco.com” SQL Server instance. I need to perform several queries into this database. This query returns total amounts for each cost code, section and job: …