I have been attempting to simply change the data type of a column for a query I am running through the ProvideX ODBC but I keep getting errors, and I am wondering if this scalar function is not available here. Simply, I am trying to query the IM_PeriodPostingHistory…
I just upgraded from Sage 2020 to Sage 2023 and can't get any of my existing (or new) VI Import Jobs to work. When I try to actually run the job and test them, I get the message:
"VI JOB_NAME Unable to open [wdx][odb]<dsn_name>"
I don't get this message…
Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
Hi All,
Need object reference & table name for Item Maintenance --> More --> Item Pricing Maintenance --> Customer Price Schedule --> Pricing Method --> Price Discount Amount to pull the discounted price by running the script.
I right clicked on the…
Hi,
I am new to Sage100 and customer is using Sage100 advanced which comes with ProvideX ODBC driver which only allows to read data from Sage100.
I did some research on the functionality to write back the data in Sage100 but was not able to find any…
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…
We are querying invoice data to read from MAS using the ProvideX ODBC driver from within a custom application. Within the custom application, we have tried specifying credentials explicitly within the connection string used to open the ODBC connection…
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…
Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
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…
Since we installed the latest upgrade for Sage 50 to Version 2018.0, we are unable to connect to the simply database with our third party software using a ODBC Connection.
Over the past 10 years I have always managed to make the appropriate adjustments…
Hi, I am trying to determine why my GL and AP control accounts dont balance.
Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.
To this end, I would like to build a query in sql…
Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…
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…
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…