Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
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…
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
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…
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…
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 …
I'm looking for existing script I can use to simplify our need to run a custom report during our quoting process for every order. Can anyone help me create a script that will calculate the entire Gross Profit/Margin for the whole Sales Order and display…
I'm trying to update a user defined field in the Sales Order Header table using a script from Sales Order Invoice entry from the Table - PreWrite event. The script saves the USERCODE from the session object into a UDF in the Invoice and then tries writing…
I'm trying to create a custom dialog button in custom office on the SO Entry Detail screen to show some UDFs. The button would need launch a screen that allows me to put some UDFs that are linked to the line. If I create a custom dialog button in that…
I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script.
Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines…