• 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…
  • Sales Order To PO Address and lines button script

    Hello everyone, I'm stuck on a problem. I wrote a script to run from a button on the address tab of Purchase Order Entry. I made a field to collect a Sales Order number that the user types in the clicks the button to generate the ship to address from…
  • Create Item on SO from Button Script

    Experts, I have a button script that generates an item code. The generated item code does not yet exist in CI_Item. The desired behavior is that I can populate the new ItemCode on a new line in SO Entry and from there default Sage logic takes over …
  • OLE Error 424 - for some users only

    Running Sage 100 Advanced 2018: I have created a UDT to hold key information needed for our accounts by zip code, and a Button Script to look up the data by zip code, populate certain fields, then show a message to the user. I can run the script just…
  • Open Item Customer Sales History By Period UI from Button Script - pass Customer

    Experts, I am using the button script below to open Customer History by Period from a Sales Order line (Sage has this button in Item Maintenance on the History tab). It works. It opens properly for the item. But there is a secondary selection criterion…
  • Multiple References in Button Script to the same Business Object

    I have a script in Sales Order Entry triggered from a new 'Accept' button that searches for other open orders for the same customer with at least one line item that is not out-of-stock (new UDF I have three references to "SO_SalesOrder_bus" I use oBusObj…
  • Trouble Writing to A UDF on SO Lines from a Button Script

    This script runs from a button on Sales Order DMAIN. The purpose is to update UDF values in SO Detail based on changes made in CI Item. I have tested the script with message boxes (not shown here) to verify that expected keys, line and Item Master values…
  • How to Reference Inherited Objects/Properties in Panel Script

    I'm trying to add an MS Script button to the SO Invoice Data Entry panel. In the script I need to access the LOCAL cCurrentPaymentTypeMethod$ property inherited from Class SO_CommonEntry_UI. Can this be done and, if so, how would it be coded?
  • 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…
  • 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…
  • Button script to modify UDF on SO Order Header Totals tab

    Hi all I have a button script on SO Order entry form. UDFs are on Totals tab. UDF_QTY and UDF_AMT. When a button is pressed, the script gathers quantities and amounts from detail lines where unit price meets certain criteria, The totals gathered should…