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. [Screenshot 2024-05-02 at 2.53.23 AM]

Hi [image] 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); }…

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.

Hi, [image] Sum fields in child table and show total in parent field ERPNext 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) { …

Frappe.io Frappe Cloud Documentation Partners Frappe School Marketplace GitHub

Frappe Forum

How to calculate column in child table

ERPNext

Yamen_Zakhour May 1, 2024, 8:51pm 2

Hi