Sage 100

I'm trying to set my scripts to be able to search the tracking number when they click the hyperlink, but for some reason I don't get the value I get the name of the UDF, but not what I put in there. Anyone has idea how to do it? please help ' Create…

I have reports that when I go into designer I see the ODBC connection and it not using the SOTAMAS90 ODBC connector, it has some other type of connection. I do not think it is correct and if someone can explain the connector and how to fix it I would…

We have a Sage 100 ERP 2014 on Terminal Server with 64-Bit Excel. Everything seems to work EXCEPT the Business Insights Explorer. Is BIE really incompatible with v2014, or am I missing something?

All, We are testing an install of Sage 100 ERP 2014. I run 64 bit Microsoft Office in Windows 8.1. The SOTAMAS90 ODBC was set up as 64 bit. The test connection works in ODBC manager. When I go into an Access database to link to the tables, I can add…

I have an ASP.NET 4.0 site running on IIS 8. The application pool is set to enable 32bit applications. I have created a 32bit DSN that accesses Sage 100 ERP 2014 data. It successfully returns tables when I test it. When I try to read any data from Sage…

Howdy, I am trying to create a linked server on a SQL 2008 64-bit server. Using the SAGE ERP 100 64-bit ODBC. I want to link some of my MAS tables with SAGE CRM. The Linked server is setup to not use a security context. The query reads like…