• 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 pervasive…

  • 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…

  • 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…

  • 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…

  • 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 $   221.00 MED02 $   96.00
                   
    1…
  • 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…

  • 35 tables are not loading to timberline database

    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…

  • 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 format…

  • 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…

  • Is there a way a field with the pre-tax billed amount in AR or JC that can be used in an inquiry?

    We are building an ODBC inquiry that shows the profits for each job. Is there a field that shows the pre-tax billed amount? We found a field that has the total billed amount including taxes.

  • Sage 300 CRE Report Menu path edit

    id there a way to edit the path for all reports on the Application reports menus to a new sever and folder.  I want to cleanup all none Sage reports and move to a custom folder.  I want to clean up the report paths in each report menu. 

  • Sage 300 CRE 15.1.36 SQL TOP not working

    Hi,
    I'm connecting to Sage via an ODBC driver. I have everything working except the use of 'TOP'; 
    I get the following error
    SQL error: [Simba][SimbaEngine ODBC Driver]SELECT TOP 1<< ??? >> * FROM <Table>, SQL state 37000 in SQLPrepare…

  • Remove data via ODBC from Log Viewer

    We are looking for a way to automate archiving our clients Log Viewer files. The issue we are having has to do with getting access to delete data from the QLM master log file from an ODBC connection. Reading the data has not given us any issues, but when…

  • How to set up a new ODBC connection for a crystal report accessing "Timberline data source" as a data source.

    I'm trying to edit a crystal report that references "Timberline Data Source" (TDS). By edit, I mean add fields from tables that are not part of the original report. I cannot seem to access any tables other than those that are part of the original, out…