• 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.
  • 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…
  • 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…
  • 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
  • Sage 300 CRE JDBC connection via Pervasive

    I am trying to connect to Sage 300 CRE via JDBC. I understand that Sage is built on pervasive and I am able to connect to the default pervasive database called demodata and read tables. i am looking for guide to read Sage specific tables using this…
  • 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…
  • 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…
  • Customer Crystal Report Date Parameter Wrong on 1/4 computer

    I have a custom Crystal Report that I created and when entering the same date parameter on 4 computers, one will show the wrong information. Example: 09/01/2019 - 09/20/2019 (September 1, 2019 - September 20, 2019) 3 computers bring up the same correct…
  • Any way to empty Sage 300 CRE log file?

    In log viewer it is possible to Archive & Delete but it is extremely slow, only being able to handle 200,000 records at a time and the archive only writes 10,000 per file. I don't want to archive, I just want to delete. I have tried ODBC connect and using…
  • 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: …
  • Table and Field Naming mode - JDBC2Pervasive query

    I am using Dell Boomi software to retrieve data from our customers Sage Pervasive DB. In order to do that, Boomi needs class name and connection url. It uses java and jdbc to connect to db. Class name is: com.pervasive.jdbc.v2.Driver. URL is in…
  • Is it possible to connect to the Pervasive Database from a Linux machine?

    Making queries from excel / crystal reports is easy on a windows computer using the ODBC connections, but is this something that has been done from Linux computers on the network? For instance, if we have an application running on a random computer controlling…