The issue with this is that the cost is not a field in the line detail file because the cost is not assigned until the order is invoiced.  You can get a close estimate by using the cost from the item master but not exact.

Hi Dave:

I recently customized a client's Sage 100 (MAS90/MAS200) sales order entry lines tab to calculate the GP Amt and GP% for the line during entry.  I also had a summary for the entire order  show below.  It may be done with a few user-defined fields and custom scripting.

Thanks,

Tina Beck

Competitive Strategies, Inc.

www.WeMakeSoftwareWork.com

It is available in 2013 and above. I believe in SO Options.  It uses last cost, so if that is a problem, you need a udf and a script.

rExtcost=0

rExtamount=0

rQtyorder=0

rUnitcost=0

rLineGM=0

rUnitprice= 0

rDefault = 0

retVal=obusobj.GetValue("UnitPrice", rUnitprice)

retVal=obusobj.GetValue("ExtensionAmt", rExtamount)

retVal=obusobj.GetValue("QuantityOrdered", rQtyorder)

retVal=obusobj.GetValue("UnitCost", rUnitcost)

rExtcost= rqtyorder * rUnitcost

If rExtamount > "0.0000" then

rLineGM= ((rExtamount - rExtcost)/rExtamount)*100

retVal = oBusObj.SetValue("UDF_LINE_GM", rLineGM)

else

retVal = oBusObj.SetValue("UDF_LINE_GM", rDefault)

end if