Sage 100

How do you get number of seat licenses available using Providex ODBC? Meaning, is there a Table that stores the number of users taking a seat? I know there is the sy_console table, but that just shows who has what window/process open.

We have a client who recently upgraded from Sage 100 2013 to Sage 100 2016 on the same server. When we call a NewObject using software that we had written in VB.NET on the server, we will get an RPC error at random times throughout the day. I've also…

I have been using UDS and BOI for a while and understand how to launch UIs. I'm just having trouble finding how to open the screens for searching. Specifically the Contact Code List that can be opened from Customer Maintenance by clicking on the magnifying…

I just spent a few hours troubleshooting something and figured that someone else might benefit from my experience. We have a receipt of goods integration that runs from AP invoices in our ECM system and creates a receipt of goods entry in Sage 100 ERP…

I am having a permission issue when try and run a VBscript. I get the error message: Failed to initialize the ProvideX library. I can get it to work if I go into the cmd prompt and run from a command line but selecting a folder and double clicking the…

I'm trying to script against IM_PhysicalCountWrkst_rpt but keep getting "The Module Code is Required" when calling nSetKey(). Script sample is below. We are running 5.10.4.0. Anyone have any suggestions on what to try? Const HKEY_CURRENT_USER = &H80000001…

Hello All, I'm using the code below to determine whether volume pricing exists for an item, but I'm getting a retval of 0 when I know there is pricing configured. My code and the record from Data File Display and Maintenance are below. Also, I have…

Is there a command to release a Lock on a Record? Can it be used to kick out a user and give access to your application?

This BOI is driving me nuts. You just cant tell why something is not working. Would someone be willing to post full code examples for Sales Order CRUD Operations? What I need to do is: Create the original Sales Order Update the Sales Order Add…

On my development machine I am getting the error code "NewObject Error: 65" when trying to create a sales order object. Our MAS 200 installation is on an internal server local to our office but not on my machine. I am developing in C# but have created…