Fetch from child table field

1

Hi all i want to fetch value from child table field value into another field in the same child table there is one field in child table called item group. i want to fetch value based on item group field.
If item group is unprocessed seed i want quantity to be get updated in total_unprocessed_seed field.

frappe.ui.form.on(‘Stock Entry Detail’, {
item_group: function(frm,cdt,cdn) {
var d = locals[cdt][cdn];
if(d.item_group == “Unprocessed Seed”)
{
frappe.model.set_value(cdt, cdn, ‘total_unprocessed_seed’, d.qty);
}
elif(d.item_group == “Processed Seed”)
{
frappe.model.set_value(cdt, cdn, ‘total_processed_seed’, d.qty);
}
elif(d.item_group == “Remnant Seed”)
{
frappe.model.set_value(cdt, cdn, ‘total_reminant_seed’, d.qty);
}
elif(d.item_group == “Treated Seed”)
{
frappe.model.set_value(cdt, cdn, ‘total_treated_seed’, d.qty);
}
elif
{
frappe.model.set_value(cdt, cdn, ‘total_untreated_seed’, d.qty);
}

   console.log("hi");
}

});

this is my code written in client script.
please help got stuck with these.

2

Hi @SonalD,

Please apply/try it.

frappe.ui.form.on('Stock Entry Detail', {
    item_group: function(frm,cdt,cdn) {
        var d = locals[cdt][cdn];
        if (d.item_group == "Unprocessed Seed") {
            frappe.model.set_value(cdt, cdn, 'total_unprocessed_seed', d.qty);
        } else if (d.item_group == "Processed Seed") {
            frappe.model.set_value(cdt, cdn, 'total_processed_seed', d.qty);
        } else if (d.item_group == "Remnant Seed") {
            frappe.model.set_value(cdt, cdn, 'total_reminant_seed', d.qty);
        } else if (d.item_group == "Treated Seed") {
            frappe.model.set_value(cdt, cdn, 'total_treated_seed', d.qty);
        } else {
            frappe.model.set_value(cdt, cdn, 'total_untreated_seed', d.qty);
        }
        console.log("hi");
    }
});

Thank You!

3

thank you NCP for your reply, but the script is not working

4

the scenario is as follows:
i want to calculate child table(stock entry detail) quantity sum into parent doctype (stock entry)field depends on item group condition.

For example, if my item group is unprocessed seed i want all those items quantity whose item group is unprocessed seed to be calculated in parent field name total unprocessed seed qty.

5

Please check it.
Maybe it helps you.

Thank You!

6

Thank you so much NCP. It is working.