Custom Fields Calculation on child table

Frappe Framework Custom Script
1

Hello,
on my quotation item i created three custom fields GST, GST Amount, Total Amount. can be seen in below pic

Screenshot_2020-02-12_05-38-21
Screenshot_2020-02-12_05-38-21865×315 11.3 KB

i calculated the gst amount with help the following script

frappe.ui.form.on('Quotation Item', {
	gst:function(frm,cdt,cdn){
		var d = locals[cdt][cdn];
		var gst_amount = flt(d.amount) * flt(d.gst) / 100 ;
		frappe.model.set_value(cdt, cdn, "gst_amount", gst_amount);
	}
})

now i want to modify this script to calculate the total amount field.
total_amount = amount + gst_amount

2

Hi,
use loop for gst_amount calculation and then set total_amount value.

3

Actually i m not good at scripting thats why i asked

4

any one …

5

Hi,
use it, it worked.

quotation
quotation1009×273 40.8 KB

3 Likes
6

Works like a charm. thanks

7

@Jitendra_Rathod I need one last modification to this script …
the script calculation trigger whenever i update gst field which is the way i wanted. but i need the scrip to recalculate the values when the amount field updated.

8

Hi,
use it.
amount:function(frm,cdt,cdn){
“====your script====”
}

1 Like
9

there was issues to set script for the amount field as it is read only field and not input field. anyway i modify the script a bit and its working for my current situation sharing the script as it might helpful for the community.

frappe.ui.form.on('Quotation Item', {
	gst:function(frm,cdt,cdn){
		var d = locals[cdt][cdn];
		var gst_amount = (flt(d.qty) * flt(d.rate)) * flt(d.gst) / 100 ;
		frappe.model.set_value(cdt, cdn, "gst_amount", gst_amount);
		var total = (flt(d.qty) * flt(d.rate)) + flt (d.gst_amount);
		frappe.model.set_value(cdt, cdn, 'total_amount', total);
	},
	qty:function(frm,cdt,cdn){
		var d = locals[cdt][cdn];
		var gst_amount = (flt(d.qty) * flt(d.rate)) * flt(d.gst) / 100 ;
		frappe.model.set_value(cdt, cdn, "gst_amount", gst_amount);
		var total = (flt(d.qty) * flt(d.rate)) + flt (d.gst_amount);
		frappe.model.set_value(cdt, cdn, 'total_amount', total);
	},
	rate:function(frm,cdt,cdn){
		var d = locals[cdt][cdn];
		var gst_amount = (flt(d.qty) * flt(d.rate)) * flt(d.gst) / 100 ;
		frappe.model.set_value(cdt, cdn, "gst_amount", gst_amount);
		var total = (flt(d.qty) * flt(d.rate)) + flt (d.gst_amount);
		frappe.model.set_value(cdt, cdn, 'total_amount', total);
	}
})
1 Like