Sage 100

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…

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…

Hello! I am building a php eCommerce system for a client, and they would like to have inventory and product data synced from Sage 100 ERP 2016 to the eCommerce store. They were previously using MAS90 when we had first looked into it, but between that…

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…

Once every 1-2 weeks or so I have to get in after hours to rebuild sort files, in our old business system a similar process was scheduled to run each night. Does anyone out there have a script or other method that would allow for scheduling a rebuild…

I have a UDF in AP Open Invoice and AP Open Invoice History. I have it flow through check printing to check printing history. What I cannot get to work is if I do a Manual check and select an invoice, the UDF does not populate. I have it in the AP…