cur_frm.cscript.custom_total_2014 = function(doc) {
total_incentive = doc.january + doc.february + doc.march + doc.april + doc.may + doc.june + doc.july + doc.august + doc.september + doc.october + doc.november + doc.december;
doc.total_2014 = total_incentive;
}
Regarding the above script i need some help.
I created several custom fields and i want to make some automatically calculations through the custom fields.
The above calculations working OK but i need to have some more fields calculations.
Can you advice please.
anand
#2
Can you be more specific about what you want ?
-Anand
Attached screenshot.
Nevertheless, All the fields are customs. I need to do the following calculations
- SUM of Total T (2014)
- SUM of Total B (2014) then,
- T remaining 2014 = Yearly T - Total T (2014)
Thanks in advance!
<img src=“/uploads/default/182/35350ef6cb7e8e2f.png” width=“561” height="500
Hi Rmehta,
with this code i can calculate only SUM of Total T (2014)
I need to calculate at the same time, so i need the SUM of Total B (2014) and subtraction for T remaining 2014
Can you advice for any solution?
rmehta
#6
Sorry I am unable to understand where you are stuck?
OK let me try to explain you better
I want to calculate the sum of the year for both columns Total T (2014) and Total B (2014) after that i want to calculate
T remaining 2014 = Yearly T - Total T (2014)
This code is ONLY the calculation of Total T (2014) and i want to do the rest calculations
Is there any help or update?
Thanks
rmehta
#9
I am still not able to understand your issue. What you are asking is simple addition which should work? What is Yearly T
where does it come from?
I suggest, you can engage a freelancer to help you out if you want to get this done asap.
i have to coded like this but no output any one advie to calculate this total
cur_frm.add_fetch("budgeted_amount", "purchased_amount", "excess_amount");
frappe.ui.form.on("budgeted_amount", "purchased_amount", function(frm, doctype, name) {
cur_frm.cscript.custom_validate = function(doc) {
var budgeted_amount=budgeted_amount;
var purchased_amount=purchased_amount;
var excess_amount=0;
doc.excess_amount=purchased_amount-budgeted_amount;
doc.budgeted_amount=budgeted_amount;
doc.purchased_amount=purchased_amount;
}
});
Try this:
frappe.ui.form.on("Task", "budgeted_amount", function(frm) {
calculate_excess_amount(frm);
})
frappe.ui.form.on("Task", "purchased_amount", function(frm) {
calculate_excess_amount(frm);
})
var calculate_excess_amount = function(frm) {
var excess_amount = flt(frm.doc.purchased_amount) - flt(frm.doc.budgeted_amount);
frm.set_value("excess_amount", excess_amount);
}
sorry no i think not working can you this image
@Senthil_Kumar check this script, also you can see browser console for error log
frappe.ui.form.on("Task", "budgeted_amount", function(frm) {
calculate_excess_amount(frm);
});
frappe.ui.form.on("Task", "purchased_amount", function(frm) {
calculate_excess_amount(frm);
});
var calculate_excess_amount = function(frm) {
var excess_amount = flt(frm.doc.purchased_amount) - flt(frm.doc.budgeted_amount);
frm.set_value("excess_amount", excess_amount);
}
2 Likes
its working thakn you so much…

rmehta
#16
@Senthil_Kumar try sending a real gift 
1 Like