Sage 300

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

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 have installed the sage 300 2018 workstation in window 10 64-bit and get the error message said that cannot access the database. And then checking the ODBC 32-bit find that the SQL server has error " SQL server network interfaces: Error Locating Server…

Hi, We are upgrading to Sage 300 2018 and need SQL Server Native Client 11.0 but not sure where I can found. Apparently one comes with SQL Server 2012 but not sure if thats OK no matter we have SQL Server 2016 or 2017? Any idea? Thank you

Error message when running report in Sage Intelligence. This was working last week. Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. Number : -2147217913 Source…

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,

Is there a link on How to use sage intelligence using the connectors ODBC Driver in EXCEL to link the data in excel ? We are trying to get information from Microsoft Excel data to be use in the integration of ODBC Driver SQL Server of Sage Accpac…

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…

Good Morning, I am new to VBA and having an issue with a macro which a form. I have added a range button that will accept Two(2) values entered by a user in a and then access data from the database then add it to a Filter List. Currently working on…

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…

I needed to convert the Sage 300 time field to locale time in a SQL query. I put the following together from a Stack Overflow post. It, however, doesn't take daylight savings into account (and apparently that's not the easiest thing to do). SELECT DATEADD…

A customer runs Sage 300 v 2012 on SQL. Starting this morning, they have been getting the dreaded 49153 error, intermittently. Happens on all workstations (3). But other applications that use SQL (Accellos, for instance) are running with no problem. …

Dears I Installed SQL 2012 64bit SP1 on the default path and I Installed Sage ERP 300 on the C:\ now when I connect the data base created in the Sql with the sage database via Database Setup the Error appear as follow: unable to connect to the…

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…

Hello, I can not locate the following fields in OE. Any assistance will be greatly appreciated. - Terms descriptions (I can get the code from the header table but not the text description) - Order status description - Date invoiced

Hello All, Hope you can help with my odd ODBC connection, I have 40 companies that I pull data using pass-thru queries. ODBC connection string is set up for each of the companies. The retrieval process is stacked inside an Access Button object, when…