• 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
  • Sage 300 2022 (PU1) Workstation clients - Random Database connection errors and terrible performance

    We have Sage 2022.1 on our server which is performing perfectly (on the server or through RDP with our VPN firewall). We've installed the Sage Workstation (WSSETUP), ran the Database Setup which created the ODBC and the test connection is fine. Hours…
  • 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…
  • Sage 2022 Update 3 and Sage 2023 require a Server Certificate in place for SQL

    Hi, Does anyone have more specifics in this topic regarding Sage 2022.3 installation and/or setting up? What do we need to do? Buy and install certificate? Just setting ODBC differently? Thank you very much
  • 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…
  • Any information on Sage SQL Server Certificate

    According to the Sage KB116170 information "In a new implementation like 2023 or in an upgrade where a new DSN using the ODBC Driver 18 for SQL Server to connect, your will require a Server Certificate in place for SQL to connect to the SQL database properly…
  • Invoices partially paid

    Hi, We are in need of an alert on AR cash receipts where customers short pay. We were considering using AROBL and AROBP for this. Are these the best tables for this purpose? Thanks.
  • AR (or OE) table with unpaid invoices

    I am trying to locate a table from which I could find invoices for all customers that are unpaid.
  • List of invoice credits

    Hello, We need to pull a list of invoice credits for our auditors. We need the customer key, document number, date and amount. Which tables do we need to use to extract this information? Ty.
  • Can anyone recommend an ODBC consultant?

    Need ODBC consultant to establish / maintain connections to Sage database.
  • SQL TIMESTAMP from AUDTDATE and AUDTTIME

    I have a requirement to create a SQL view with a timestamp field for synching purposes. Converting the AUDTDATE to a date is old hat - creating a combined field was not intuitive (for me). After pecking at it for a few days, I have an approach that works…
  • Check number field

    Hello, We are creating a report of paid AP invoices with the APTCP table. This table does not contain the check number used for the payment. Where can we find that information? Ty.
  • Items cost

    Hi, Is there a table that contains the latest (current) cost by item/location? We are looking into ICIVAL but it contains all transactions that have been processed for each item. Ty.
  • 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.
  • Database Error (Operation = GET-LE, Error = 0) [Microsoft][SQL Server Native Client 11.0] Communication link Failure ....

    The error above appeared on one workstation only at a client when posting a Purchase Order. This workstation was fine for several months after the upgrade They were recently upgraded to Sage 300 v2021 PU2. They are also integrated with CRM 2021 if that…
  • 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…
  • 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…
  • 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][DBMSLPCN]SSL Security error

    I Have already tried : https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=83373&sliceId=1&isLoadPublishedVer=&docType=kc&docTypeID=DT_Article&stateId=2105&cmd=displayKC&dialogID=77215&ViewedDocsListHelper=com.kanisa.apps…
  • Cleaning up old I/C optional fields

    We have a couple of optional fields set up in I/C on about 50K items that have not been used in years. Can't delete then because "they are in use" I want to clean this up and then set up one new valid optional field. Are there any ramifications…
  • 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…
  • How can I use 3rd ODBC in Connector?

    Customer need to connect external database by Sage Intelligence. But ODBC is 3rd ODBC Driver. How can I add this ODBC connection to connector?