x Want to participate? Join the group to interact

  • Sage 300 2022 - What ODBC we need or must use to setup companies/system ODBC?

    Hi everyone, I have some customers with Sage 300 2022 and they have and use to setup ODBs for companies/sytem SQL Server Native Client 11.0. But with a customer we are upgrading to that same Sage 300 2022 version, and we dont found it. We download…

  • Any issue with other app databases in same instance as Sage?

    A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…

  • Query for Logged In Users?

    One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing…

  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

  • Why isn't TRIM() working?

  • Connection errors multiple times a day

    Hello, I have a client who keeps getting connection errors multiple times a day on multiple workstations. They only get these on workstations (not on the terminal server). The terminal server, app server and SQL server are all VMs on a host. They…

  • Is Sage 300 ERP 21014 compatible with SQL Server 2016?

    An existing client Is running Sage 300 ERP 21014 and would like to migrate their SQL from 2008R2 to 2016. Is Sage 300 ERP 2014 compatible with SQL Server 2016? Thanks,

  • Current fiscal period for a company in database?

    Can someone please tell me what table/column will give me the current fiscal period for a company?

  • ODBC connection failed...

    Hello All, Hope you can help with my odd ODBC connection, I have 40 companies that I pull data using pass-thru queries. ODBC connection string is set up for each of the companies. The retrieval process is stacked inside an Access Button object, when…

  • Unable to Connect to Database error 98

    Have been using Sage ERP Accpac 200 v 6.0 with Pervasive workgroup v10.30.017 successfully for several months. Today, there was an automatic update and reboot on the "server" while the other workstation was creating bank entries during a bank reconciliation…

*Community Hub is the new name for Sage City