Custom Modification to Order Entry Screen

Question

Has anyone done a custom modification to the order entry screen to show the gross margin on the order as the order is being entered or as the order is being updated?

Dean Yeater · Answer

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

Sage 100

Custom Modification to Order Entry Screen

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING