• 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…
  • Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
  • OECOINI comments

    Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
  • Printing error

    Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error.... Automation error The object involved has disconnected from its client. This only seems to happen for specific user. When logged…
  • Report window exits on clicking Print button

    When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • Is Sage 300 2016 compatible with Windows 2003 32bit OS at the workstation level?

    I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…
  • Failed to retrieve data from database Database vendor code 208

    Hi I installed Accpac 500ERP 5.5a on my PC and the following error shows when i using it. (This is the first time I use Accpac so i have no idea about this error. And my PC environment is Windows7 64bit) Error:Crystal Report Viewer "Failed to retrieve…