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.
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…
I'm doing a Pass Through Query using Microsoft Access, the SQL statement below works fast and fine.
Is there a way to request the date parameters from the user in the WHERE statement each time the query is run instead of the parameters being hard coded…
We have Sage 100 Advanced (MAS200).
Sage 100 Premium has a sql database. My very general question is "why would someone choose Premium over Advanced?
What advantages does have Sql provide over not having sql. Aside from reporting speed, does it offer…
We have Sage 100 (MAS200) with providex database. We are thinking of getting a sql based version of Sage whether than be 100 or 500.
My question is very general. It is generally accepted that having an "open database" is superior to a Proprietary. Am…
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…