x Want to participate? Join the group to interact

  • Database Schema for Sage 300 CRE?

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

  • Connecting Crystal Reports 2016 to Sage 100 Contractor v20.5

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

  • ODBC Error when attempting DELETE query

    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…

*Community Hub is the new name for Sage City