Calculate Child Table Column and Sum it on Custom Field

-
frappe.ui.form.on('Parent Doctype', {
refresh(frm) {
frappe.ui.form.on('Child Doctype', {
        child_doctype_field:function(frm, cdt, cdn){
            var d = locals[cdt][cdn];
            var totalx = 0;
            frm.doc.Field_Name_in_Parent.forEach(function(d) { totalx += flt(d.child_doctype_field); });
            frm.set_value("custom_field", totalx);
            refresh_field("custom_field");
            },
        table_4_remove:function(frm, cdt, cdn){
            var d = locals[cdt][cdn];
            var totalx = 0;
            frm.doc. Field_Name_in_Parent.forEach(function(d) { totalx += flt(d.child_doctype_field); });
            frm.set_value("custom_field", totalx);
            refresh_field("custom_field");
            }
        });

});

Comments

Post a Comment

Popular posts from this blog

Why ERP need for Bussiness or Organization

-
 ERP systems integrate all business the executives capacities including arranging, stock/materials the board, designing, request handling, assembling, bookkeeping and money, HR and so forth The greatest benefit of an ERP framework dependent on its ongoing capacities and the capacity to see what is new with the association as it occurs.  Establishment of an ERP system has many benefits. The benefits might be both immediate and backhanded. The immediate benefits incorporate proficiency improvement, coordination of data, quicker reaction time to client inquiries, and so forth Illustration of circuitous advantages incorporate better corporate picture, further developed client altruism, consumer loyalty, etc. A portion of the advantages are as per the following :  Incorporating and sharing of data across various offices.  Lessening repetitive information section and cycles.  Assurance for the security of association information.  Better correspondence across dif...
Read more