Compute grand total before saving?

1

in my landed cost voucher i create another field to get over all grand total. how to compute this before saving ? see the image below.

image
image1300×945 39.9 KB

2

over all grand total, meaning sum of all Grand Totals?

In that case, you can make a custom field to have the overall grand total. Then you can write a trigger on the child table that update the custom field with the total. The logic in the custom script here can help:

Trigger on the child table means that the custom field will be updated whenever there is a change in the rows on child table, even before saving.

3

hi @pratu16x7 thank you for response.

yes i want to sum all grand totals. can you help me with my custom script, the computation is working after saving but i want to compute all grand total before saving.

frappe.ui.form.on("Landed Cost Voucher", "refresh", function(frm, cdt, cdn) {
          data_44 = 0;
          $.each(frm.doc.purchase_receipts || [], function(i, d) {
                      data_44 += flt(d.grand_total);
          });
          frm.set_value("data_44", data_44);
    });
4

use this

frappe.ui.form.on("Landed Cost Purchase Receipt", "grand_total", function(frm, cdt, cdn) {
              data_44 = 0;
              $.each(frm.doc.purchase_receipts || [], function(i, d) {
                          data_44 += flt(d.grand_total);
              });
    	console.log(data_44);
              frm.set_value("data_44", data_44);
    		
        });
2 Likes
5

hi! @Maheshwari_Bhavesh thank you for response it works thanks a lot :slight_smile: you may closed this report.

6

mark as solution from your side…