Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am encountering an intermittent "[ProvideX][ODBC Driver]Internal error" within an Excel workbook containing several worksheets, each of which contains a Microsoft Query (MSQuery) to various Sage 100 Advanced v. 2019 PU 2 files/tables. The query results…
Across our network users have previously been able to run the data query as explained in the Sage article
https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…
I am trying to use subqueries and joins in my PHP script that is pulling data from SAGE, but I keep getting this error: Warning : odbc_exec(): SQL error: [ProvideX][ODBC Driver]Expected lexical element not found: <identifier>
Here is my query:
SELECT…
We have a customer that uses view tables created to optimize queries run in MS Query. These queries run in 32-bit ODBC and 32-bit Excel, but do not run with the 64-bit versions of the same. All other tables aside from view tables are able to be accessed…
Update to this, might be helpful to others. Uninstalling Microsoft Office Update KB3115501 solves the issue (at least for Office 2016). This update, according to MS website, is supposed to allow import and export date to dBase. Hoping MS resolves the…
Hi all; I've been having some serious difficulty finding an answer to this issue, which has led me to create my first post here.
I have an access database that pulls tables from all companies by use of pass through queries. Connection strings are handled…
Hi There -
I don't know if this group is still active, I'm having trouble trying to query resources by date. For instance, using this query to get sales orders:
mydomain.com/.../*** /SO_SalesOrderHeader
The query parameters I've tried:
…
Does anyone have the syntax on how to perform a time difference in a Sage Query?
Here is an example query:
SELECT "SO_SalesOrderHistoryHeader"."SalesOrderNo", "SO_SalesOrderHistoryHeader"."CustomerNo", "SO_SalesOrderHistoryDetail"."ItemCode", "SO_SalesOrderHistoryDetail…
I am attempting to build a report for SSRS using Visual Studio.
I have a query that is returning results, and the report is functioning perfectly. However, the end user decided they wanted a date range selector on this report. I have done this hundreds…
Hello,
After I run a job it shows that all the inserts and updates were failed. Almost all the error message (which I could see in 'Transaction Errors') say that 'Input string was not in a correct format'.
I want to know how can I get to know…
Hello,
I am working on some query and part of the query needs me to select all the records from AR_CustomerSalesHistory table with FiscalYear equivalent to current year. I have tried these and some other combinations:
SELECT * FROM AR_CustomerSalesHistory…
Hello,
I am new to the world of Sage ERP.
I have designed this query and it works fine in SQL:
SELECT o1.*, ( Select isnull(SUM(D002_DollarsRented)+SUM(DollarsSold),0) FROM openquery(TESTSWRMAS, 'select * from AR_CustomerSalesHistory') o2 WHERE…
I am trying to create a Crystal Report that unites the data from SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail. I believe the best way is to use a Union Query in Access and so I have created 1 Query for each…
I built an application that pulls data from BusinessWorks, which now needs to be converted to Sage 100 4.5. With BusinessWorks, I ran simple queries like the following against the ODBC connection with no issues. With Sage 100, I'm receiving an error:…
