How to get total of amount from table

ERPNext
1

tablle
tablle1540×499 35.2 KB

tot
how to get total of amount from table to text box

2

Hi @GhadaEbrahim,

Please check it.

Thank You!

1 Like
3

@GhadaEbrahim as your problem,

    validate: function(frm) {
        total_sum= 0;
        $.each(frm.doc.payment_details,  function(i,  d) {
            total_sum = total_sum + flt(d.collection_amount);
        });
    } ;

hopes it will work

4

i tried both scripts but when i click on save its not working

scripppt
scripppt889×384 12 KB

script2
script21000×390 12.3 KB

5

Try this

frappe.ui.form.on('Old Purchase',  {
    validate: function(frm) {
        var total = 0;
        $.each(frm.doc.historical_purchase,  function(i,  d) {
            total += flt(d.collected_amount);
        });
        frm.set_value("debt_collected_amount", total);
         refresh_field("debt_collected_amount");
    } 
});
6

I have tried it still but its not fetching the total amount from table

7

Hey @GhadaEbrahim,

I think, you not proper understand.

Plesae match with field and doctype.

Supplier → Parent DocType
frm.doc.payment_details → Child Table field name in Parent DocType
d.collected_amount → Child table field name which you want to calculate in parent field.
debt_collected_amount → Parent Doctype field name.

frappe.ui.form.on('Supplier',  {
    validate: function(frm) {
        var dca = 0;
        $.each(frm.doc.payment_details,  function(i,  d) {
            dca += flt(d.collected_amount);
        });
        frm.set_value("debt_collected_amount", dca);
    } 
});

I hope this helps.
Thank You!

2 Likes
8

Thanks … its help me.

in same table i need to add function if type of payment = cheque and cheque is not clear don’ t calculate the amount in total amount .

1
11861×673 56 KB

2
2784×153 3.03 KB

9

Just Add if condition

frappe.ui.form.on('Old Purchase',  {
    validate: function(frm) {
        var total = 0;
        $.each(frm.doc. payment_details,  function(i,  d) {
            //set your child table field name
            if (d.payment == "cheque" && d.cheque == "clear"){
            total += flt(d.collected_amount);
        }});
        frm.set_value("debt_collected_amount", total);
         refresh_field("debt_collected_amount");
    } 
});