Inside Table Computation

[123elbmuh]

Hi Sir/Ma’am,

I’m new with ERP.

Based on image sample. I would like to compute using custom script. From sample 1 multiply to sample 2 and the resulting amount will show to Amount Display. Thanks for the help.

[NCP]

Hi @123elbmuh,

Please check its topic.

Then apply custom/clinet script.

Calculate (SUM) two fields and display the result on the third field on child table

Hi @NinYo, Please apply it. frappe.ui.form.on("Appraisal Template - Performance", { p_rating: function(frm,cdt,cdn) { var d = locals[cdt][cdn]; frappe.model.set_value(cdt, cdn, 'p_score1', (d.p_rating + d.p_weight)); } }); // Syntax frappe.ui.form.on("Child Table Name", { field_name_for_trigger_to_value_calculate: function(frm,cdt,cdn) { var d = locals[cdt][cdn]; frappe.model.set_value(cdt, cdn, 'child_table_total_value', (d.child_table_value1 + d.c…

Hope it help you!

Thank You!