Hi everyone,
I'm wondering if I could get your help on this. I have a simple Drop-Down Box UDF with 3 possible values in SO_Header (validated against its own list). At the creation of the UDF, the default value was set to the value "None", which I confirm to be true still by checking the field property just now. The problem is that the field doesn't get populated with the default value when a new order record is created.
The funny thing is that I'm able to set the default value through the Event Scripts, but only at Table-Pre/Post Write or Column Pre/Post events levels. The Table - Set Default Values doesn't work.
- Whey doesn't the default value get populated by the value defined by the field (obviously there is no default set by UI)?
- What am I doing wrong here in scripting at the Set Default Values event?
- What else should I look into for clues on if something else is stopping the default value to be set??
The script is as simple as it can get.
retVal = oBusObj.SetValue("UDF_DELIVERY_CONFIRMATION$", "None")
This field's value is relevant to the user input to a different field, so it's also tied to the Column Post-validate event. But no scripts tied to this field or other fields are executed with the default value of "None" as they will all exit sub.
Ken