Can a custom SQL object be used to convert the SOP Type from 3 to Invoice in the SmartFill Select Record window?
Yes. You can also use the new Field Mapping feature in SmartFill to accomplish this. Field Mapping is available only for table fields (i.e., it is not available for constant values). The only types of fields that can be mapped are ones that have a string datatype, or a numeric datatype that is not a Currency type. For instance, Integers and Drop-down List fields can use Field Mapping; Date fields and Currency fields cannot.