Sage 100

Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…

Hi, I purchased the above mentioned course on Sage university but I was not able to access the material as the payment was pending. Also, I got a auto mail from sage informing that one of their sales person will contact us for payment part, but I…

Hi, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

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 upgraded our company to a new file server (windows server 2019) and Sage 100 Standard 2020 from server 2012 and Sage 100 2017. The performance of sage 2020 on server 2019 to clients is horrible. Sage hangs constantly and takes forever to process batches…

We are querying invoice data to read from MAS using the ProvideX ODBC driver from within a custom application. Within the custom application, we have tried specifying credentials explicitly within the connection string used to open the ODBC connection…

I am working on a C# .net desktop application that needs to be able to connect to Sage 100 2017 and retrieve available inventory quantities for all products. I've run into a complete brick wall trying to figure out how to do this. I have several questions…

I have built an API that can insert orders into Sage 100. API will not work on when deployed to any IIS the web server, with a NewObject Error: 200 error. This happens when I try to invoke SY_Session I realized that this error occurs even on my local…

Hi All, I will have to use BOI to import customers into Sage 100, Normally the Database and the Workstation are on the same machine, so it will easy to connect ProvideX using BOI and import the records. But the problem is we have the database and…

I am running a set of business object commands to print a report. Sometimes the commands run without any problems and my report gets printed. If I run the report over and over, about 1 out of 5 times I make it through to the step where I call NewObject…

I have recently found how to add a new credit card to Sage100 and the exchange vault without using the exchange vault’s extra UI, screen. I insert new cards into the system behind the scenes using my own custom windows software written in C#. I now need…

I want to write a little C# app where data entry can quickly add credit cards to existing customers. This app would reside on a machine that has the Sage 100 client installed - so I would use the client's MAS90 folder to execute BOI/ProvideX methods…

Sage 100 ERP Version 5.00.8.0 The following code fails at the call to nProcessReport returning 0 and LastErrorMessage is blank. using (DispatchObject pvx = new DispatchObject("ProvideX.Script")) { pvx.InvokeMethod("Init", @"C:\Sage\Sage 100 Advanced…

I am trying to import some data into Sage but after initiating the script object, when i try to newObject 'SY_Session', it fails. On server it works fine but on clients it fails. I checked the security settings, the user has full access to MAS90, and…