• Sage Database Structure

    Our Sage local DB environment was setup in 2017 hosted on a Windows Server 2016. I am attempting to gain access to the data. Currently an active SQL Instance is named SAGESQLGATEWAY and when connected to it, only lists SqlGatewayConfiguration database…
  • 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
  • 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…
  • Can anyone recommend an ODBC consultant?

    Need ODBC consultant to establish / maintain connections to Sage database.
  • I/C price list items

    Hi, We need to do a mass change in item descriptions. What is the table that contains the items in price lists? Ty.
  • Schema Help

    Greetings from Vancouver Island. We have SAGE 300 running. I have successfully connected to the underlying MS-SQL DB via Excel (ODBC), Azure Data Studio, and Microsoft Power BI. So, access is not a problem. I've received a zip file from my support company…
  • invalid database specification firewall issue

    I have a simple 2 workstation setup. Both workstations are windows 10 Pro. W-1 has SQL server on it and is on the "PNET" workgroup. W-2 just has the client also on the PNET workgroup. Network set to private. When I turn the firewall off for private…
  • 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…
  • Joining APOBL/APIBH to something that shows me the Invoice OEINVH, Order OEORDH or even the customer details

    Hi I've got a simple SQL query the shows details of invoice payments from APOBL but I'm struggling to join details of the customer or the actual order/invoice they have paid up. Is anyone able to help me please? Cheers Andy
  • Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt

    I am receiving fallowing error in all modules after test conversion to 2019. Running Windows Server 2019 and SQL Server 2017. I setup 32bit ODBC connection as suggested in upgrade guide. Data conversion completed without any errors but I am not able to…
  • Data dictionary / Querying Sage 300 with PHP

    Hi, all. I'm trying to create a couple of simple PHP pages to display some info from CRE 300, using the 32-bit Timberline ODBC driver (not MS SQL). The ODBC connection works for MS Access and Excel, and I can establish a connection using PHP, but I…
  • Sage 2019 upgrade

    Hi, Upgraded a client fro Sage 2017 to Sage 2019. Some machines return the error=40960 while others work fine. recreated the DNS on error machines but the issue continues. What could be the issue?
  • Is there a way to use ODBC to select invoices to pay? is it a writeable?

    I would like to use a spreadsheet to select the invoices in which I am paying. At this time we use Event one writeable and it would be more convienient to go in and change or click those invoices in which I am paying, then send to Sage to set up for…
  • Where in the AOM can I find flag for "fiscal period" locked or unlocked?

    I have a challenge...can someone familiar with the Sage 300 database tables give me some advice? I would like to query the database to find out if a certain document date correponds with a fiscal period that is currently locked for Accounts Payable…
  • Get user using windows authentication and domain

    i want login using macro. but using windows authentication and specific domain can anyone can help me?
  • Database connection error.

    Hello, my Sage ERP 500 was on an XX Domain. I changed the Domain name to YY Domain. So, it now happens that when I try to login to Sage, I get a database connection error. What to do because I am new to Sage Accpac. Anyone to help, plz...
  • 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,
  • Sage 2012 (v6.2) with SQL Client Native 11?

    Hi, We are installing a Sage client in a new machine as user change its PC but when trying to set up ODBCs we dont found Native 10 that is installed in old machines. Just Native 11. Any problem? Not at all? Thank you
  • Custom SQL in Office Connector

    Hello Everybody, Just wondering if anybody ever used Office Connector SQL Editor. I'm not sure what I'm doing wrong, but every time I try to manually update SQL query, even with simple things like GROUP BY, there is an error message. The message…
  • 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?
  • Sage 300 remote server connection

    Custom designed POS app in MSAccess and VBA that uses ODBC to query/display customer data from SAGE. Need to write changes back thru ACCPAC views. The POS front-ends run as standalone networked PCs. SAGE 300 runs on a VM in the backoffice. Coding is stuck…
  • Use Integrated Security check box

    Recently upgraded from v60 to v62 su3. Have many crystal reports and modified forms. When running modified report or form from Accpac am getting 'use integrated security' check box, uncheck box, click finish and the report/form runs correctly. All standard…
  • Record is too large on OEINVH / order date

    Hello, I am trying to use the order date information in the table OEINVH, but when I try opening the table I get a "record is too large" error message. Any suggestions will be appreciated. Thanks.
  • OEORDD and OECOINO links

    Hello, I am linking these 2 tables based on the ORDUNIQ field in both and the LINENUM in OEORDD and UNIQUIFIER fields. I need to be able to concatenate the information in the DESC field in OEORDD and COIN in OECOINO. I am using an order that has 2 lines…