I am trying to populate a UDF with the Gross Margin by line.

Question

I have created a script, and it does not seem to work. Do I put it under column validation, or some other mode. Here is the script. 
 
 Retval=0 rExtcost rExtamount=0 rQtyship=0 rUnitcost=0 rLineGM=0 Set oLines = oBusObj.AsObject(oBusObj.Lines) oLines.MoveFirst do until oLines.EOF retVal=oLines.GetValue("ExtensionAmt", rExtamount) retVal=oLines.GetValue("QuantityShipped", rQtyship) retVal=oLines.GetValue("UnitCost", rUnitcost) rExtcost= rqtyship * rUnitcost rLineGM= ((rExtamount - rExtcost)/rExtamount)*100 retVal = oBusObj.SetValue("UDF_LINE_GM", rLineGM) retVal=oLines.MoveNext() loop

TomTarget · Answer

Would be helpful if you can tell us which line in the script is throwing the error. 
 I typically put msgbox() functions to display pop ups and you can tell where you are when the error occurs. 
 However, my guess is that if this script is attached to a field in the SO_SalesOrderDetail file, all of the references to oLines should be ObusObj. 
 oLines would only be used if the script was attached to SO_SalesOrderHeader and you then needed to access the detail lines associated with the header record.

Sage 100

I am trying to populate a UDF with the Gross Margin by line.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING