Sage 100

I'm taking a stab at what I feel is a simple script to calculate the Extension amount on an SO line. Here is my script, which is not working: numPrice = 0 numQTY = 0 retVal = oBusObj.GetValue(""UDF_SO_LINE_SPECIAL_PRICE"", numPrice) retVal = oBusObj.GetValue(""UDF_SO_LINE_TESTQTY"", numQTY) retVal = oBusObj.SetValue(""ExtensionAmt"", numPrice * numQTY) My UD Script is on the SO Sales Order Detail table and the Event is Column - Post Validate. I have the External Access checkbox on in Company Maintenance. Can anyone tell me what it is I have wrong?

Column - Post Validate on which Field? Probably should have on both UDFs above. If either one changes, the extension amount is recalculated.

Post validate on the Extension field - see attachment.

Attachment here

I think you are firing the script from the wrong fields. Don't you want the script to run on the post-val of UDF_Special_Price and/or UDF_TESTQTY?

I think you may also need your script on the CPV event of the quantity and price field if you need to override either of their changes.