Sage 300

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…

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

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…

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…

Need ODBC consultant to establish / maintain connections to Sage database.

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

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…

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…

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…

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

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…

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…

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?

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…

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…

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

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...

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,

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

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…

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

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…

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…

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.

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…