• 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…
  • 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…
  • 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)…
  • 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…
  • 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
  • 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…
  • 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…
  • IM_Itemwarehouse Message box

    Trying to figure out how to get a message box to pop up in SO entry when a user enters a line for warehouse '000' for example, however there is 0 available for that item in warehouse '000'. On that same item we have 2 available in warehouse '001', I would…
  • List Box Control.

    Hi. How do I add column headings to a listbox and set the columns so that user can resize. I'm using, ListBoxLoad(listBoxName$, value$, delimiter$) mehtod, no problems loading the data from a UDT My SetControlProperty( lbx, "FMT", "L20 L20 L20"…
  • 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…
  • Screen Manager - Error in definition of screen item: PADDRESS 1315

    One of my users is getting this error message when trying to do SALES ORDER ENTRY. It says the Bill To Zip Code is greater than 10 characters. But it is not. Does anyone know how to fix? Its weird, cause when i log in to the account from my computer…
  • External Script to Create Cash Receipts Batch

    It's me again. Looking into using VBA or potentially a vb.net windows form app to potentially create and update Cash Receipt Batches & Deposits. External scripting documentation seems to be pretty limited and I am not sure where to even start when it…
  • 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…
  • 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…
  • Setting focus to panel

    I have a vb script for the SO object and when my validation fails I want the Lines panel to have focus to minimize the user having to click it.
  • SendKeys

    Hi All. Using Sage 100 2022 Advanced. I am having an issue with the below script where it runs but then fails on objShell.SendKeys"CREATEITEM"&(NRF). It is executing on client side. Note sure where the issue is. Basically it cancels the item maintenance…
  • Adding display only field to panel twice

    Hi, Is there a simple way to get around this to add a display-only field twice in the same object but on a different panel? I have thought of a few ways but none are easy. Thanks, Gordon Graham
  • 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…
  • which event trigger when add one sales order line and want unit price change follow a specific rule

    when add one sales order line, we want some item default unit price automatically changes according to a price type defined in order header, which event should we use to trigger a script to get that price, I tried column pre-validate and post-validate…
  • In Sage 100 2023, why does the HandleScriptUI method now get Error #88 after InvokeButton?

    To reproduce, in either 32-Bit or 64-Bit Sage 100, create an "Execute Script on Server" button in either Customer Maintenance or Item Maintenance (maybe any panel) that runs a simple two line script: retVal = oScript.InvokeButton("BT_LINK_2") retVal…