Sage 100

Currently utilize Alerts & Workflow to notify us when somebodies birthday and/or work anniversary date is forth coming, however with the new constraints on PII within PR 2.x, it has essentially rendered these alerts worthless. Can't really seem to get…

I have a VI job that is using odbc to connect to my database. is it possible to execute this VI job using sData?

I have several tools extracting data from Sage 100 Payroll and am having ZERO success in converting them to the new Business Framework tables. I'm NOT extracting PII. I understand PII fields are not accessible via ODBC but surely the non encrypted fields…

I saw the 5yr old thread , but this issue seems different. New Win10 machine, querying v2019 Standard from 64-bit Excel (v2019). BIE views work inside Sage. Excel queries bring in data just fine (64-bit ODBC driver installed), but when I try to…

Sage 100 2017 In recent months, I created numerous tools in Excel extracting data from Sage. I'm new to Sage & ProvideX but not to using SQL in VBA in Excel to query Db (SQL & Oracle). Additionally, I've always useda connection string with Provider…

I'm trying to create a Visual Integrator job that will import items located in an Azure SQL database. I've created ODBC connections to the database, and can connect to the database from the server with the Sage client installed. However, when I try to…

When I'm running a BOI script does that use one of the user licenses for Sage? Does ODBC use one as well? Also, how do I find out how many users our license has?

Using Sage 100 ERP v2017. I am trying to run a very basic MS Excel query in order to build a database for our new website. Literally, all I am trying to get is the product part number, description and the name of the item image. My query is as follows…

We have a custom program written in Java that is extracting data from Sage 100. Java has removed the ODBC support in the current versions. My programmer asked me to find out if anyone knows of a JDBC driver for Sage 100 (providex). Thank you Beth

Hello, I am new to Sage and the usage of ODBC. I am able to run through the step in Excel (Get Data -> From Other Source -> Microsoft Query -> Pick my database -> I choose "GL_TrialBalanceWrk" -> select all with no filters) everything runs smoothly and…

I am starting with a base report that uses a "work file" database - let's say Packing List. Can I link to another work file database and expect to get any data from the second work file? I'm thinking NO, since work file style databases are only populated…

We are using Sage Premium 100, and have crystal reports for sage installed. We have the SQL version of sage. My user role is an 'admin' in sage. I know how to get to the place to make a new database connection, however, I am lost after that. I would appreciate…

I have a customer that wants to the line comments in Purchase Order. They are thinking of buying GetX by xkzero. Does anyone have an opinions or experience that could give me some information on that idea? Thanks, Sidney Kay Wells

Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…

What Table used by JobOps 4.3 to build Work Ticket Transaction Detail Report?

I have a client asking if there is any Cube functionality in Sage 100. Has anyone done anything with Cubes? Thanks, Suzanne.

I recently found a discrepancy in values between the quantities tab and the cost detail tab within Item inquiry on a few items. After researching in the Knowledge Base, I came across the following steps to clear out the issue: Update all transactions…

Across our network users have previously been able to run the data query as explained in the Sage article https://support.na.sage.com/selfservice/viewdocument.do?noCount=true&externalId=51308&sliceId=1&noCount=true&isLoadPublishedVer=&docType=kc&docTypeID…

I'd like to pull posted AR invoices from each of our 5 companies and update a table daily. Can anyone tell me how to find/distinguish the data for each company? Any recomended procedure to pull this data to the table? Thanks for all responses!

Hello, My company just upgraded from Sage 100 2015, to Sage 100 2018. The installation path is different and we have a plethora of excel reports calling for data connections with the 2015 version. Is there a fast and quick way to manage all these…

Good Morning All, I'm trying to find out related field (ColumnName) in Table based on the SAGE screen. So in "AP Invoice History Inquiry" Screen there are following fields, Date Inv Entered $ amount invoiced Date Paid $ amount Paid …

Is there an ERD or easy way to identify the AR Invoice tables. We are using SQL Server as our database and trying to pull the daily invoices to a table. We currently have about 10 companies setup and need the data from all companies. Thanks

We currently run sage 100 advanced 2016 update 5 on a 2012r2 server and access sage via RDS (separate server). Currently using the Sage 100 ERP Client Server ODBC Driver Service. We notice that when ever we go into the user or role maintenance and make…

Hello. We are attempting to get two years of pay history out of Sage 100 as well as other employee information. I have attempted to use an Excel Query, but I really have no idea what I am doing. Where do I go to find an expert that knows how to retrieve…

I am trying to use subqueries and joins in my PHP script that is pulling data from SAGE, but I keep getting this error: Warning : odbc_exec(): SQL error: [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> Here is my query: SELECT…