Anybody?

Maybe the InvokeChange method? (assuming 4.50 or above)

Generic Example:

retval = oUIObj.InvokeChange("ML_Customer",strVal)

I have not tested this, but this appears to be tied to the form as opposed to the data object. ML_Customer is the button or control on the data entry form.

The documentation says:

"Used to change the value of a control on the screen or a column in a grid. This method may be useful for certain situations where there is unique logic associated with changing the value of a control on the screen or in a grid which is not invoked via oBusObj.SetValue(). E.G. Changing the quantity ordered in a sales order line does not update the "Total Amount" displayed on the lower right corner of the Lines tab."

Hi Jon_K

Just an FYI in the 2015 release we added warehouse code to the ship-to address table.  But as you are on 2014 that isn't going to solve you're problem. [:)]

The reason the screen isn't updating is because the "screen" object name is actually ML_WarehouseCode (this was done because of a conflict with the lines screen), so the business object value is getting changed, we just need to update the screen.  If you use InvokeChange() it will be as if the user had entered the value themselves. 

So, you can add this to your script after the SetValue()

sWarehouse = ""
retVal = oBusObj.GetValue("ShipToCode$", sWarehouse)
retVal = oBusObj.SetValue("WarehouseCode$", sWarehouse)

If retVal<>0 Then
   ' Check to see a UI is present before trying to update the screen value.  This is the recommended method to do so
   MASUI = False
   IF (IsObject(oUIObj)) Then
      MASUI = True
   Else
      MASUI = CBool(oScript.UIObj)
      If (MASUI) Then
         Set oUIObj = oSession.AsObject(oScript.UIObj)
      End If
   End If

   If (MASUI) Then ' Set UI Value using InvokeChange()
      retVal = oUIObj.InvokeChange("ML_WarehouseCode", sWarehouse)
   End If
End If

 

Hope that helps.  

Elliott

Thank you Tom and Elliott, you guys are the best! Is there a place where I can get up to date scripting documentation? I have a document called ScriptingPlus-v170 that someone gave to me and it has some great info in it but InvokeChange isn't even mentioned there.

Jon_K the latest version of the scripting doc is on the thread linked below it is based on the document you have.

sagecity.na.sage.com/.../248311

Thanks Elliot! I already got to use that technique on one of my own scripts. Specifically forcing an immediate update of the net invoice value on a sales order invoice.