x Want to participate? Join the group to interact

  • External Script to Loop Through Deposits in Batch

    I am attempting to create an external script that will update all deposits in a Cash Receipts batch in the event something was entered incorrectly during data entry (i.e. BankCodes, DepositDates, etc). It would appear that the script is working fine until…

  • 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…

  • Script to Loop through Invoice History Lines

    Hello, I was hoping to get some advice on scripting the BOI via a Button script that was placed on S/O Invoice Data Entry that would act as a "Quick Tax Credit" button. We use a third party cloud vendor to calculate our taxes but that shouldn't affect…

  • Grabbing the Currently Selected Invoice from Listbox

    In Customer Maintenance's Invoice tab I am wanting to allow accounting to have the ability to edit the Comment field from the AR_OpenInvoice table. Since this isn't the history table, it wouldn't affect the comment line for invoice history reprints, so…

  • Update UDT whenever Sales Orders are printed

    Greetings all, I was wondering if there is a way of updating a UDT whenever a Sales Order is printing via script. I have a customer that would like to keep track of the time between when the SO is printed and when the order is shipped. I figured I…

  • 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…

  • BOI - Bypass Separate Check Popup

    I'm working on a BOI script to create Manual Check entries from a CSV. Everything can import successfully, except when the invoice was set with SeparateCheck = "Y". In regular UI, you get the popup message "The Invoice ____ is flagged for separate…

  • Copy invoice from AR_InvoiceHistory to flat file

    I have most of this script working but am hung up on the part reading from the line detail object. I have created a button on the AR Invoice History Inquiry panel so that the end user can find the invoice they want to copy, press the button, and the flat…

  • The Column is not in the IOList - Error setting UDF on SO_Detail

    I have a UDF on SO_Detail table I'm attempting to populate with a BOI script (written in C#). This field is set to datetime type, the data I'm sending is being parsed from string to datetime format in the script. I'm sending the SalesOrderNo, user credentials…

  • I can't seem to set an event for an item change

    I am trying to get an event trigger when an item quantity changes so I can perform a real time update in a UI. I have tried setting Post Write Events on IM_ItemWarehouse and IM_ItemTransactionHistory, but although I can see the DB Tables changing/updating…

  • Shipping Data Entry via BOI with large number of documents - odd behaviour

    Experts, I created BOI script that pulls picked orders from a SQL server and creates Shipping Data Entries for these orders. The data originates from the Sage Sales Orders and I have all necessary information available. Here is the issue that I am running…

  • Button to run AP Aging from Vendor

    I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

  • Error 538 in Method Movenext

    Hi All, Getting this funky error in method movenext. This script runs through SOs and deletes the ones in a particular range for a particular customer. This is the snippet in question. Any idea what I might have goofed? it seems to work sometimes…

  • Training Material and Certification recommendation for BOI and VB Scripting

    Hi All, I am very new to VB Scripting and BOI in Sage scripting, Is there any training material or certification which is recommended for the newbies, please advise and recommend. Thanks AJ

  • GetResultSets unexpected result sets

    I have 2 sets of GetResultSets that produce different results. Could some please explain to me why these 2 examples of GetResultSet methods return different result sets? I've read some examples, including Advanced GetResultSets() by a Sage developoer…

  • Trying to Schedule VBScript that prints Sales Orders

    We are on Sage 100 Advanced v2017 and I have a VBScript that prints Sales Orders using the SO_SalesOrderPrinting_UI object. Does anyone know if this object requires an active Windows session in order to run? The script runs perfectly when I run it…

  • Reversing electronic payment through BOI C#

    I get an error "Module J/C is not on file" when attempting to reverse an electronic payment. Here is my code using (DispatchObject mCheck = new DispatchObject(pvx.InvokeMethod("NewObject", "AP_ManualCheck_bus", oSS.GetObject()))) { // Perfrom Check…

  • 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 ********************************************************…

  • Reading data from grid using VBScript

    hello, i am trying to read data("SO Line" line level data for a sales order) from the grid to a vbscript but i am only able to access data of selected line ..... can any one help me out in how i can read the data from the gird( read all lines…

  • VBScript not firing from Sales Journal Update

    I have a simple test script that I wrote based on a script that Elliott posted a couple of years ago oTest = 0 Set oTest = oSession.AsObject(oSession.GetObject("CM_UDTMaint_bus", "SY_UDT_SY_TEST")) dateStamp = "" timeStamp = "" userKey = "" retVal …

  • Sage 100 ship weight not carrying over to the totals tab

    Hello: I have an issue where the client needs the ship weight and the freight to carry over to the Totals tab in Sales order data entry. It will not due to the line item setting in sales order options. I believe my options are to write a script to…

  • Unable to invoice order on hold via BOI script

    Hello All, I'm importing invoices using a BOI script. I'm getting errors stating the customer division is required and tax schedule is required when attempting to invoice an order on hold. The ID used has permissions to invoice orders on hold, so…

  • BOI Scripting Information

    Hi All, I was going through some old Sage Summit presentations and thought that these 2 sessions had a lot of great information that is still very useful. Enjoy! UsingBusinessObjectInterface_Begginer.pptx UsingBusinessObjectInterface_Advanced.pptx…

*Community Hub is the new name for Sage City