• Sage 300 - Sales and Invoice Source tables

    Hi Team I have extracted the data from Sage 300 source system using the below source tables. OEORDD -> SalesOrderDetails OEORDH -> SalesOrders ARIBD -> InvoiceDetails ARIBH -> Invoices But we have the data until 2016 and the data in these tables…
  • Cannot verify user information

    When I am verifying the database and log in as admin the error appears. I checked the ODBC setup which is correctly done but still the issue persist.
  • Crystal reports 202 for Sage - ODBC driver only shows master DB

    I created a new System DSN even assigned my Sage DB as the default DB, i can successfully test the connection and all is good with the ODBC driver. Done this a million times before. However, when I create a new crystal report and choose the system DSN…
  • Sage 300 PU6: "Error: Failed to create Vault settings"

    Hello, I'm having issues configuring my database connection from PU1 to PU6. I followed other guides and answers from this community, and I still get this error. Any help would be appreciated. Thanks, Ethan
  • Sage 300 ERP 2023 can't connect to vault and store database

    I have my system working fine using Sage 300 ERP, I upgraded to PU5 and now it is asking me for vault and store databases. I followed the procedure in https://www.greytrix.com/blogs/sageaccpacerp/2023/06/06/configuring-store-and-vault-database-in-sage…
  • 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

    FormerMember
    FormerMember
    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?
  • 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.

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