• Error 88 (script) related to oHeaderObj.EditState

    Confirmed in v2023 Premium and v2023 Standard (both 32-bit). Have a SO Detail script, pre-write, that checks the status of oHeaderObj.EditState (...only wanting to run the line script for new orders). Click to run an unrelated button script in SO…
  • Setting Break Points for Debugging Scripts

    Can anyone give me a quick explanation of how to use break points in the debugger. I can't seem to find any examples anywhere.
  • BOI Avanced

    I decided to use the ScriptBasic application web server that runs as a Windows service for the workstation UI. The web server supports BOI and other extensions like ODCC and cURL. DCOM became another layer I didn't want to deal with. This also gives…
  • Getting data from an unrelated table

    I am using a User Defined Script with the SO Sales Order Header and linked it to the post validate on the CustomerNo field. I need to lookup data on the AR_CustomerShipToTaxExemptions to search if the customer has a TaxExemptionNo defined. I've searched…
  • Current Business Object

    Is there an easy way to tell what the current business object is? I am writing a number of user defined scripts that have to do with OM and am at a loss for where to hook them to. I've done everything that I can think of with the debug utilities and scoured…
  • 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…
  • SO_Detail UDS Edit for Drop Ships

    I had this script in place to handle any items that were coming from this one Vendor (0001630), the script would check off the DS check box and also mark a UDF_QTY_REC with the ordered qty if that vendorno was selected. We had a process change and now…
  • Library Master > Automatic Update

    Can anyone explain to me how the Automatic Update utility works? I recently made a job in Task Scheduler to run SO Daily Sales Reports/Updates, it works great except we get a Paya communication error every night and have to restart it. So I was looking…
  • Item Alias Update from UDF

    I am trying to update the Alias Item for new items created for a POS system. I need to create an Alias Item for each new item created and the Alias Item needs to be = UDF_UPC, it also needs to be a "General" type with the Alias Item Description ="SKU…
  • BUG?? Set the step description in Work Ticket Entry - The Description is greater than 30 character(s).

    I'm using the line of code below, but I'm getting an error stating: "The Description is greater than 30 character(s)." No doubt this is because the step description is stored in the JT_WorkTicketText table (much like the CI_ExtendedDescription table)…
  • How to Flow a UDF from Sales Order Header to SO History Header Reliably

    With identical UDF names in both tables, the original value set into the SO Header UDF via a ColumnPostValidate script from a standard field works to flow the value to SO History Header, but subsequent successful updates directly to that SO Header UDF…
  • Sage BOI SO_PackageTrackingByItem_bus

    I am attempting to write a Sage BOI VBS program to read and write to the SO Shipping Data Entry Package Tracking By Item object and am receiving the error <NewObject Error: 200>. I am using a Sage user that has full access to Sage and have the company…
  • Sales Order lines Promis date - getting line key is read only message.

    Hi Forum, I've been trying to update Standard Sales Order line promise date from Master Order Lines with no luck. I am getting The Promised date from the last line in the Master Order updated only, all lines on Standard order with same date. Here…
  • DocumentTotal Bug?

    I should start off by saying we are still on v2020 for compatibility reasons. It appears that the `oBusObj.DocumentTotal` property (Sales Order Bus) doesn't calculate on quotes (it's value is 0). Is this intended behavior? The moment I change the order…
  • Can I write a script to show what is the error on the BI button MS Script I created

    Dear all, Is there a way to have a short script alone with the BI script to show error message on why my script doesn't work. In other word, how to trigger error message on a BI script, something related to this code - oBusObj.LastErrorMsg. Correct…
  • Update UDT from CI_Item

    After reading a few post about updating UDT's from scripts I am wondering if my events are wrong or do I need to SetKey before SetValue? In the debug I couldn't get any return values, so I am guessing my events are wrong, I've tried a PRE-WRITE and a…
  • Error 88: Invalid/Unknown property' on reference to a business object from within the same object

    'Error 88: Invalid/Unknown property' on reference to a business object from within the same object I am trying to browse the records in the 'SO_SalesOrderDetail' from within a Column Pre-Validate script on ItemCode in the same table'. This works from…
  • nFind returns 0 for AP Invoice lookup in AP_OpenInvoice

    I hope this is something easy that I'm overlooking. I'm looking up an invoice in the AP_OpenInvoice table that I know exists. I have confirmed that I'm passing the correct vendor division, number, and invoice number. But I'm getting a 0 return value.…
  • get control property list box focus not available

    Hi, The list box control property is not available, why is that?. My line of code: getCtl = oUIObj.GetControlProperty( "MyListBox", "Focus", ctlPropMyListBox ) If ctlPropMyListBox <> 0 Then Call SomeFunction End if Thank you, -SKG
  • Read validation configuration of UDF

    Hi, When creating UDF we can specify that its validated against: - none - range - list - user-defined table Im trying to find a way to get the name of the UDT. In order to get range/list values in c# its enough to do something like that…
  • get control property list box focus

    Hi, No return value for list box focus event property. How is this property trigger, by clicking on the list box control? Any information would be helpful. Regards -SKG
  • 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…
  • Change order of Sales Order Lines

    HI, I have a request from a client to sort the Sales Order Lines detail section by Item Code. I feel like I should be able to do this with a script, but not clear on what Object to reference. Can someone give me a hand, perhaps point me in the right…
  • Sales Order import bypass VB scripts

    Is there a way to determine if a Sales Order is being imported, so I can bypass VB Scripts?
  • PostLoad SetControlProperty

    I have two UDTs that are being used to manage credit releases. One contains the credit release data and the other is just used as a validation table that contains status codes and their descriptions. In SO Order Entry there is a UDF that uses the main…