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 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…
We are looking at a Third-Party software called Master Control for our QA/QC documentation processing. With that, we want to be able to extract data out of Sage 100c Advanced v2019.2 (upgrading to v2021 shortly) from Scanco's Manufacturing module, as…
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…
When we hire new employees where I work, we have to create accounts in all kinds of different programs. Plus create windows accounts and email accounts. I wrote a Information Management Program that I have connectors to all our programs (all Microsoft…
The company account is accessible through the desktop Sage 50 US Edition just fine. When we try to access through our app that uses Sage API to access it gives the following message. ANyone knows what the issue is?
WIndows 2012 Server R2
Sage 50…
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…
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,
A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having.
We are trying to create POs, Time records, and add Cost Codes to the DB.
Reading…
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…
How can the Sage 100 Contractor 2016 (version 20.4.51.0 or greater) databases be accessed using Microsoft Access 2010?
I would like to link to the data source by creating a linked table. To do this I have created a Machine Data Source using ODBC in…
Hi,
I'm trying to work through the C# sample project in the Sage 50 Accounting SDK (Simply) but for some reason I can't get the opendatabase connection to let me access the database. I have set up my user in the Sage app and I know my username and password…
I am trying to go through some of the code examples in the SDK, obviously one of the first functions that runs is the database connection function. I have tried sysadmin with various passwords but I can never successfully connect to the database to try…
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…
I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table).
Here is the information that…
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…