How to calculate column in child table

[Harvey_Balce]

Hello I want to calculate SS and EC field in child table per row that should be on the total field. I tried to look for answers for hours but no avail, hopefully someone can help me.

Thanks in advance!

below are the screenshot.

[Yamen_Zakhour]

Hi

How to do calculation in child table rows

frappe.ui.form.on("Gatepass Detail", { quantity: function(frm, cdt, cdn) { calculateTotalWeight(frm, cdt, cdn); }, weight: function(frm, cdt, cdn) { calculateTotalWeight(frm, cdt, cdn); } }); function calculateTotalWeight(frm, cdt, cdn) { var d = locals[cdt][cdn]; var totalValue = d.quantity * d.weight; frappe.model.set_value(cdt, cdn, 'total_weight', totalValue); // Optionally refresh the field if necessary // frm.refresh_field('total_weight'…

[Harvey_Balce]

Thank you!, This code works…

[Harvey_Balce]

How about I have total in the child table and sum it up in main form?
For example, i have xfield in mian form which shows sum of all totals in child tables?

like for example tax in quotation has a sum of total taxes in main form.

Thanks again in advance.

[Yamen_Zakhour]

Hi,

Sum fields in child table and show total in parent field

Hi @msiam, Please apply custom/client script. frappe.ui.form.on('Sales Invoice', { validate: function(frm) { ttl_itms_dicnt = 0; $.each(frm.doc.items, function(i, d) { ttl_itms_dicnt += flt(d.discount_amount); }); frm.doc.total_items_discount = ttl_itms_dicnt; } }); Please check your field name and set it according. Then reload and check it. Thank You!