Scripting

Need a script to read the SO_SalesOrderDetail file and if a value exists in the UDF_EXT field use that value to replace the ExtendedDescriptionKey if not read the next record. Can anyone help?

You would move through the SO Detail lines, on a Pre-Write of the Sales Order and make the changes. Are you certain the UDF_EXT field keys will be valid keys?

What Lee says is correct but you would be wise to also write in the validation logic of the EXT to make sure whatever is entered are valid, a user entered field like that you can be guaranteed someone will key it wrong.

Thank you for the suggestions and quick response. We got it fixed!