Scripting

What rules would cause ""Not in IOList"" error on SO Order Lines object (called from ItemCode column Post_Validation. I checked this by putting the SetValue immediately after the successful GetValue on the same Unit of Measure field. retval=oBusObj.GetValue(""ItemType$"",sItemType) retval = oBusObj.GetValue(""UnitOfMeasure"",sSalesUOM) retval = oBusObj.SetValue(""UnitOfMeasure"",sSalesUOM) ! Returns ""Column is not in the IOList"" as LastErrorMsg sMsg = "" Setting Unit of Measure - Last error was: "" & oBusObj.LastErrorMsg ' returns Column is not in the IOList - ?? that column used OK above in GetValue retval = oSession.AsObject(oSession.UI).MessageBox("""",sMsg)

UnitOfMeasure should be a string field and you are missing the ""$"".

Details, details. Good catch, thanks.

can say that again. This particular scenario can easily happen when editing in notepad++. At least for me, it doesn't automatically select the ""$"" when you double click on a value between double quotes. So there have been times i was selectively copying field names and missed the fact it didn't pick up the ""$"", An easy way to catch this would be if you are consistent in your variable naming and spacing, You can use this regex expression ""\w"",( s|s)"" without the outside double quotes to find all lines where there is not a ""$"" following the field name and the variable after the comma starts with s.

Interesting, thanks.