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 writing out a program and I keep getting this error on my sql statement
Error: Expected lexical element not found: <identifier> (State:37000, Native Code: 3F7)
Here below is my sql statement. I am nesting a select statement.
SELECT ItemCode…
I have inherited a project that requires some querying to a SAGE 100 database. I would like to do this from a PHP script. I have read a number of questions/articles about connecting to SAGE 100 ODBC via PHP and it seems straightforward. However, this…
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…
Questions: 1. How to check status completion of VI Job? (see picture 1) 1. What Sage MAS 100 table and field should we use to determine VI Job status using ODBC? 2. Is there other way to run VI Job without using PVXWIN32.EXE?
The problem description…
Questions: 1. Is there any option (bypass) for access to Job Cost tables via ODBC driver? 2. Is there any option (bypass) to decrypt employee encrypted data from external app? 3. Which of tools are recommended for reading data from Sage Mas 100 in replace…
Have a client whose ODBC is suddenly not working. You can create a company-specific connection and it works fine, but if you try to use SOTAMAS90 or create a new one with no company stored, it will not prompt for the company (grayed out, can't drop down…
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…
We have a client that is having a very strange issue with ODBC drivers when we try to setup a linked server in SQL. No matter what we try we get an error that seems to suggest that the login is failing but ONLY when we try to access it from SQL. Using…
I am attempting to run the following query in an ODBC to Sage. I am getting the following error:
Unexpected Inner token: INNER
Here is the query:
SELECT AR_InvoiceHistoryHeader.InvoiceNo, AR_InvoiceHistoryHeader.InvoiceDate, AR_InvoiceHistoryHeader…
SSRS MS SQL ODBC connection to SFAServ I am looking for instructions on how to query data from MS SQL Studio and SSRS. If needed, how to I install requried ODBC drivers and where do I acquire them? We own the Sage Fixed Assets - Reporting Product, does…
MAS 90 version = 4.30.0.23 ProvideX driver version = 4.21.1000 I am attempting to query MAS 90 data using the ProvideX ODCB driver. My queries are running, but no data is returned.
1) MAS 90 has been set up with a role that gives me read access to all…
We use SSIS to grab all the information from MAS for use in reporting. We use the ODBC driver to do this.
This works with no issues the majority of the time. Occasionally, but still often enough, there will be an issue with the extraction, causing…
We have installed 64 bit ODBC driver and the Sage 100 Standard ERP 2014 workstation software on our new Windows server 2012 Datacenter server with SQL 2014 Standard. The system's ODBC connections have been configured and can access the table count and…
I'm looking to pull the current balance of the GL for each account, basically exactly what is in the History Tab of account inquiry. Whats the best way to accomplish this? I've looked around the GL tables for any sort of summary. Will I have to sum the…
Mas200 4.4 (yes, we are updating now) client running on Win7 64 machine. When I run a VI import job on my machine I have no problems. When I try to run the same job on the problem machine the job fails with the message above. Same Windows logon (domain…