Sum column in child table and show total in parent field

dufani1 · January 10, 2018, 7:00pm

Please help I tried to run the following custom script but it is not work:

frappe.ui.form.on(“Project test invoice”, “validate”, function(frm) {
set_total_01(frm);
})
frappe.ui.form.on(“sum test table”, “qty_11”, function(frm, cdt, cdn) {
set_total_01(frm);
})
var set_total_01 = function(frm) {
var total_01 = 0.0;
$.each(frm.doc.table_2, function(i, row) {
total_01 += flt(row.qty_11);
})
frm.set.value(“total_01”, total_01);
frm.refresh();
}

parent doctype name is:Project test invoice
parent total field is: total_01
child table name is: sum test table
child table name in parent doctype is: table_2
column to be sum name in child table is: qty_11

Parent doctype:

Child table:

Result:

Mohammed_Redha · January 10, 2018, 7:05pm

please look in this :

dufani1 · January 10, 2018, 7:21pm

please @Mohammed_Redha I tried but still not work help me in my case, I am not a programmer

Mohammed_Redha · January 10, 2018, 7:23pm

@dufani1 show me your code after editing, please.

dufani1 · January 10, 2018, 7:30pm

I need just total of column, this is the code:

frappe.ui.form.on(“sum test table”, “qty_11”, function(frm, cdt, cdn){
var d = locals[cdt][cdn];
frappe.model.set_value(d.doctype, d.name, “qty_11”);

var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });

frm.set_value(‘total_01’, total_01);

});

Mohammed_Redha · January 10, 2018, 7:40pm

put this script under parent doctype:

frappe.ui.form.on(“sum test table”, “qty_11”, function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });

frm.set_value(‘total_01’, total);
refresh_field("total_01");

});

dufani1 · January 10, 2018, 7:46pm

I got the following error:

Mohammed_Redha · January 10, 2018, 7:52pm

Try again :

frappe.ui.form.on("sum test table", "qty_11", function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });

frm.set_value("total_01", total);
frm.refresh_field("total_01");

});

dufani1 · January 10, 2018, 7:59pm

Dear @Mohammed_Redha it works but there is an issue that when I remove a raw the total not updated.

Mohammed_Redha · January 10, 2018, 8:05pm

For your reference :

https://frappe.io/docs/user/en/guides/app-development/trigger-event-on-deletion-of-grid-row

put the same code on delete

dufani1 · January 10, 2018, 8:59pm

Sorry @Mohammed_Redha for disturbance.
Shall I use this? Script under parent or child table ?
frappe.ui.form.on(‘Item Color’, {
color_remove: function(frm) {
// Deleting is triggered here
}

Mohammed_Redha · January 10, 2018, 9:23pm

@dufani1 write this code in parent js doctype:

frappe.ui.form.on("Project test invoice", {
table2_remove:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });

frm.set_value("total_01", total);
refresh_field("total_01");
	}
});

dufani1 · January 10, 2018, 10:13pm

@Mohammed_Redha

frappe.ui.form.on(“Project test invoice”, {
table_2_remove:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });

frm.set_value(“total_01”, total);
refresh_field(“total_01”);
}
});

sorry not work this is the result:

dufani1 · January 11, 2018, 8:16pm

Dear @Mohammed_Redha please advise regarding this issue if you have time.

Mohammed_Redha · January 12, 2018, 10:33am

@dufani1 PM Me to help you.

dufani1 · January 12, 2018, 10:46am

@Mohammed_Redha I did not got your point? الرجاء التوضيح

Mohammed_Redha · January 12, 2018, 10:48am

@dufani1 I sent a private massage, please check.

Mohammed_Redha · January 12, 2018, 11:49am

@dufani1 try this :

frappe.ui.form.on("sum test table", {
   qty_11:function(frm, cdt, cdn){
   var d = locals[cdt][cdn];
   var total = 0;
   frm.doc.table_2.forEach(function(d) { total += d.qty_11; });
   frm.set_value("total_01", total);
   refresh_field("total_01");
 },
   table2_remove:function(frm, cdt, cdn){
   var d = locals[cdt][cdn];
   var total = 0;
   frm.doc.table_2.forEach(function(d) { total += d.qty_11; });
   frm.set_value("total_01", total);
   refresh_field("total_01");
   	}
   });

dufani1 · January 12, 2018, 12:55pm

Thanks a lot @Mohammed_Redha the following code working properly:

frappe.ui.form.on(“sum test table”, {
qty_11:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });
frm.set_value(“total_01”, total);
refresh_field(“total_01”);
},
table_2_remove:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.table_2.forEach(function(d) { total += d.qty_11; });
frm.set_value(“total_01”, total);
refresh_field(“total_01”);
}
});

mosabamf · November 4, 2019, 7:01pm

I need urgent help:

I’m new to scripting and I’ve used the same code but it does not work and gave me below error:

Code used is:

frappe.ui.form.on(“Project Item”, {
contract_amount:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.scope.forEach(function(d) { total += d.contract_amount; });
frm.set_value(“total_contract_amount”, total);
refresh_field(“total_contract_amount”);
},
scope_remove:function(frm, cdt, cdn){
var d = locals[cdt][cdn];
var total = 0;
frm.doc.scope.forEach(function(d) { total += d.contract_amount; });
frm.set_value(“total_contract_amount”, total);
refresh_field(“total_contract_amount”);
}
});

Fields are:

Parent total field is: total_contract_amount
child table name is: Project Item
child table name in parent doctype is: scope
column to be sum name in child table is: contract_amount