• Exit Table Updates Properly?

    I have encountered a strange issue with a button script that enters data into a UDT. I have been using this script in testing for about a month now and it hasn't had any issues until yesterday - even after a server restart. The first time clicking this…
  • Copy UDF Values from AR_CUSTOMER.M4T to Equivalent UDFs on new Sales Orders

    New to this forum, and new to using the Business Object Interface. Scenerio: I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow. One of the tasks I will be creating will periodically look at all open Sales Orders and automatically…
  • C# Create Sales Invoice From Sales Order; nSetKey() fails, sLastErrorMsg = "The [InvoiceNo] is invalid"

    I am on Sage 100c Standard 2016 (Version 5.30.5.0) (yes, I know it is very old, and have plans to upgrade to a supported version). I am attempting to create a program in C# that creates a sales invoice from a sales order. When my program executes the…
  • Trying to set pricing, "The Price Code Record is Required" (even though it's set)

    {solved} The error was in my KeySet() line. Instead of: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey", ""), pcObject).ReturnCode; It should have been: var retval = Core.SageObject.Process(pcObject.InvokeMethod("nSetKey"…
  • Create Purchase Order Invoice via BOI

    Experts, I am able to create Sales Order, Sales Order Invoices, and AP Invoices via BOI without any issues. I am missing something about the order of things for PO Receipt of Invoice. Here is an excerpt of my code (it's in Powershell, but the methods…
  • oScript.Execute

    Hello I am trying to find any doc on "oScript.Execute", i am facing an issue i want to call a 3rd party app and want the script to wait till the exe completes its execution. Thanks
  • Unable to Initialize oBusObj ( OLE error 424)

    Hello Every one I am running a script to get line level values in sales order, I am getting a "OLE error 424" error, can any one please help Code: ****************************************************************** Dim taxReqXML Dim intx dim…
  • Error when running WScript.Shell object (OLE ERROR -2147024894)

    Hello Everyone, I am trying to run a 3rd party exe on a button click using VB Script , The code is trowing (OLE ERROR -2147024894) i have added the code and also the error message i got ********************************************************…
  • UDF using script

    Hello Everyone I am trying to update UDF in sales order line using script, i am not getting any error but it's not working i am adding the the code that i am using any kind of help will be really great Thanks ____________________________________________________________________________________________________________…
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Error 26 : variable type invalid

    Hello i am trying to read data for each line in sales order and i am getting a error , i am not sure why i am getting this error cause the same code is working for few lines but not for few this is my code ##################################################################################################…
  • Unable to edit order line and tax amount

    Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…
  • Editing Tax Amount using BOI

    hello i am trying to override tax of a sales order ,, i have used the following code ************************************************************************************************************************* Public Function sales_details() dim xx…
  • How to write Data back to sage100 / mas90 using BOI?

    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: '****************…
  • 3rd party integration with sage 100

    Hello Everyone, I am trying to build a 3rd party C# application for my client on sage 100, i read several things but was not able to achieve this, i have been trying few sample codes to connect with sage using BOI but i am not able to read data from…
  • UDS to open Contact Code List

    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…
  • "The Module Code is Required" IM_PhysicalCountWrkst_rpt nSetKey()

    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…
  • BOI for Volume Pricing Check

    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…