How can I Total up rows in a child table to display result in parent custom field

Frappe Framework Customization
1

Hi guys,

I have a custom doctype and would like to get total of rows in child table displayed in parent table custom field. Below is my script. But its not working. Any advice is appreciated

frappe.ui.form.on(“Sales Report Details”, “sales”, function(frm, cdt, cdn) {
// code for calculate total and set on parent field.
total_sales = 0;
$.each(frm.doc.shop || [], function(i, d) {
total_sales += flt(d.sales);
});
frm.set_value(“sum_sales”, total_sales);
});

Child table: Sales Report Details
Parent table: Sales report
Custom field in Parent table is sum_sales

sales report child
sales report child1226×837 81 KB
sales report parent
sales report parent1246×895 99.1 KB

2

Use frm.doc.table_3 instead of frm.doc.shop.

3

thanks @nabinhait. I try this