Sage 100

Hi there! I hope you're all doing well. I'm attempting to modify the SQL query of an ODBC Import Job, but it crashes when I press the Test button. I'd like to know if there's a resource where I can find the exact syntax of SQL required for VI Jobs…

How can we check/fix the bad data causing "invalid segment number"? We need the SQL Export data for our daily reporting. ==>SQL EXPRESS select qry (linked to cloud-hosted SAGE100c 2022v3 Standard) has been working up until error today (12/6/2023) SELECT…

I have a customer who would like to connect a third party timekeeping program to Sage 100 (v 2021.2 Advanced). With the PII Encryption in place on the employee/payroll data, is that still possible or are there extra steps required to make that happen…

I seem to recall a Sage KB that indicated there were only 3 Join Types supported by Sage (MAS, back in the day). Inner Join, Left Outer and something else. I don't recall hearing about the "Enforced" setting. I ask because we have a client who are very…

In prior versions the Microsoft OLE DB Provider for ODBC was available in SQL to setup the Linked Server. In SQL 2019 I dont see it nor can I find a download to add it. Am I missing something? The Sage 100 2020 32 and 64bit ODBC connectors are both…

Has anyone used Sage Alerts & Workflow v10 w/Sage 100 providex yet? When I try to add a calculated column, the top where it says calculations to perform is blank and I can't choose a calculation. If try to do it manually whatever calculation I receive…

We're using the SODAMAS90 4.0 ODBC driver from sage. Our excel is part of office 365, so it is the latest version. We were able at one point in time (a few weeks ago) to run queries in excel via Data > Get Data > From Other Sources > From Microsoft Query…

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

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 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…

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

We recently started using the DSD SQL Mirror to speed up reporting and are very pleased so for with the results but I have run into a problem. I am attempting to move the slower reports in SAGE custom report menus over to the mirror and when I attempt…

I need to create a custom report that includes the IM_ItemCost table. The first thing I need to confirm is that my results when querying the raw data of IM_ItemCost matches the standard inventory valuation report in Sage. I'm totaling the ExtendedCost…

Hi... I have an existing cash receipt remittance that is in Excel. This remittance gets imported into Sage Cash Receipts. We are finding that some of the invoices are being updated to incorrect customers from the spreadsheet. What would work best if…

i am trying to query a mas table from sql server. several other mas tables return data successfully, but attempts to read from the IM_ItemTransactionHistory table return this error: OLE DB provider "MSDASQL" for linked server "MAS_LINKED_44" returned…

we are on mas100-2016 advanced, sp2, in excel the odbc tables show up. I have tried all types of odbc connections in visual studio 2013 and there is nothing listed under the tables so there is no way to write queries and such, can someone please explain…

We have just completed our upgrade to Sage 100 Advanced from Sage 100 standard (2015). I have updated my ODBC connection string in Access to point to the new directory, however I am getting the following error when trying to login to run the pass through…

What table? Ideally looking for date and time a user logged into a Module. Thanks for any help you can offer!

I'm getting the "unable to obtain list of tables from the data source" after logging into the SOTAMAS90 ODBC, when trying to do a step-by-step Mail Merge in Word. This process worked when we were using the 2014 version, but after the 2015 upgrade, it…

Which data files contain Inventory Code and my custom Inventory Category Codes? I need to use them for a sales report by on of the categories using Excel's Data Query.

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…

I'm writing reports using one of the Category fields for sorting/selecting, and it's VERY sluggish. I'd like to add a key to the Item file. Can this be done by a non-developer? Or anyone?

Is it possible with 2014 and 64 bit ODBC to connect to Sage 100 tables for Excel Power Pivot? Everything I try I get tables not accessible. I know this has been an issue on older releases but I was hoping with new releases it would work. If it is…