vtiger

[paulward2016]

I HAVE A CUSTOM FIELD IN THE TABLE FOR PRODUCT DETAILS IN THE SALES ORDER EDIT VIEW... I AM TRYING TO GET THIS FIELD TO DISPLAY UNDERCHARGES. (UNDERCHARGES ARE THE DIFFERENCE BETWEEN THE UNIT PRICE AND THE LIST PRICE) I CAN'T FIGURE OUT HOW TO GET THE UNIT PRICE PER LINE SO WE CAN CALCULATE THE UNDERCHARGES. COULD ANYONE OFFER ANY SUGGESTIONS

A LITTLE MORE DETAILED I NEED TO ON EVERY LINE HAVE THE UNIT PRICE - LIST PRICE * QTY = UNDERCHARGE. I HAVE THE TABLE SET UP AND I CAN DISPLAY WHAT I NEED I JUST CAN'T FIND OUT EXACTLY WHERE TO GET THE UNIT PRICE AS THE ONLY THING IN CODE THAT I CAN SEE IS THE TXTLISTPRICE AND I HAVE TRIED unitPrice, unitprice1, and several others. I just can't get it to work any help would be much appreciated.

I HAVE THE CALCULATION READY TO GO IF I COULD GET THE VARIABLE FOR THE UNIT PRICE HERE IS THE LITTLE TIDBIT OF CODE THAT I HAVE TO CALCULATE PLEASE HELP


function calcTotal(currObj) {
var trObj=currObj.parentNode.parentNode
var rowId=parseInt(trObj.id.substr(trObj.id.indexOf("w")+1,trObj.id.length))
var total=eval(getObj("txtQty"+rowId).value*getObj("txtListPrice"+rowId).value)
getObj("total"+rowId).innerHTML=getObj("hdnTotal"+rowId).value=roundValue(total.toString())
calcGrandTotal()
var ucprice=eval(getObj("unitPrice"+rowId).value-getObj("txtListPrice"+rowId).value)
getObj("undercharge"+rowId).innerHTML=roundValue(total.toString())
}

THIS IS JUST CALCULATING THE TOTAL AND PUT IN THE UNDERCHARGE FIELD.... ANY HELP WOULD BE APPRECIATED