Sage 100

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

I am using the code below to get the specific sales order invoice data in my application. I need to get the selected "Lot number" for the line item in this order. (attached image). How should I get the lot value in the code from this sales order invoice…

Hello i wanna to connect mas90 using odbc i know mas90 odbc is only read information, but i need also write some values in some tables for example on Purchase Orders when we received a pdf invoice read information from there and put on file detail of…

I'm attempting to pull data from Sage across the ProvideX ODBC connection via external application (Python, C#, etc). After I establish a connection using the existing Data Source, every subsequent attempt to read any table returns the following error…

How do you pass an SSRS report parameter to Sage? It seems you can pass an explicit value in the sql where clause but cannot pass it from a parameter. The only place to further narrow the data is to add it as a filter to the report. Is there a more…

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…

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…

Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…

I'm trying to do a compare of Sage 100 TIME (hours past midnight - fractional) column in a SQL WHERE statement. I was able to get the DATE field to work with {d '2021-09-16'} but there doesn't seem to be a [t '17.500000'} like scalar function for TIME…

Within the ProvideX environment Sage 100 references their objects by an ID value starting at 100001 for SY_Session . When scripting is used, does 100 create an OLE reference (iDispatch pointer) to the object and pass that to WScript Host ? If so what…

The ScriptBasic distribution comes with a web server version of the language. It runs as a Windows process and is multi-threaded. The best part is you can run your BOI external scripts on the web server with no modification to your BOI specific code.…

I am developing a Windows Forms application which is required to connect to Sage 100 and get order information. I am using ASP.NET and SQL Server 2008. Is there a way to connect to the sage 100 database? myprepaidcenter login

Hi, I've been wondering if there's a way to get the latest revision number from A Bill of Materials. I've tried to get the value by uising oProduction.nGetValue("Revision$", strRevisionNo) but im still getting the "000" revision number. Thanks…

We are using a 32-bit System DSN with SOTAMAS90 to connect our Knowledge Sync Tool (Sage Alerts & Workflow) with Sage 100 Advanced (Providex). It works great 29 days out of 30. On the first day of the month all users are locked out so month-end process…

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?

Hello, A client of mine owns SAGE 100 i7 and I wonder whether it's possible or not to access his data from outside (from a webserver hosted in Azure) like the bank transactions... Any idea? Thanks in advance for any help. Best regards…

I have mas90 V.4 but i got this error exception EOlesyserror in modulo luncher32.exe at 0007368d Error accessing the Ole Regitser thanks i hope can help me.

Sage 100 2014 I have a BOI app that manages items across several MAS companies. What I need to know: How to ask MAS, whether using ODBC or BOI, if a specific part has any open or historical transactions which would prevent the item from being deleted…

hello i am trying to override tax of a sales order ,, i have used the following code ************************************************************************************************************************* Public Function sales_details() dim xx…

Hello, I am new to sage100 BOI and i am trying to understand the workflow of BOI, i am able to read data of a customer from sage but when i am trying to change a value i am getting error's This is a sample code that i tried: '****************…

We have installed SAGE 100 Advanced 2015 as a service. At the same time we installed CSODBC driver and set it up as service. Occasionally, ODBC service stops. We have no clue why it happens. When the service is started, the standard reports start printing…